Article Number
000026305
Applies To
RSA Product Set: RSA Access Manager
RSA Version/Condition: 6.0.2
Microsoft SQL Server 2005
Microsoft Windows 2003
Issue
Install the Access Manager SQL data adapter on Microsoft SQL Server 2005
The installation guide only details the required steps for SQL Server 2000
Tasks
Microsoft SQL Server 2005 has been qualified on RSA Access Manager since version 6.0.2
Resolution
The following section covers the installation and configuration guide chapter 5 steps for Microsoft SQL Server 2005
Section "Preparing Your Data Store for Installing the Data Adapter" -> "Preparing Microsoft SQL Server for Installing the Data Adapter"
- Install SQL Server 2005
- Start SQL Server: start->all programs -> SQL Server Management Studio
- Connect to your server using SQL Server Authentication and the system administrator account (by default "sa")
- Create a new database:
- From the directory tree on the left pane, navigate to <my SQL server name> -> databases
- Right-click and select "New Database"
- In the "new database" dialog box, enter CT in the "database name" field
- In the database files section, replace the logical name by CT_Primary on the line with the filegroup field set to PRIMARY
- Click the "Add" button in the bottom right corner of the window to add the following lines:
+ One line with CT_DATA in the Logical Name and filegroup field (click on the filegroup field and then "<new filegroup>". In the "New filegroup for CT" popup window enter CT_DATA)
+ One line with CT_INDEX in the Logical Name in the Logical Name and filegroup field (click on the filegroup field and then "<new filegroup>". In the "New filegroup for CT" popup window enter CT_INDEX) - Click OK to create the database
- Create CT users (CT_ADMIN and CT_USER):
- From the directory tree on the left pane, navigate to <my SQL server name> ->Security -> Logins.
- Right-click and select "new login"
- In the "Login - New" dialog box, enter CT_ADMIN in the "login name" field
- Select "SQL Server Authentication"
- Choose a password for the CT_ADMIN user
- Uncheck the "User must change password at next login" and "Enforce password expiration" checkboxes
- Select CT as the default database
- From the directory tree on the left pane, navigate to <my SQL server name> -> Databases -> CT -> Security ->Users
- Right-click and select "new user"
- In the "Database user - New" dialog box, enter CT_ADMIN in the user name field. Use the "..." button to open the "Select Login" dialog box and enter "CT_ADMIN" as the login name.
- In the "default schema" field select "dbo".
Same steps for CT_USER
Section "Installing the RSA Access Manager SQL Data Adapter" -> "Running the Installation Script on Microsoft SQL Server":
- Start SQL Server: start->all programs -> SQL Server Management Studio
- Click on File -> open -> File
- Navigate to CT_HOME\data_adapters\sql\mssql, and open SqlServerCreateCT.sql
- Click "execute"
Notes
This also applies to Access Manager 6.2 as the install guide omitted these steps.