I've got SQL Server 2008 Developer Edition installed on my Windows 7 development box. I use it to connect to our production and test SQL Server 2005 servers and databases. Plus yesterday I created a SQL 2008 Express database on my Win7 machine.
However, something odd happens in SSMS. When I get into SSMS it pops up the "Connect to Server" dialog box. I've noticed that a couple of server names are duplicated. For example, now I've got 2 server names for SQLEXPRESS, both the same name, on my Windows 7 machine. Why is that?
asked May 24 '11 at 07:48 AM in Default
Different connection methods, perhaps? Have you connected once using windows credentials, and again using a sql server userid/password?
answered May 24 '11 at 07:54 AM