Changing From Windows To Mixed Authentication

[Kulgan]

Hi All

I am trying to switch from Windows to Mixed mode authentication on SQL
Server 2000. I am right-clicking the server instance in Enterprise
Manager and selecting the correct option from the Security tab.

Unfortunately, the change I make does not persist when I click OK. I
get no error message, but when I re-open the server properties, the
option has returned to being Windows authentication.

Any ideas?

Thanks,

Kulgan.

[Jens]

Did you restart the service ?

HTH, Jens Suessmeyer.

[Kulgan]

Hi

I stopped and started the service using Enterprise Manager (i.e. right
click the server in Enterprise Manager and select Stop from the menu,
the start again using Start from the same menu).

Do I need to stop and start using some other method?

Thanks,

Kulgan.

[Jens]

-----------------------------------------------------------------
http://support.microsoft.com/default...;EN-US;q285097
-----------------------------------------------------------------
INF: How to Change the Default Login Authentication Mode to SQL While
Installing SQL Server 2000 Desktop Engine by Using Windows Installer
-----------------------------------------------------------------
<snip>
Another way to change the security mode after installation is to stop
SQL Server and set the appropriate registry key for your installation:
Default instance:
HKLM\Software\M icrosoft\MSSqls erver\MSSqlServ er\LoginMode
Named instance:
HKLM\Software\M icrosoft\Micros oft SQL Server\Instance
Name\MSSQLServe r\LoginMode
to 2 for mixed-mode or 1 for integrated. (Integrated is the default
setup for the SQL Server 2000 Data Engine.)
</snip>
-URL----------------------------------------------------------------

[Kulgan]

Fantastic! Worked a treat!

Kulgan.