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.
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?
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.
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.