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.

When I installed SQLManagementStudio_x64_ENU.exe I am not able to connect to my server. In the image (1) session, I am not getting server name. Also in (2) session also I am not getting it. Is there any issue in my installation? Thank you the team and support.

Image

enter image description here

share|improve this question

migrated from stackoverflow.com Jun 22 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 at 13:37
    
i am trying to connect local server –  felix May 30 at 13:38
    
    
this is the image. I can not add it in my post –  felix May 30 at 13:38
    
If you are in Windows Authentication and SqlExpress try dot (.) or like this -> i.stack.imgur.com/u9r9V.png –  Teoman shipahi May 30 at 13:39

2 Answers 2

up vote 1 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. drive.google.com/file/d/0B4AkOax_FJ1ANzBLZ1Vqbjlfb3M/… –  felix May 30 at 13:52
    
please check download links on my updated answer. –  Teoman shipahi May 30 at 13:56
    
i have installed QL server 2012 or 2008 R2 –  felix May 30 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 at 13:58
    
Looks like you just installed Management Studio, not services. You need to install them also. Check support.microsoft.com/kb/941823 and here stackoverflow.com/questions/4549721/… –  Teoman shipahi May 30 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.

Note

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 at 13:45
    
@felix go to your services and see if sql server is running? –  M.Ali May 30 at 13:50
    
    
I am not able to connect it. bec i have no server. –  felix May 30 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 at 14:53

Your Answer

 
discard

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