ASP.NET 2.0 and SQLServer 2000

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello!
I have a problem to connect to SQLServer 2000 on ASP.NET 2.0. When I logon
the .NET show me the error <I>"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)"</I>
If I run my application directly from VS2005, works great. But if I upload
to a IIS ASP.NET 2.0, fail.
Anybody knows why???

Thanks!
 
you are using the named pipes to connect to the sqlserver. be sure it has
named pipe support turned on, or change the connection string to match a
protocol your sql2000 server supports.

-- bruce (sqlwork.com)
 
What's your connection string? If you're trying to use trusted
authentication then make sure your web app is impersonating and using
windows authentication.
 
Back
Top