Created a New Azure SQL Server but its not appearing in SSMS

Debbie Edwards 521 Reputation points
2020-12-10T10:48:23.157+00:00

I have created a new Server on Azure However I go into SSMS and I can log into this server, but its not appearing in the server window ![46761-serverissue.jpg][1] [1]: /api/attachments/46761-serverissue.jpg?platform=QnA this means that I cant create scripts against the server Im connected too Any advice on this one would be great. I dont currently know what to do so I'm blocked Im on the latest Version of SSMS I think SQL Server Management Studio 15.0.18358.0

Azure SQL Database

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Olaf Helper 41,001 Reputation points
    2020-12-10T11:09:44.76+00:00

    SQL Azure are all independent database and to connect to you have to explicit the database for the connection, see Quickstart: Use SSMS to connect to and query Azure SQL Database or Azure SQL Managed Instance

    1 person found this answer helpful.
    0 comments
  2. Debbie Edwards 521 Reputation points
    2020-12-10T11:13:14.977+00:00

    I have already followed this logic and can connect but the server doesn't appear in the top window (Screen shot above)

    0 comments
  3. Anurag Sharma 17,576 Reputation points
    2020-12-10T12:10:29.943+00:00

    Hi anonymous user, welcome to Microsoft Q&A.

    There could be multiple reasons for this behavior. Could you please confirm below points?

    1. The highlighted screenshot provided by you will only show the databases present in the server but not the server name. To check the server name, please refer to below screenshot.

    46849-image.png
    2. Have you created a Azure SQL Server only or Azure SQL Database along with Server? I tried it by creating both, and when I try connecting in case of Azure SQL Server only, then I see the same behavior as mentioned by you. However, in other case I can see the database. Please confirm once.
    3. If you created the Azure SQL database along with Server, are you using admin credentials to connect with it? Or have you created other users and trying to connect with it?

    Lastly, are you able to connect to the Azure SQL Database through the Azure portal and run the queries in Query editor?

    0 comments