How to install RSA Access Manager SQL data adapter on Microsoft SQL Server 2005
Originally Published: 2009-07-29
Article Number
Applies To
RSA Version/Condition: 6.0.2
Microsoft SQL Server 2005
Microsoft Windows 2003
Issue
The installation guide only details the required steps for SQL Server 2000
Cause
Resolution
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".
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
Related Articles
Microsoft SQL Server Collectors can no longer connect to the SQL Server database after upgrade to Microsoft SQL Server 201… Number of Views Microsoft SQL server collector fails intermittently in RSA Identity Governance & Lifecycle Number of Views The documentation for enabling the RSA Database Security Manager adapter for SQL Server 2005 discusses the requirement for… Number of Views Unable to install RSA Authentication Manager Web Tier on Microsoft Windows Server Number of Views RSA Identity Governance and Lifecycle - SQL Server 2005 Collector Datasheet Number of Views
Trending Articles
RSA SecurID software token .sdtid file fails to import into RSA SecurID Software Token 5.0 for Windows How to manipulate imported RSA SecurID Software Token(s) on an iPhone or iPad device RSA Authentication Manager 8.7 SP2 Setup and Configuration Guide AFX Server stuck in 'Not running' State, with error 'timed out waiting for AFX applications to start' RSA® Release Notes for RSA Authentication Manager 8.7 SP2
Don't see what you're looking for?
