000026305 - How to install the Access Manager SQL data adapter on Microsoft SQL Server 2005

Document created by RSA Customer Support Employee on Jun 14, 2016Last modified by RSA Customer Support Employee on Apr 21, 2017
Version 3Show Document
  • View in full screen mode

Article Content

Article Number000026305
Applies ToRSA Access Manager 6.0.2
Microsoft SQL Server 2005
Microsoft Windows 2003
IssueInstall the Access Manager SQL data adapter on Microsoft SQL Server 2005
The installation guide only details the required steps for SQL Server 2000
ResolutionThe 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" check boxes
    - 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"
Legacy Article IDa46872

Attachments

    Outcomes