Advertisement

05.27.2008 at 01:33PM PDT, ID: 23436267
[x]
Attachment Details

Web app has error connecting to sql server 2005

Asked by deNZity in SQL Server 2005, MS SQL Server, Programming for ASP.NET

I get the following error when trying to login to web application (user database is on sql server 2005)

"A connection was successfully established with the server, but then an error occurred during the pre-login handshake.  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: 0 - No process is on the other end of the pipe.) "

surface are is configured remote connections set to 'local and remote' using tcp/ip and named pipes


web app is asp.net2
sql server 2005 sp2Start Free Trial
[+][-]05.27.2008 at 01:44PM PDT, ID: 21655535

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.27.2008 at 02:04PM PDT, ID: 21655685

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]05.27.2008 at 02:07PM PDT, ID: 21655715

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]05.27.2008 at 02:12PM PDT, ID: 21655768

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: SQL Server 2005, MS SQL Server, Programming for ASP.NET
Sign Up Now!
Solution Provided By: prairiedog
Participating Experts: 2
Solution Grade: A
 
 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628