How do I fix the error 'Named Pipes Provider, error 40 - Could not open a connection to' SQL Server'?

sql-server sql-server-2005 database-connectivity
Damien picture Damien · Mar 30, 2012 · Viewed 650.4k times · Source

I can't seem to connect to my database from a site. I get this error:

Named Pipes Provider, error: 40 - Could not open a connection to SQL Server

I tried using the local IP address to connect as well as a public one. I've tried:

  1. Yes, the site can communicate with the server
  2. Named pipes/TCP is enabled.
  3. Remote connections are allowed.
  4. Windows Firewall is off
  5. Created an exception for port 1433 in Windows Firewall.
  6. Enabled everything in SQL Server Configuration Manager.

What else can I do here?

Answer

Kazem picture Kazem · Jan 3, 2016

Solving this problem is very easy:

  1. Go to control panel.
  2. search for services.
  3. Open Local services window from your search results
  4. Restart your MSSQLSERVER service.

Screenshot of the steps:

Screenshot of the steps

Related questions

Add a column with a default value to an existing table in SQL Server

How can I add a column with a default value to an existing table in SQL Server 2000 / SQL Server 2005?

Read More
Insert results of a stored procedure into a temporary table

How do I do a SELECT * INTO [temp table] FROM [stored procedure]? Not FROM [Table] and without defining [temp table]? Select all data from BusinessLine into tmpBusLine works fine. select * into tmpBusLine from BusinessLine I am trying the same, but …

Read More
SQL query to select dates between two dates

I have a start_date and end_date. I want to get the list of dates in between these two dates. Can anyone help me pointing the mistake in my query. select Date,TotalAllowance from Calculation where EmployeeId=1 and Date …

Read More