HELP! SQL 2000 remote access

Hi there - completely stumped with this one.

Have SQL 2000 running on Win 2000.
However, when I set up a SQL db and user /password. they can't login.

The error is "not a trusted user, access denied"

I can't seem to change from Windows authentication to SQL authentication in SQL server properties.

It always defaults back to windows authentication.

I've tried lots of things , re client network access (TCP) , and SQL settings and logins etc etc etc..

Am I doing the right things? Any ideas?

Thanks in advance HELP! SQL 2000 remote access
Joseph

 

 

 

 

Top