I am trying to connect to an Azure SQL database via SSMS. The connection string supplied by Azure is:
Server=tcp:SERVER_NAME.database.windows.net,1433;Initial Catalog=DATABASE_NAME;Persist Security Info=False;User ID={your_username};Password={your_password};MultipleActiveResultSets=False;Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;
So, first of all I’m not sure if I should include ALL of
tcp:SERVER_NAME.database.windows.net,1433
in the server name when connecting via SSMS. Also, the username is an email address. Let’s say it’s:
foo@bar.com
So, this is what I tried:
ServerName: SERVER_NAME.database.windows.net Login: foo@bar.com@SERVER_NAME.database.windows.net Password: [password]
At first when I tried, I was told that the IP was not allowed. So I added the IP to the server firewall settings. But now, I get this:
Login failed for user foo@bar.com
I am using the same UserID and Password that I use to log into the Azure portal. And it’s the UserID that is specified in the Access Control window.
I am working from home, but I have also tried while on my company’s VPN. Neither work.
Is there something else I’m doing wrong?