Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I don't understand :

I've installed sql server 2008 R2. the installation process asked me for the desired instance name , so I wrote: MSSQLSERVER.

after the installation , running Setup Discovery Report does shows me the instance name :

enter image description here

I've also installed all the service packs.

Also , all the services are up :

enter image description here

Also , all the ports are open ( tcp:1433 + udp :1434)

enter image description here

enter image description here

Also , Named pipes are on : enter image description here

So , where is the problem ?

I'm unable to connect via the instance name : enter image description here

Also unable with :

user\MSSQLSERVER where user is the computer name.

Also unable with : .\MSSQLSERVER

But (weird) :

Those 3 do work :

  • user ( "user" is my machine name)
  • (local)
  • .

Question :

why I can't use my instance name to connect to my sql server ?

Related info :

After connecting via one of the 3 who work , I run a helpful info :

enter image description here

share|improve this question
add comment

1 Answer 1

up vote 6 down vote accepted

You selected the default instance name as the name of your instance.

Instance Configuration

"If you specify MSSQLServer for the instance name, a default instance will be created. For SQL Server Express, if you specify SQLExpress for the instance name, a default instance will be created."

To connect to the default instance you don't specify the instance name, only the server name.

share|improve this answer
    
Thanks. and what If I choose "lala" as instance name ? would then I be able to cennect via ".\lala" ? –  Royi Namir Apr 28 '13 at 19:07
2  
@RoyiNamir yes, if you connect from the computer where SQL Server is installed. Otherwise you need to specify the computer name instead of .. Something like servername\instancename. –  Mikael Eriksson Apr 28 '13 at 19:14
    
Thank you very much Mikael.( as always :-)) –  Royi Namir Apr 28 '13 at 19:19
    
@RoyiNamir you are welcome. –  Mikael Eriksson Apr 28 '13 at 19:26
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.