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.
Thanks,
Dave
----------------------------------------------------------------------------
------------------
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.