Automating database creation using an Azure Powershell Runbook

Question

I am attempting to automate the creation of a database server and database using an Azure powershell runbook.

I have managed to create the server ok, but when I then try to connect to it to create the database and user, I hit firewall issues. I cannot find a way to get the IP address of the runbook so I can add a firewall exclusion.

Any help appreciated!

Rick Rainey · Accepted Answer · 2015-05-14 16:19:11Z

2

After you create the server add the firewall rule that allows Azure services access to it.

New-AzureSqlDatabaseServerFirewallRule -ServerName [your_server_name] -AllowAllAzureServices

answered May 14, 2015 at 16:19

Rick Rainey

11.3k4 gold badges35 silver badges51 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Automating database creation using an Azure Powershell Runbook

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related