asked on

Server does not allow remote connections

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)

What causes this and how can I troubleshoot it?

ASP .NET -- I get this when trying to run a Web User Control with some Infragistics controls. We are using SQL Server 2005

SOLUTION

surajguptha

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

REA_ANDREW

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Bob Learned

This is such a generic error that doesn't explain any reasons, so it can be sooo many things. I have seen where it was because the connection string is case-sensitive, couldn't reach the server, remote connections aren't turned on by default, authentication problems, server problems, etc.

Bob

Tom Knowlton

ASKER

I have other Web User Controls that use connections to the same SQL Server (different database, though) and they work just fine.

The connection string is virtually identical except I connect to a different catalog:

from my web config:

//WORKS FINE
<add name="UWinAuthenConnectionString" connectionString="Data Source=UWINDB01\SQLEXPRESS;Initial Catalog=UWinAuthen;User ID=xxx;Password=xxx" providerName="System.Data.SqlClient"/>

//GETS THE ERROR
<add name="UWinWebScheduleConnectionString" connectionString="Data Source=UWINDB01\SQLEXPRESS;Initial Catalog=WebSchedule;User ID=xxx;Password=xxx" providerName="System.Data.SqlClient"/>

I am leaning towards this being a SQL Server configuration issue.

Tom Knowlton

ASKER

Go into the Sql Server 2005 Surface Area Configuration, under the Database engine check out the config there as it defaults to what you are experiencing.

HUH?

Also Configuration Manager, you can enable TCP/IP.

HUH?

SQL Server dummy, here!!!!!

SOLUTION

surajguptha

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Bob Learned

Tom,

If you have 2005 Express Edition, then you can download the free tools, like Surface Area Configuration and Management Studio. When you install them, there will be a new SQL Server 2005 start menu with those programs listed.

Bob

Tom Knowlton

ASKER

We are running the Express Edition.

ASKER CERTIFIED SOLUTION

Bob Learned

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial