Re: Fix of problem connecting VS2005 to remote Sql 2000 server
- From: "Willy Denoyette [MVP]" <willy.denoyette@xxxxxxxxxx>
- Date: Mon, 6 Mar 2006 22:46:17 +0100
"Willy Denoyette [MVP]" <willy.denoyette@xxxxxxxxxx> wrote in message
news:eGr6TOWQGHA.3016@xxxxxxxxxxxxxxxxxxxxxxx
|
|
| "RvGrah" <rvgrahamsevatenein@xxxxxxxxxxxxx> wrote in message
| news:1141677747.168923.145430@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
|| After much hair-pulling, I've finally found the answer to a problem
|| that many are fighting with, difficulty connecting from Sql 2005 Server
|| Management or VS2005 to a remote Sql Server running Sql 2000. In my
|| case the server I couldn't reach was across a vpn connection, behind
|| ISA server 2000, (which had port 1433 open).
||
|| The answer was in this post:
||
|
http://groups.google.com/group/microsoft.public.dotnet.framework.adonet/browse_frm/thread/d892fa3f16af2168/c085545c69936dcf?lnk=st&q=dotnet+vs+2005+connect+sql+2000&rnum=8
||
|| (See the 10th post in the thread, by Pablo Castro).
||
|| Adding the simple prefix "np:" in front of the server name fixed the
|| problem immediately. Why didn't Microsoft hire blimps and sky-writers
|| to publicize this hugely frustrating change?
||
|
| Well, they did.... look at:
|
http://msdn2.microsoft.com/en-us/library/system.data.sqlclient.sqlconnection.connectionstring.aspx
|
| or your local VS2005 MSDN docs.
|
| Willy.
|
|
Just forgot to add that when using named pipes as protocol, something you
shouldn't do on a corporate network, you are using port 445 at the server,
so you need to open this port at the firewal or NAT as well. Anyway your
issue is not related to the ISA sever, it's just that you have set-up your
SQL server to use named pipes as protocol, something that you need to
indicate in your ConnectionString, or by specifying the protocol in your
Server variable (data source=np:...) or your Net variable (...;
net=dbnmpntw).
Willy.
Willy.
.
- Follow-Ups:
- References:
- Fix of problem connecting VS2005 to remote Sql 2000 server
- From: RvGrah
- Re: Fix of problem connecting VS2005 to remote Sql 2000 server
- From: Willy Denoyette [MVP]
- Fix of problem connecting VS2005 to remote Sql 2000 server
- Prev by Date: Datagridview refresh issue
- Next by Date: setting CallBack in COM object
- Previous by thread: Re: Fix of problem connecting VS2005 to remote Sql 2000 server
- Next by thread: Re: Fix of problem connecting VS2005 to remote Sql 2000 server
- Index(es):
Relevant Pages
|
