Database Reference
In-Depth Information
5. To import the .publishSettings ile, run the following command:
Import-AzurePublishSettingsFile
"C:\Users\Administrator\Downloads\Azdem181k94193T-3-Month Free
Trial-12-12-2012-credentials.publishsettings"
6. To view the subscriptions, run the following command:
Get-AzureSubscription
7. To select the subscription for your project, for example, run the following command:
Select-AzureSubscription '3-Month Free Trial'
8. You are now ready to manage your databases. To create an SQL Database server, use
the New-AzureSqlDatabaseServer cmdlet shown below:
PS C:\
>
New-AzureSqlDatabaseServer -AdministratorLogin COSC6301 -
AdministratorLoginPassword Student1 -Location "North Central US"
9. he result is shown in Figure 12.19. A random name, dwsyk1avsf, is assigned as the
server name.
10. For the newly created SQL Database server, as an example, you can create a irewall
rule to allow the computers with the IP addresses from 129.0.0.0 to 129.255.255.255
to access the SQL Database server on Windows Azure. To create a irewall rule, use
the following command:
PS C:\
>
New-AzureSqlDatabaseServerFirewallRule -RuleName MyRule -
ServerName dwsyk1avsf -StartIpAddress 129.0.0.0 -EndIpAddress
129.255.255.255
he result is shown in Figure 12.20.
Figure 12.19
Create new SQL database server in Windows Azure PowerShell.
Figure 12.20
Create irewall rule with Windows Azure PowerShell.