When creating a brand-new SQL Azure Database, I was unsure on how to connect to it.
There is a button to “Show connection strings” – but that shows as :
Thee is the ability to open within Visual Studio (bottom row of buttons) – but it would then ask me to provide a password – but HOW/WHAT is it !!??!
It turns out that there is an easy way to do this.
If you consider that each DATABASE will live on a specific SERVER, you need to set the Administrator password for the ‘SERVER’ itself.
- Click on the link for the ‘server’
- Flip to the ‘Dashboard’ tab
- There’s a link to ‘Reset Admin Password’
Obviously – you don’t want to do this for EVERY database – but if you’re doing it for the first time, then you need to SET the password.
P.S. The default login account is : AzureCloudAdmin
Too easy – in the end !
