I have two installations of SQL on two seperate boxes (I have "Inherited" these).
SQL 2005 Installation, with instance called
SQL2005 - I connect to this via SQL Studio Manager and when I connect to Servername I put:
SQL 2008 Installation, now, when I go into Studio Manager, it connects straight through to the server just typing in the
SERVERNAME without specifying
\INSTANCE. However, looking through services.msc it appears the instance is
How exactly does this work? I always thought you had to connect directly to an instance. For example, on the 2005 box I can't connect to just
SERVERNAME I have to specify an instance, but on the 2008 box, I can connect with just
SERVERNAME, and if I specify
\MSSQLSERVER as the instance, it fails to connect.