Re: Running Emerald from another Domain

Dale E. Reed Jr. ( (no email) )
Wed, 10 Dec 1997 23:15:06 -0800 ()

On Wed, 10 Dec 1997, David Mulberry wrote:

> I haven't had to access my Emerald database remotely yet but I need to now.
> I followed the instructions below to verbatim... this should allow me to
> connect to Emerald via the Internet, correct???
>
> I keep getting "invalid password" and I have triple checked my settings,
> please help me with this I have to access Emerald remotely.

Typically, what I do is connect using the ip address of the
machine. To do this you have to enable the option in your TCP/IP,
WINS setting of "Enabled DNS for Windows Resolution". Then
open up a dos prompt and type:

net use * \\1.2.3.4\c$ /user:domain\username password

where 1.2.3.4 is the IP address of your SQL Server and
domain\administrator is domain and username and password
is your password.

You should have your default library as named pipes and then
just enter 1.2.3.4 as the server name in Emerald or SQLEW.

The above is an alternative to using straight TCP/IP as noted
below, BTW. Either will work if you set them up correctly.


> ----------------------------------------------------------------------------
> ------------------
> Instructions you gave from a previous message follow:
>
>
> Most of this is pretty straight forward SQL server client configs.
> I'll try to outline a pure TCP/IP config here:
>
> First, make sure you have TCP/IP support for SQL Server installed.
> TO do this run the setup.exe from the SQL Server media on your
> SQL Server machine. At the options prompt (after the name and
> such) select the "Change Network Protocol Support" and click
> continue.
>
> You need to make sure you have TCP/IP checked. If you don't,
> then check it. You'll need to select a port. 1433 is the default,
> but you can put it on anything you want. Select continue to finish
> the TCP/IP install, or just cancel out if you already have
> TCP/IP support enabled.
>
>
> Now for the remote client to use TCP/IP:
>
> 1. From Your SQL Server group, select "SQL Client Configuration
> Utility".
>
> 2. Click on the Advanced tab.
>
> 3. At the bottom enter:
>
> Server: Server
> DLL Name: TCP/IP Sockets
> Connection String: x.x.x.x:yyyy
>
> Where Server is your SQL Server common name (usually the netbios name
> or the FQDN). x.x.x.x is the IP adddress to your SQL Server and yyyy
> is the port you install tcp/ip to. If you chose to use the default of
> 1433, you can put just the IP address for the connection string.
>
> 4. Click Add/Modify to put the entry in the current entries list.
>
> Now when you run Emerald on this machine, make sure you enter
> the server name EXACTLY as you did in the client config utility.
>
>
>
>
>
> ----------------------------------------------------------
> Emerald Mailing List listserver@emerald.iea.com
>
>

Dale E. Reed Jr. (daler@iea.com)
_________________________________________________________________
IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs
Internet Solutions for Today | http://www.iea-software.com