Sudden error on connection, conflict sql 2000-2005? desperated!

[Pieter]

Hi,
I have some nasty error when deploying my application (VB.NET 20002) on the
users-computers. I'm using an SQL 2000 database.

The problem I guess is the fact that I had a local SQL 2000 and a local SQL
2005. I used to develop on a network SQL 2000 (the same which the users are
connecting too), and everything works fine. But now I am not in the office
for 2 weeks, so I have to develop on my local SQL 2000 instance. I send them
the exectuable, and this is what they get:

"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 only gave them a new exectuable, the App.Config didn't change.

anybody gets any idea? I'm getting kind of desperated. I desinstalled SQL
2000 AND SQL 2005, and re-installed only SQL 2000. But I still get the
error.

Anybody any idea, any hints?

Thanks a lot in advance!

Pieter

[Alan Pretre]

"Pieter" <pi**********@hotmail.com> wrote in message
news:%2***************@TK2MSFTNGP09.phx.gbl...

"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)" anybody gets any idea? I'm getting kind of desperated. I desinstalled SQL
2000 AND SQL 2005, and re-installed only SQL 2000. But I still get the
error.

Yes, we have seen this at our office. I believe you have to go into SQL
2005 config and enable TCP/IP connections. This gets turned off for some
reason in the upgrade.

-- Alan

[Pieter]

But I'm not using SQL 2005 at all! The users are connecting to a SQL 2000
database! :-S
And everything worked fine before, it just this week that it broke down...

Yes, we have seen this at our office. I believe you have to go into SQL
2005 config and enable TCP/IP connections. This gets turned off for some
reason in the upgrade.

-- Alan

[Alan Pretre]

"Pieter" <pi**********@hotmail.com> wrote in message
news:OC****************@tk2msftngp13.phx.gbl...

But I'm not using SQL 2005 at all! The users are connecting to a SQL 2000
database! :-S
And everything worked fine before, it just this week that it broke down...

Try checking the settings anyway. This sounds like the error we saw here.
In SQL 2000, go into SQL Server Client Network Utility and see if TCP/IP and
Named Pipes are enabled.

-- Alan

[Pieter]

Ok, I found the problem: The connectionstring was just not right: it was
poiting to my local SQL Server, which they can not access there offcourse
:-)
Although I don't get it yet how this could happen:
I'm using the Settings.settings of VB.NET to define a Connectionstring
(Scope = application). But it seems that this value is hardcoded somewhere
in the application? I had a App.Config in which it had the right value, but
that value isn't used?

I'm really getting confused now :-S It seems that I must take a better look
to the Settings.settings, because it doesn't react as I expected :-)

thanks anyways,

Pieter

"Alan Pretre" <al***@nospam.nospam> wrote in message
news:%2****************@TK2MSFTNGP12.phx.gbl...

"Pieter" <pi**********@hotmail.com> wrote in message
news:OC****************@tk2msftngp13.phx.gbl...

But I'm not using SQL 2005 at all! The users are connecting to a SQL 2000
database! :-S
And everything worked fine before, it just this week that it broke
down...

Try checking the settings anyway. This sounds like the error we saw here.
In SQL 2000, go into SQL Server Client Network Utility and see if TCP/IP
and Named Pipes are enabled.

-- Alan