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

How should you connect to a remote Sql server across a vpn connection
if you shouldn't use the "np:" named pipes prefixing? (I am in a
working across corporate networks, although we're talking about quite
diminutive corporations.)

Or when I'm in Sql Management Studio and wish to push some database
tables to our branch office (not really a branch, more of a clone
company in another state that shares the same software development and
database design). In Sql Server 2000 Enterprise Manager, if I just made
a vpn connection to the remote office, I could copy tables or stored
procedures etc from server to server without any special effort. Is
using np:<servername> not the right way to do it using 2005 tools? I
want to use the newer interface to get accustomed to it, and because it
offers superior tools for copying tables, as a for instance.

Any further guidance appreciated.

Bob

.

Relevant Pages

  • how to upload files thru https
    ... SQL server via a VPN connection with ADO.NET, ... processed data in XML format thru FTP. ... Can I upload data via http/https, ...
    (microsoft.public.vb.general.discussion)
  • Re: Data Transfer Question
    ... anyway even without a VPN you'll need to collect the data and that's still step 1. ... I might consider storing the data in a local SQL Server Compact database and simply sync with a remote host. ... and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook) ... If you were using a VPN connection, it would be a lot easier. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Fix of problem connecting VS2005 to remote Sql 2000 server
    ... | How should you connect to a remote Sql server across a vpn connection ... | if you shouldn't use the "np:" named pipes prefixing? ... In Sql Server 2000 Enterprise Manager, ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: VPN or Firewall
    ... For a VPN connection, you still need to open the firewall ... Mike Epprecht, Microsoft SQL Server MVP ...
    (microsoft.public.sqlserver.security)
  • Re: The user is not associated with a trusted SQL Server & VPN ?!
    ... As soon as I disconnect from the VPN, I can reconnect to SQL w/o ... MS SQL Server 2005 Express, development tools installed, local machine ... One possibility is that the VPN connection changes who you are. ... Whatever, the change in behaviour is surely due to the VPN upgrade, and ...
    (microsoft.public.sqlserver.connect)
Loading