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).
(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?
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)
