To configure CRS Plus to work with SQL Server database

1. 
   Prepare your database on MS SQL Server:
   
   1. 
      Create a database and database user account(s) on MS SQL Server; the user account should have both read and write access to the database.
      
   2. 
      After creating the database, import all tables from C:\RegPlus\CRSPlus\MDBS\Registry200.mdb to the newly created database.
      
   3. 
      After all tables are imported, please refer to the instructions provided in the “CRS Plus Indexes.doc” document (located in C:\RegPlus\CRSPlus folder) to create indexes on the tables. 
      
2. 
   Modify the CRSPlus.ini file:
   
   1. 
      Open CRSPlus.ini file in C:\Windows folder
      
   2. 
      Change the database mode to Client/Server.
      
      1. 
         Remove REM: from the second line (RegDBMode=Client Server)
         
      2. 
         Add REM: to the beginning of the third line (RegDBMode=File Server)
         
      3. 
         Add REM: to the following line in the [DATABASE] section:
         

3. 
   Configure the connection string: There are two sample connection strings at the bottom of the CRSPlus.ini file to connect to the SQL Server database, one using the integrated security and the other using the SQL server authentication. Depending upon the practice of your organization:
   

1. 
   Select the appropriate connection string type.
   
2. 
   Modify the parameters to match your setting.
   
3. 
   Remove the REM: from the connection string.
   

To use Prep Plus in a networked environment, modify PrepPlus.ini (in C:\Windows folder) to point several folder paths and databases to shared network drives instead of local drives. The PrepPlus.ini file includes comments about how to make changes to parameters.

If you have further questions about setting up either the CRS Plus or Prep Plus applications in a production environment, have your IT person contact us (e-mail: cdcinfo@cdc.gov).