SharePointTaskMaster: SQL Azure and Web App on Windows Azure look like

WINDOWS AZURE TOUR

(Social Media by Office 365 and Digimind http://digimindo365-public.sharepoint.com/ )

1. Hi Thomas!

Take this 30 second tour to see how the management portal makes creating and managing your cloud resources easy.

2. Main Menu

Use this menu to access the Windows Azure website, switch display languages, navigate to the previous portal, or to log out of your management session.

3. Create New

You can use this portal to quickly set up new services, resources, and components with minimal initial configuration.

4. Commands

The Command Bar provides quick access to global and contextual commands such as Stop, Configure, and Delete. It gives you immediate control of your services, resources, and components.

5. Notifications

The notifications area provides you with status updates for active commands and service health, as well as quick access to Help.

6. Workspaces - Dashboard - Computer

Create and configure a SQL Azure database

7. Click on [CREATE A SQL DATABASE] to create a SQL AZURE database

8. Specify database settings

9. Successfully creating Database1 on an AZure server

10. Goto more detail of Database1

11. Goto [Set up Windows Azure firewall rules for this IP address]

12. Yes, want to update the firewall rules for ip address [118.69.130.55]

13. The current IP address 118.69.130.55 already has a Windows Azure firewall rule. You should be able to connect to Windows Azure from this computer.

14. Connection strings look like

ADO.NET:

Server=tcp:m5pbpnji9o.database.windows.net,1433;Database=Database1;User ID=DatabaseServer@m5pbpnji9o;Password={your_password_here};Trusted_Connection=False;Encrypt=True;Connection Timeout=30;

ODBC:

Driver={SQL Server Native Client 10.0};Server=tcp:m5pbpnji9o.database.windows.net,1433;Database=Database1;Uid=DatabaseServer@m5pbpnji9o;Pwd={your_password_here};Encrypt=yes;Connection Timeout=30;

PHP:

Server: m5pbpnji9o.database.windows.net,1433 \r\nSQL Database: Database1\r\nUser Name: DatabaseServer\r\n\r\nPHP Data Objects(PDO) Sample Code:\r\n\r\ntry {\r\n $conn = new PDO ( \"sqlsrv:server = tcp:m5pbpnji9o.database.windows.net,1433; Database = Database1\", \"DatabaseServer\", \"{your_password_here}\");\r\n $conn->setAttribute( PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION );\r\n}\r\ncatch ( PDOException $e ) {\r\n print( \"Error connecting to SQL Server.\" );\r\n die(print_r($e));\r\n}\r\n\rSQL Server Extension Sample Code:\r\n\r\n$connectionInfo = array(\"UID\" => \"DatabaseServer@m5pbpnji9o\", \"pwd\" => \"{your_password_here}\", \"Database\" => \"Database1\", \"LoginTimeout\" => 30, \"Encrypt\" => 1);\r\n$serverName = \"tcp:m5pbpnji9o.database.windows.net,1433\";\r\n$conn = sqlsrv_connect($serverName, $connectionInfo);

JDBC:

jdbc:sqlserver://m5pbpnji9o.database.windows.net:1433;database=Database1;user=DatabaseServer@m5pbpnji9o;password={your_password_here};encrypt=true;hostNameInCertificate=*.database.windows.net;loginTimeout=30;

15. Connect to Database1 (SQL AZURE database) look like