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

Posted Date: 18 Jan 2007	Resource Type: Articles	Category: Databases
Author: Vadivel Mohanakrishnan	Member Level: Diamond
Rating:	Points: 4

Introduction

Error Description :: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

Solution 1:

Go to, Start >> Programs >> Microsoft SQL Server 2005 >> Configuration Tools >> SQL Server 2005 Surface Area Configuration >> Surface Area Configuration for Services and connections.

Within this check whether "Local and remote connections" is choosen. If not choose it :)

Solution 2:

Check this URL http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=192622&SiteID=1 :)

Responses

No responses found. Be the first to respond and make money from revenue sharing program.

Feedbacks

Popular Tags

What are tags ?

Search Tags

Named Pipes Provider . Error .

Post Feedback

This is a strictly moderated forum. Only approved messages will appear in the site. Please use 'Spell Check' in Google toolbar before you submit.
You must Sign In to post a response.

	Next Resource: List tables that doesn't participate in any relationships ...
	Previous Resource: What Is Collation - SQL Server (COLLATE)
	Return to Discussion Resource Index
	Post New Resource
	Category: Databases

Post resources and earn money!

More Resources