Re: SQL Server VPN problems / Help

From: jay (jay_at_discussions.microsoft.com)
Date: 06/29/04 

Date: Tue, 29 Jun 2004 09:41:28 -0700

Hari,
  Yes, it is with a VPN (set up by hardware configuration on routers). CLIENT NETWORK UTILITY is part of the SQL Server 2000 package, isn't it? I am using MSDE 2000A which comes without all the utilities. Any ideas on
  1) how to create the Alias without using the Utility, or
  2) how to get a third party version of CLIENT NETWORK UTILITY?
  Thanks again. The help is invaluable.
Jay

"Hari Prasad" wrote:

> Hi,
>
> If you are trying to access using VPN then connect to VPN first then:-
>
> 1. Create Alias to SQL server from your machine using CLIEN NETWORK UTILITY,
> specifying TCP/IP as protocol, IP Address and Port number.
>
> 2. After creating the Alias use this server name to connect to SQL Server.
>
> If you are trying to access the server using your own network but mutiple
> domain then;
>
> 1. Create a trust relationship between both domains
>
> 2. Create Alias to SQL server from your machine using CLIEN NETWORK UTILITY,
> specifying TCP/IP as protocol, IP Address and Port number.
>
> 3. After creating the Alias use this server name to connect to SQL Server.
>
> Thanks
> Hari
> MCDBA
>
> "jay" <jay@discussions.microsoft.com> wrote in message
> news:15797A20-7617-4B82-A53D-576BA50639A1@microsoft.com...
> > How can I do the following?
> > - I connect to a remote server by VPN. This server is running Small
> Business Server 2003 and a named instance of MSDE 2000 that I want to log
> into using my NT login. (I want to run locally an Access application that
> uses linked tables to a SQL server back-end. I want to use the remote SQL as
> the back-end.)
> > - The remote server is domain "abc" and my local machine is also on a SBS
> 2003 server under domain "xyz".
> > - My local network is 192.168.x.0 and the remote server (domain "abc") is
> on network 192.168.y.0.
> > Can someone step me through how I can create a connection to this remote
> instance of MSDE 2000? I could really use the help. Thanks!
> > Jay
> >
>
>
>

Relevant Pages