2

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.

Improve this question
0

1 Answer 1

Reset to default
3

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!

Improve this answer
Sign up to request clarification or add additional context in comments.

6 Comments

Okay, Thanks for the help! could You just give me an example..?
@Neville: what example?!?!? I listed three ways that you can connect to your default instance .... pick one ....
I tried the first 2 and i get a Network or instance related error.. only (LocalDb)\v11.0 seems to work!
@Neville: then you don't actually have a full SQL Server 2012 installation with a default instance! What exactly did you install? Only the LocalDB components???
I re-installed SQL 2012 developer once again and all the 3 options you showed up work flawlessly now including (LocalDB\v11.0), i dont know what the problem was initially, but i guess it went off after the re-installation.. Once again man thanks for the help! Appreciate it!
|

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.