Rockwell Automation FactoryTalk Alarms and Events Quick Start - Manual (Page 201)

E • Use an existing Microsoft SQL Server database
• •
• •
•
193
10. Click Install to begin the installation.
11. When the installation is finished, click Finish to close the window.
12. If you are prompted to restart you computer, click Yes.
Step 2: Specify Mixed Mode authentication for the SQL Server database
To change the authentication mode and configure the “sa” login, perform the
following steps:
1. Click Start, point to All Programs > Microsoft SQL Server 2005 and then click
SQL Server Management Studio.
2. In Object Explorer, right-click the server node, and then click Properties.
3. On the Security page, under Server authentication, select SQL Server and
Windows Authentication mode, and then click OK.
4. To acknowledge the need to restart SQL Server, click OK in the SQL Server
Management Studio dialog box.
5. In Object Explorer, expand Security, expand Logins, right-click sa, and then click
Properties.
6. On the General page, you may have to create and confirm a password for the “sa”
login.
7. On the Status page, under Login, click Enabled, and then click OK.
8. Restart the server if you changed the authentication mode. In Object Explorer,
right-click the server node, and then click Restart.