ServerName no longer works as SQL Server 2008 Default instance name?
- by TomK
Folks,
Somehow in struggling to install something (Sage MIP), I have unsettled my system's SQL Server 2008 instance names.
If I fired up SSMS and connected to "MySystemName" (while logged into MySystemName), I used to immediately connect and could view my databases. Now if I connect to "(local)" or "." I connect just fine...but "MySystemName" gives me a timeout error.
If I log in with "." and do "SELECT @@SERVERNAME" it comes back with "MySystemName" just fine.
I've double checked that my network name is in the Security\Logins list, and it is, as a dbadmin.
Any suggestions? I thought that having SQL Server 2005 Express might be a problem (the "battle of the default instances"), so I uninstalled that. No better.