I have created a second database on my existing Azure SQL server. The first database works fine and I can see it using SSMS.
I cannot see the second database in the object explorer. Autocomplete detects that it exists however.
Any suggestions?
Answer
So for me, it turned out that when I was connecting using SSMS, I had set the database to connect to as my first database by accident - meaning that was all I could see.
On connect, go to Options, then check the database you're connecting to. If you're using multiple users to connect to that server like I was, my admin user ended up also being forced to connect to a single database instead of < default >.
No comments:
Post a Comment