Sample Header Ad - 728x90

SQL Server - connecting to wrong instance?

0 votes
0 answers
127 views
So, I've ... inherited a SQL server environment. With LanSweeper, I see this particular server has two instances installed: sql001AK and sql001M5. LanSweeper tells me they have similar databases, except for UserDB3, which is on the M5 instance but not on the other. I use SSMS to connect with sql001M5 to look into this user db, but I can't find it. When I pull up the properties of this database, I see in the name attribute the name of the other instance! When logged into the actual server, I can clearly see in the SQL Server Config Manager that it's two separate instances, no aliases defined, no weird clustering, all seems fine. But in SSMS, entering the one name connects me to the other... What could explain this behaviour? How do I connect to my M5 instance?
Asked by steenbergh (268 rep)
Jun 11, 2024, 03:46 PM