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.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

When I installed SQLManagementStudio_x64_ENU.exe I am not able to connect to my server. The server name is not visible in either image.

Is there any issue in my installation?

enter image description here enter image description here

share|improve this question

migrated from Jun 22 '14 at 2:13

This question came from our site for professional and enthusiast programmers.

Are you trying to connect remote server or local? – Teoman shipahi May 30 '14 at 13:37
i am trying to connect local server – felix May 30 '14 at 13:38
this is the image. I can not add it in my post – felix May 30 '14 at 13:38
If you are in Windows Authentication and SqlExpress try dot (.) or like this -> – Teoman shipahi May 30 '14 at 13:39
up vote 2 down vote accepted

First install SQL server 2012 or 2008 R2 on your machine.

Microsoft® SQL Server® 2012 Express

Microsoft® SQL Server® 2008 R2 SP2 - Express Edition

Then go to SQL Server Configuration manager and make sure SQL Server Service is running.

enter image description here

Then user your servername to connect your SQL server in SSMS.

enter image description here

share|improve this answer
HI @TEOMAN I am not able to connect it. bec i have no server.… – felix May 30 '14 at 13:52
please check download links on my updated answer. – Teoman shipahi May 30 '14 at 13:56
i have installed QL server 2012 or 2008 R2 – felix May 30 '14 at 13:57
thank you for your effort. I have installed SQLManagementStudio_x64_ENU.exe so is there need any additional installation??? – felix May 30 '14 at 13:58
Looks like you just installed Management Studio, not services. You need to install them also. Check and here… – Teoman shipahi May 30 '14 at 13:59

to connect to local server and default instance just use any of these ., local, localhost or YourMachineName.

If you are trying to connect to a named instance on your local machine just use any of the above followed by \InstancenName.

i.e .\InstanceName, local\InstanceName, localhost\InstanceName or YourMachineName\InstanceName.


If you want to connect to the default instance you just use the machine name, if you are trying to connect to a Named Instance then you have to use the machine name and the Instance Name.

share|improve this answer
all the above are not working. I have tried it earlier. – felix May 30 '14 at 13:45
@felix go to your services and see if sql server is running? – M.Ali May 30 '14 at 13:50
I am not able to connect it. bec i have no server. – felix May 30 '14 at 13:54
Good God it means you have only installed the Client Tools and not the server :) On a side note a suggestion/Piece of Advice if you are installing Sql server so you can practice and learn, Dont install Sql Server Express Edition its pretty basic and crap just spend 50$ and get your self a copy of Developer's Edition. – M.Ali May 30 '14 at 14:53

Your Answer


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.