Cannot connect local Azure Data Studio to Azure SQL Server Database
I am getting an error like this:
The server you specified tcp:xxxx,1433 does not exist in any subscription in xxxx. Either you have signed in with an incorrect account or your server was removed from subscription(s) in this account. Please check your account and try again.
I signed on to Azure and created a SQL Server. I was offered an “Azure signup subscription,” which I accepted. I created a database on the server, and I can see both the server and the database in my Azure dashboard. Now, I want to connect to the database using Azure Data Studio. I am using the connect string to connect.
Server=tcp:<sql server name>.database.windows.net,1433;Initial Catalog=<database name>;Persist Security Info=False;User ID=<user id>;Password=<pw.>;MultipleActiveResultSets=False;Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;
When I click Connect, I am taken to a “Create new firewall rule”. I enter the Azure email account info that I use to signin to Azure. A Firewall rule is created and it ads a client IP which I am not familar with (97.126…).
I click OK for the firewall, and I get this error:
The server you specified tcp:mysqlserver12358.database.windows.net,1433 does not exist in any subscription in 00000000-0000-0000-… (a very long subscription ID that I don’t recognize). Either you have signed in with an incorrect account or your server was removed from subscription(s) in this account. Please check your account and try again.
In setting up Network security on Azure for the SQL server, I have checked “Allow Azure Services and resources to access this server”.
The Azure Data Studio I’m working from is on a home WIFI network.
What do I need to do to connect to Azure SQL Server from my home network?
I am getting an error like this:The server you specified tcp:xxxx,1433 does not exist in any subscription in xxxx. Either you have signed in with an incorrect account or your server was removed from subscription(s) in this account. Please check your account and try again.I signed on to Azure and created a SQL Server. I was offered an “Azure signup subscription,” which I accepted. I created a database on the server, and I can see both the server and the database in my Azure dashboard. Now, I want to connect to the database using Azure Data Studio. I am using the connect string to connect.Server=tcp:<sql server name>.database.windows.net,1433;Initial Catalog=<database name>;Persist Security Info=False;User ID=<user id>;Password=<pw.>;MultipleActiveResultSets=False;Encrypt=True;TrustServerCertificate=False;Connection Timeout=30; When I click Connect, I am taken to a “Create new firewall rule”. I enter the Azure email account info that I use to signin to Azure. A Firewall rule is created and it ads a client IP which I am not familar with (97.126…). I click OK for the firewall, and I get this error:The server you specified tcp:mysqlserver12358.database.windows.net,1433 does not exist in any subscription in 00000000-0000-0000-… (a very long subscription ID that I don’t recognize). Either you have signed in with an incorrect account or your server was removed from subscription(s) in this account. Please check your account and try again. In setting up Network security on Azure for the SQL server, I have checked “Allow Azure Services and resources to access this server”. The Azure Data Studio I’m working from is on a home WIFI network.What do I need to do to connect to Azure SQL Server from my home network? Read More