![azure sql server connection string azure sql server connection string](https://docs.telerik.com/data-access/images/1gettingstarted-root-quickstart-azure-connectviassms-010.png)
EXEC sp_addrolemember N'db_owner', N'username'.CREATE USER username FROM LOGIN username.CREATE LOGIN username WITH password='password'.Connect with SSMS to the master database.This Stack Overflow answer by StuartLC which in essence are: I had just (apparently wronly so) assumed that the connection string the Azure portal generated when setting things up for me would be one Your first remark got me thinking though, I had not realized I had a master database (or access to parts of one?). That's a much easier way to test if things work than with the actual website.
#Azure sql server connection string how to
![azure sql server connection string azure sql server connection string](https://docs.devart.com/images/review-assistant/db_owner.png)
I've created a connection string in the Azure Preview Portal.