ASP.NET 2.0 and SQLServer 2000

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!
 
B

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)
 
J

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
473,744
Messages
2,569,482
Members
44,901
Latest member
Noble71S45

Latest Threads

Top