SQL Server Management Studio can not connect

c# sql sql-server sql-server-2014
sahossaini picture sahossaini · Dec 31, 2013 · Viewed 30.8k times · Source

I have installed SQL Server Management Studio 2014. In "connect to server" window, I selected server type as "Database engine", server name as "(local)" but when I try to connect, n error is shown-

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 what to do...

Answer

Premchand Yelavarthi picture Premchand Yelavarthi · Dec 31, 2013

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)

This is a common error which arises when connecting to SQL Server with Management Studio.

This includes different type of error scenarios like (Service--Not Available),(Service-Not Running),(Network Library- Not Enabled),(Fire Wall-Blocking) Etc.

Please troubleshoot in systematic manner.

  1. Click On start button and type Services.MSC

  2. Check whether the SQL Server service has been installed and is running fine.

Please check the service whether started or not.

If Yes:

  • Next Scenario is Network Libraries Tune.

If No

  • Install the SQL Server Engine from the software package and start the service.

Related questions

What represents a double in sql server?

I have a couple of properties in C# which are double and I want to store these in a table in SQL Server, but noticed there is no double type, so what is best to use, decimal or float? This …

Read More
Execute Insert command and return inserted Id in Sql

I am inserting some values into a SQL table using C# in MVC 4. Actually, I want to insert values and return the 'ID' of last inserted record. I use the following code. public class MemberBasicData { public int Id { get; set; } …

Read More
How to get last inserted id?

I have this code: string insertSql = "INSERT INTO aspnet_GameProfiles(UserId,GameId) VALUES(@UserId, @GameId)"; using (SqlConnection myConnection = new SqlConnection(myConnectionString)) { myConnection.Open(); SqlCommand myCommand = new SqlCommand(insertSql, myConnection); myCommand.Parameters.AddWithValue("@UserId", newUserId); myCommand.Parameters.AddWithValue("@GameId", newGameId); myCommand.…

Read More