No. If you check the option I specified, NT falls over to DNS for the
hostname lookup. Rather handy and I don't know it 95 has the option.
> Do I need to do anything with the ODBC settings? Seems I should have to
> change them for both methods you have described.
Only if you want to print. Normal operations won't need anything changed.
> Also, since either will work if I set them up correctly.... please help me
> find what I don't have set up correctly. Since I have everthing set up
> exactly as you describe in your steps for TCP/IP then obviously there are
> other settings that need to be looked at that I may need to change to get
> this to work..... there must be something about my basic configuration that
> you are assuming I have set up that isn't. I just have no idea what that
> could be, Emerald is running fine other than with remote access.
I did notice one mistake below. If you are not using 1433, the connect
string should be x.x.x.x,yyyy NOT x.x.x.x:yyyy. Please see Chapter 3
and Chapter 4 (Configuring Clients) in the SQL Server Administrator's
Companion (yeah, the thick one) as it details all this with examples as
well.
> Dave
>
> >
> >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
> >
> >
> > ----------------------------------------------------------
> > Emerald Mailing List listserver@emerald.iea.com
> >
> >
>
> ----------------------------------------------------------
> 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