Re: [Emerald] Cant login to Emerald

Dale E. Reed Jr. ( (no email) )
Mon, 08 Nov 1999 10:14:17 -0800

Malcolm Joosse wrote:
> Hello List,
> I have setup a remot office to connect to Emerald.
> This remote office is running MSProxy 2. I have setup a port mapping to
> port 1433 (SQL) and all seems well.
> I can see the SQL database Emerald on the Emerald server but when I try to
> login I get an error saying "Login Failed, Please Try Again". This remote
> office is directly connected to our main office via MSP2/Modem. If I dial
> in to our head office with a modem on the remote PC it works fine.
> What I need to know is what ports does Emerald require to work ?
> Has anyone got Emerald working through MSP2 ?

Emerald uses the SQL DB-LIB API. FOr named pipes, it uses the
SMB ports (137-139, although maybe not all of them) and for TCP/IP
it uses 1433.

If the Login Failed isn't returning immediately, you probably still
have a connectivity issue. Try connecting with isql_w and see if it
can talk to the DB. Also, try turning on debug mode to see more of
the SQL Statements. You might be getting an error of "can't find SQL
server" which Emerald is interpretting as a bad password.


Dale E. Reed Jr. Emerald and RadiusNT__________________________________________IEA Software, Inc.

For more information about this list (including removal) go to: