Re: Fix of problem connecting VS2005 to remote Sql 2000 server



"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.


.

Relevant Pages

  • Re: Leveling by ID vs. "Standard"
    ... of this trade called Project Management. ... a database for the "Project Tables," ... to write reports on data from the server database. ... product supporting queries created with SQL. ...
    (microsoft.public.project)
  • Re: Suggestions for AV software
    ... I agree about running managed - the potential issue with that is for people who don't have SQL, which is a cost factor that may push some non-Premium users to a different AV. ... Susan is testing to see if the warnings you get when running unmanaged are sufficient for her comfort level - Security Center alerts on the client PCs, and WSUS warnings for distribution failures, both coming in the monitoring report. ... I don't care about most of the management stuff - I just want to be able to enforce one configuration and be alerted to clients that are not running or updating properly - but I'm not sure you can get even those basic functions without running the management app. ... The client will run in any configuration on the server. ...
    (microsoft.public.windows.server.sbs)
  • RE: Fulltext failure on a 2 node cluster
    ... Server full-text search resource online: "SQL Cluster Resource 'Full Text' ...
    (microsoft.public.sqlserver.clustering)
  • Re: DCOM Error - Event 10009
    ... using SQL Server Management Studio 2005. ... Whenever we first launch SQL ... when connecting to a different registered server, it will hang again for 5 - ... I have checked DCOM Config using dcomcnfg, ...
    (microsoft.public.sqlserver.clients)
  • Re: HELP PLEASE ~ ???
    ... You mentioned that it went ahead and added a SQL ... SQL Server 2000 database for all my data. ... find the connectionString in the newly recreated SQLExpress database. ... The connection string specifies a local Sql Server Express instance ...
    (microsoft.public.dotnet.framework.aspnet)
Loading