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 :)
Joseph

Use your sql enterprise manager

right click on the server name

click security tab

click sql server and windows authentication

thats it.....

then start and stop the sql server (right click server name and click stop and then start)

No, I think his problem is that the SQL Authentication option is grayed out. I had that problem too, but I forget how I fix it. I think I just kept searching Google about it and something made it magically allow me to.

Keep poking around and Google is your friend.

Thanks guys - yes, the option in Enterprise Manager is greyed out.

Qgyen, please let me know if you remember how you resolved this :)

Have spent a long time on Google already :(

Thanks in advance
Joseph

Another way to change the security mode after installation is to stop SQL Server and set the following registry key

HKLM\Software\Microsoft\MSSqlserver\MSSqlServer\LoginMode

to 2 for Mixed Mode or 1 for integrated.

Its grayed out because you do not have the 'sa' privilege. You woould need to sign on as 'sa'

I'm pretty sure nobody would give you that on a website.

You will need the host to change the registry since you better not have that ability or have them go into enterprise manager as I indicated.