Problem connecting to SQL Server 2000 using VS 2005 (Please help!)

[davidman73]

Hello,

I have VS 2005 with SQL Server Express in the same machine, but need to
connect to a remote SQL Server 2000. I'm getting this error:

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 thought it was my code, so I put a GridView control in a blank web
page, started the wizard for a new database connection and finished
setting it up. If I click "Test Query" in the sqldatasource
configuration, it works and returns the rows just as expected. However,
if I run the app, I get the above error again.

I can also access the database with no problem at all using Server
Explorer.

I've been on this for a week now and I'm totally out of resources.

Please, help...

[tdavisjr]

By default, asp.net 2.0 connects to SQL Express 2005 so it stores this
connectionstrin g in the global web.config file in the
<connectionStri ngs> element. So, that means that your local web.config
file also has this SQL Express 2005 connectionStrin g even though you
can see it since its inherited. If you want to connect to another
database server you must remove this default connectionStrin g and add
it with your own connectionStrin g. So, in your web.coniig do this:

<connectionStri ngs>
<clear /> <!-- this removes the inherited connectionstrin g -->
<add connectionStrin g="[YOUR STRING HERE]" />
</connectionStrin gs>

I hope this solves your issues as you have been stuck for a week