SQL Server 2012 Developer Default Instance not working

2
votes

I just installed SQL Server 2012 developer edition with a default instance of MSSQLSERVER.

The problem I'm facing is when I launch Management Studio and connect using the server name - (LocalDb)\v11.0 - it works perfectly, but when I try to put in MSSQLSERVER as the server name it gives in a Network related or instance specific error.

1
sql-serversql-server-2012sql-server-2012-express

1 Answers

3
votes

The default instance on a server is always reachable using

  • .
  • (local)
  • the machine name, e.g. YOURPC

Enter any one of those things in your Server Name field when connecting to SQL Server Management Studio (or use any one of those three things in the server= or data source= elements of your connection string).

But it's definitely NOT reachable using MSSQLSERVER ...

I don't know where you got that from - but that does NOT work - not for any version of SQL Server I'm aware of.

MSSQLSERVER is the name of the SQL Server Windows Service on your machine, yes - but it cannot be used as instance name to connect to!