x

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.

more ▼

asked Nov 04, 2014 at 12:15 PM in Default

avatar image

milind270989
1 1 1 1

what kind of an error are you getting?

Nov 04, 2014 at 02:34 PM DenisT

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.

Nov 10, 2014 at 12:10 PM Grant Fritchey ♦♦
(comments are locked)
10|1200 characters needed characters left

3 answers: sort voted first

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?

more ▼

answered Nov 04, 2014 at 10:29 PM

avatar image

Fatherjack ♦♦
43.8k 79 98 117

(comments are locked)
10|1200 characters needed characters left

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.

more ▼

answered Nov 05, 2014 at 08:45 AM

avatar image

milind270989
1 1 1 1

(comments are locked)
10|1200 characters needed characters left

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.

more ▼

answered Nov 05, 2014 at 04:39 PM

avatar image

ecomma
470 18 22 26

I think you have not selected the database engine feature while installing sql server

Nov 06, 2014 at 07:34 AM vignesh5746
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x77
x9

asked: Nov 04, 2014 at 12:15 PM

Seen: 618 times

Last Updated: Nov 10, 2014 at 12:10 PM

Copyright 2016 Redgate Software. Privacy Policy