Re: SQL Server VPN problems / Help

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Hari Prasad (hari_prasad_k_at_hotmail.com)
Date: 06/30/04 

Date: Wed, 30 Jun 2004 07:32:18 +0530

Hi,

In MSDE, execute the application to get the client network utility.

cliconfg.exe

Use that create to an Alias server name for ur SQl server using TCPIP,
IPADDRESS and Port number

Thanks
Hari
MCDBA

"jay" <jay@discussions.microsoft.com> wrote in message
news:54F3165A-3E5F-4E11-A31E-4A89E60961E7@microsoft.com...
> 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

  • RE: Publishing SQL Server
    ... Have you changed the Default Network Library to TCP/IP in the SQL Server ... Client Network Utility? ... Please follow these steps to change the Default Network Library to TCP/IP ... If you need to configure an alias, ...
    (microsoft.public.windows.server.sbs)
  • Re: SQL Error
    ... I would guess that you have problem with name resolution. ... do not have an alias specified in the Client Network Utility. ... > Sql state '08001' ... > Now the situation is this that our sql server is accessible from all ...
    (microsoft.public.sqlserver.clients)
  • Re: Encryption not supported on SQL Server
    ... I rolled back all the changes I made using SQL Server ... Client Network Utility. ... I used this program for configuring a remote SQL ...
    (microsoft.public.inetserver.asp.db)
  • Re: .NET Data Adapter not taking Alias added in ClientNetwork Utility
    ... "Ganesan Subramanian" wrote in message ... > It was .NET SQL Data adapter for SQL Server. ... >> I wasn't aware that .NET would even look at the client network utility. ... >>> Microsoft Technologies and Solutions ...
    (microsoft.public.sqlserver.server)
  • Re: Encryption not supported on SQL Server
    ... I rolled back all the changes I made using SQL Server ... Client Network Utility. ... I used this program for configuring a remote SQL ...
    (microsoft.public.inetserver.asp.general)