I have 2 azure sql databases. I can see both databases when logged into the Azure portal. However when I connect to the azure server using SSMS with the same credentials I can see only one. Any suggestions of how to solve this.

Hi AndrewFleet,

Thanks for posting here.

I suggest you to check whether the database is connected from SSMS or authenticated via SQL authentication.

For connectivity issues check the below link for details

http://social.technet.microsoft.com/wiki/contents/articles/1719.aspx

Lets open SQL Server Management Studio and try to connect Azure SQL Server. Given below is the info that you must pass at the time of connectivity as shown below and Press Connect Button. Make sure your caps lock key should be turned on/ off accordingly ;).

Server Name : Azure SQL Server Name.database.windows.net (gx8icm0cm.database.windows.net)
Login : The login name which we created in pre-requisite article step 3.
Password : The password which we created in pre-requisite article step 3.

Step 4 : (Azure SQL Server Connected in SSMS)
Now, you have connected Azure SQL Server using SQL Server Management Studio as shown below.

Girish Prajwal

Hi Girish,

I can connect to the server with no problem. It is just that when I have connected I can only see one of the databases. However when I connect using the Azure Management Portal (using the same credentials) I can see both databases.

I can now connect to the database if I make another connection and specify the database in the connection properties.

Andrew, you might check that the problem connection was not inadvertently made to a database rather than the server.  In the options tab on the connection dialog make sure that a specific database isn't selected. You will find that in SSMS, if you have previously connected to a specific database on a server, the database most recently connected to will be selected by default.  And as the database name is on the extreme right side of the connection description in the object explorer it's not always visible.

Cheers, Bill

    

Thanks Bill,

That was it. I can see all of the databases on the server now.

Cheers,

Andrew