F-SECURE ANTI-VIRUS - FOR MICROSOFT EXCHANGE Deployment Manual - page 30
28
Follow these steps to change the authentication mode:
1. Open Microsoft SQL Server Management Studio or Microsoft SQL
Server Management Studio Express.
If you do not have Microsoft SQL Server Management Studio
installed, you can freely download Management Studio Express from
the
Microsoft web site
.
2.
Connect to the SQL server.
3.
In Object Explorer, go to Security > Logins.
4.
Right-click on sa and select Properties.
5.
Open the General page and change the password. Confirm the new
password that you entered.
6.
Open the Status page and select
Enabled
in the Login section.
7.
Click
OK
.
8.
In Object Explorer, right-click on the server name and select
Properties.
9.
On the Security page, select SQL Server and Windows
Authentication mode under Server authentication.
10.
Click
OK
.
11.
Right-click on the server name and select Restart.
Wait for a moment for the service to restart before you continue.
12.
Use Management Studio to test the connection to the SQL server with
the sa account and the new password you set.