CODEWITHSUNDEEP
azureazure-sql-database
mrhotdogs
mrhotdogs

Reputation: 53

how to allow Windows Azure Services in SQL Azure via REST API

I have a problem with Windows Azure Rest API create server.

I am able to create an SQL Azure Server via REST API but my problem is that i need it to have the ALLOWED SERVICES = "WINDOWS AZURE SERVICES" set to YES by default. This is very important to me because my website auto generates the servers and databases. If this option is set to NO, the import rest api sends back a 400 bad request response. Is there a way to fix this?

Thanks

Upvotes: 2

Views: 460

Answers (1)

elfisher
elfisher

Reputation: 1230

For enabling Windows Azure Services to access the server, you will need to configure a firewall rule. To create a firewall rule with REST that allows Azure Services to access the server, use create firewall rule. For Windows Azure Services make the start and end ID address 0.0.0.0.

The Request body should look something like the following.

<ServiceResource xmlns="http://schemas.microsoft.com/windowsazure">
     <Name>AllowAzureServices</Name>
     <StartIPAddress>0.0.0.0</StartIPAddress>
     <EndIPAddress>0.0.0.0</EndIPAddress>
</ServiceResource>

Upvotes: 2

Related Questions