Thursday, December 31, 2015

sql server - Can't see second azure sql database in SSMS object explorer




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

linux - How to SSH to ec2 instance in VPC private subnet via NAT server

I have created a VPC in aws with a public subnet and a private subnet. The private subnet does not have direct access to external network. S...