ASP.NET 2.0 and SQLServer 2000

[Steve]

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!

[bruce barker \(sqlwork.com\)]

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)

"Steve" <St***@discussions.microsoft.com> wrote in message
news:21**********************************@microsof t.com...

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!

[Jeremy Chapman]

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.

"Steve" <St***@discussions.microsoft.com> wrote in message
news:21**********************************@microsof t.com...

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!