| Jens.Suessmeyer@googlemail.com 2006-02-17, 7:23 am |
| Thats the error message you are getting if you just setup WIndows
authentification. If you do so, you can=B4t login with the sa account,
because this would require Mmixed Authentication (SQL and Windows
authentication). So one option is to change the Authentication mode
Mixed Mode, of you use Windows Authentication for the users to login.
If you don=B4t have a gui to change the Authentication code, you can
change the registry key for authentication (which also works in 2005):
-----------------------------------------------------------------
http://support.microsoft.com/defaul...b;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\Micros
oft\MSSqlserver\MSSq
lServer\LoginMode
Named instance:
HKLM\Software\Micros
oft\Microsoft SQL Server\Instance
Name\MSSQLServer\Log
inMode
to 2 for mixed-mode or 1 for integrated. (Integrated is the default
setup for the SQL Server 2000 Data Engine.)
</snip>
-URL----------------------------------------------------------------
HTH, Jens Suessmeyer.
|