Connect your Azure database from your local SSMS #Error 40615
oktober 12, 2015
Ofcourse we wanna access our fresh imported database on Azure locally!
And this is so easy if you just follow these simple steps.
In order to be able to access the database located on your Azure cloud, you have to know the Azure address, which you can find on the Windows Azure Management Portal. Click the database icon and open up the database. Here you will find the connectionstring.
Next step is to make sure Azure knows your device by adding it to the trusted devices in Azure, if your device is unknow to Azure it will bring you the following message:
you can add the device by going to the database icon in Azure and click the CONFIGURE tab. Here you add and save your device IP.
Now you can login to your Azure cloud with the credentials you made while creating the database on Azure.