|
Question: How can I
change the authentication mode for SQL Server.
Answer: Microsoft
recommends using Windows Only authentication for the SQL Server.
However, many users find setting up the Windows permission on all
workstation to be cumbersome. It is much simpler to setup SQL
Server to use mixed mode authentication. To do so, you can use the
Enterprise Manager (SQL 2000) or the Studio Manager Express (SQL 2000 -
2008).
In either
application, simply right click on the Server and left click on
Properties. This will allow you to change the authentication mode.
For more information on setting the authentication mode using the Studio
Manager Express, see the tech
bulletin on setting up SQL 2005.
You can also change
the authentication mode by editing the Windows Registry. For more
details, see the following link at Microsoft's website:
http://support.microsoft.com/kb/285097
Once you have the
program set to Mixed Mode Authentication (Windows & SQL), you will need
to setup a user account or 'etuser' with a password of 'etrik22'.
ExpressMaintenance will first attempt to connect using the 'etuser'
account. If that fails, it will proceed to attempting to connect
via Windows. |
