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

Tech-Archive recommends: Fix windows errors by optimizing your registry



"RvGrah" <rvgrahamsevatenein@xxxxxxxxxxxxx> wrote in message
news:1141682665.893774.196410@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
| 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
|

Use the TCP protocol over port the default SQL server port 1433. Named pipes
use the SMB protocol (over port 445), which is good for 'direct' connections
or where client and server are on the same box, for anything else you should
set-up SQL server to use TCP (SQL server uses port 1433 by default). Note
that named pipes is not a new protocol (the first SQL version had it
already), I'm also not clear on what you mean by ....superior tools...,
named pipes are no tools, they are protocol end-points like sockets are for
TCP

Willy.


.

Relevant Pages

  • RE: [ODBC SQL Server Driver][Shared Memory]ConnectionWrite (send()
    ... the ODBC source using named pipe, but I don't know how to enable named pipes ... If it is not working I am going to use ado to connect to sql server. ... Microsoft Online Community Support ...
    (microsoft.public.sqlserver.connect)
  • Re: SQL2K WIN2K3 CONNECTION SECURITY
    ... My own benchmarking indicates that TCP/IP is faster than named pipes. ... the benchmark stats as the starting point... ... Perfmon and SQL Server Profiler along with SQL Server Query Analyser. ... encrypted on the web server. ...
    (microsoft.public.security)
  • Re: Umstieg von Access auf SQL-Server
    ... > Bei Port 1433 sabber ich dann immer gleich Named Pipes. ... Nein, TCP/IP. ... How To Change SQL Server Default Network Library Without ... How To Set the SQL Server Network Library in an ADO Connection String ...
    (microsoft.public.de.vb.datenbank)
  • Re: Database logging with IIS 7.0
    ... After adding named pipes, stuff started to work. ... SQL Server, Native Clients, Native ... I changed the App Pool owner to a domain user, ...
    (microsoft.public.inetserver.iis)
  • Re: I set: Local and remote connections/Using both TCP/IP and Named Pipes
    ... Using both TCP/IP and Named Pipes ... Go to configuration manager right click on SQL Server Express ... Local and remote connections/Using both TCP/IP and Named Pipes ...
    (microsoft.public.sqlserver.programming)