Developing Windows Azure and Web Services Lab @ 1 Ans 2 ~ NIIT POST

In this exercise, you have to use Windows Azure Management Portal and create a new Windows Azure SQL Server. You need to connect the new SQL server with SQL Server Management Studio and create a Blue Yonder database from the .bacpac file.

To create a new Windows Azure SQL Server, you need to perform the following steps:

1.Open Internet Explorer.
2.Type https://manage.windowsazure.com in the address bar. and press the Enter key.
3.Enter your email and password in the respective text boxes on the Sign In page.
4.Click the Sign In button. The Windows Azure page is displayed.
5.Click SQL DATABASES in the navigation pane available on the left side. The sql databases page is displayed.
6.Click SERVERS in the top-left corner of the sql databases page.
7.Click the Add displayed, as shown in the following figure.
button at the bottom of the page. The SQL database server settings dialog box
8. Type SQLAdmin in the LOGIN NAME text box.
9. Type PaSSwOrd in the LOGIN PASSWORD and CONFIRM PASSWORD text boxes.
10. Select Southeast Asia from the REGION drop-dov/n list.
11. Click the Complete (right arrow) button.
12. Wait for the server to appear in the list of servers and its status changed to Started.
13. Note the name of the ser/er.
14. Click the name of the newly created server.
15. Click the CONFIGURE tab.
16. Add a new firewall rule by filling the following information in the allowed ip addresses section:
o RULE NAME: OpenAIIIPs
o START IP ADDRESS: 0.0.0.0
o END IP ADDRESS: 255.255.255.255
17. Click the Save SAVE button in the bottom.

18.Press the Windows logo key. The Start screen is displayed.
19.Start typing SQL Server Management Studio. The Search and Apps panes are displayed.
20.Click the SQL Server Management Studio tile. The Connect to Server dialog box is displayed.
21.Type SQLServerName.database.windows.net (replace SQLServerName with the name of the newly created server on Windows Azure).
22.Select SQL Server Authentication from the Authentication drop-down list.
23.Type SQLAdmin in the Login text box.
24.Type PaSSwOrd in the Password text box.
25.Click the Connect button. The Microsoft SQL Server Management Studio window is displayed.
26.Right-click the Databases node in the Object Explorer window, and then select the Import Data-tier Application option from the context menu. The Introduction page of the Import Data-tier Application wizard is displayed.
27.Click the Next button. The Import Settings page is displayed.
28.Ensure that the Import from local disk option is selected.
29.Click the Browse button. The Open dialog box is displayed.
30.Browse to the location where BlueYonder.bacpac file is saved.
31.Select the BlueYonder.bacpac file.
32.Click the Open button.
33.Click the Next button.
34.Click the Next button.
35.Click the Finish button, and wait until the database import procedure is finished.
36.Click the Close button.
37.Press F5 to refresh the database list.
38.Expand the Databases node, and verify that the BlueYonder database is added.
39.Close the Microsoft SQL Server Management Studio window.
40.Switch to the Internet Explorer window.
41.Click the user icon in the upper-right corner of the Windows Azure page. A context menu is displayed.
42.Select Sign out.
43.Close the Internet Explorer window.