question

milind270989 avatar image
milind270989 asked

No server name after installing MS SQL server 2012 express edition

I installed MS SQL server 2012 and 2014 ; but when i open the SQL Management studio; i don't get any server name to connect. In fact; there are no services running in "SQL Server Configuration Manager ". I tried everything starting from a ' . ' to providing instance name in server name box; but nothing is working for me. Can someone please help me and also let me know if i need to install some other server? Please advise.
installationsql-server-2012-express
2 comments
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

DenisT avatar image DenisT commented ·
what kind of an error are you getting?
0 Likes 0 ·
Grant Fritchey avatar image Grant Fritchey ♦♦ commented ·
This site functions according to votes. For all helpful answers below, show this by clicking on the thumbs up next to those answers. If any one answer lead to a solution, indicate this by clicking on the check mark next to that answer.
0 Likes 0 ·

3 Answers

·
Fatherjack avatar image
Fatherjack answered
Do you have more than one version of SQL Server installed? If so, you may be using the earlier SQL Server Config Manager which will not be able to connect to the later version? Check for a later version of Config Manager and check. Have you looked in the computer Services.msc to see if the service is actually installed?
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

milind270989 avatar image
milind270989 answered
Yes i have verified the services.msc and no service have been installed. And i don't have any other version installed except 2012. How to proceed? I am getting the below error : TITLE: Connect to Server ------------------------------ Cannot connect to .. ------------------------------ ADDITIONAL INFORMATION: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 2) Please help.
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

ecomma avatar image
ecomma answered
Go to Management studio,Make sure the "Data base engine option is selected" in the server type dropdown. On the Server name drop down, click on browse, Your server should be visible on the local server or network server. If your installations is correctly done.
1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

vignesh5746 avatar image vignesh5746 commented ·
I think you have not selected the database engine feature while installing sql server
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.