Sounds like your using Named Pipes and your not logging into the client
machine EG win95 with the same username. Try changing it to TCP/IP. Goto
your SQL clients config and select TCP/IP and then the second tab and
enter the details about your server etc, then the third tab you add the
drivers I think it is. Then you should be able to talk to your SQL
via the SQL Manager and also emerald.
Kind Regards
>
> David Ford wrote:
>
> > Howdy all,
> >
> > We have a slight problem, emerald works as we want it on the machine it is
> > installed on, but when trying to access it remotely ie use emerald on
> > another machine it refuses to let us on
> >
> > We've added emerald administrators in emerald, that didnt work, added remote
> > logins to ms sql, still didnt work.
> >
> > I believe this to be an sql issue as the sql enterprise manager also gets
> > access denied from any other machine, any pointers for where I can find info
> > on whats wrong? or even better any one know whats wrong,
> >
> > We have had a few people in playing with things on the machine, and it is
> > due to one of these people that remote logins has ceased to work, this
> > person is no-longer contactable to find out what they did. What I'm saying
> > is "it used to work" - tm
> >
> > Coming from a mysql background does ms sql have a hostname table etc in its
> > auth db (if it has one) or is this too easy?
> >
> > Thanks for your time,
> > Dave.
> >
> > For more information about this list, including removal,
> > please see http://www.iea-software.com/maillist.html
>
>
>
>
> For more information about this list, including removal,
> please see http://www.iea-software.com/maillist.html
>
For more information about this list, including removal,
please see http://www.iea-software.com/maillist.html