We have noticed that over time the default Microsoft Jet database that is used during the default SSRPM install can start develop performance issues. We have also noticed that the majority of these issues can be resolved by using a Microsoft SQL database instead of a Jet database. These instructions will guide your migration from an existing SSRPM Jet database and retain enrollments. This guide assumes you already have a instance of Microsoft SQL Server running and SQL Server Management Studio installed and available.


a1. Within SQL Server Management Studio, connect to your desired SQL instance.

a2. Right-click any existing database or the 'Databases' folder in the Object Explorer on the left side.

a3. Click 'New Database...'

a4. In the 'New Database' window give your database a name. Something unique like, SSRPM_LocationName

a5. Click OK. An empty database will be created.

a6. Right-click the new database in the database list and choose 'Tasks' >  'Import data...'.

a7. In the 'SQL Server Import and Export Wizard' click the data source dropdown list and choose 'Microsoft Access (Microsoft Jet Database)'.

a8. To the right of the 'File Name' box, click the browse button. The default path to the SSRPM Jet database is 

"C:\Program Files (x86)\Tools4ever\SSRPM\Service\DataBase\SSRPMDataBase.md"

a9. Click 'Open'.

a10. Back in the wizard click the 'Next' button at the bottom of window (There is no username or password).

a11. Now, in the 'Destination:' drop down menu choose 'SQL Server Native Client ##.#'.  The ##.# will defer depending on which version of SQL server is installed.

a12. The 'Database' dropdown menu should already have your empty SQL database selected. If not change it to the correct database name.

a13. Click 'Next >'.

a14. Leave 'Copy data from one or more tables or views' selected and click 'Next >'.

a15. You will be presented with a list of all of the tables within the Jet database. At the very top of the list is a checkbox next to 'Source: C:\Program Files (x86)...'. Check this checkbox. All of the listed checkboxes will now be checked and values will be written in the 'Destination' column for each table.

a16. Click 'Next'.

a17. The 'Run immediately' box should be checked. If not, check it. Click 'Next >'.

a18. Click 'Finish'. The data will now be imported into SQL. Depending on the size of the Jet database this may take some time to finish.



SQL server has it's own set of security roles and users. If you haven't already added security logins for your SSRPM service account, do the following within SQL Server Management Studio:

b0. Open SSMS and connect to your SQL server if you have not already.

b1. Expand 'Security' > 'Logins' in the 'Object Explorer' on the left side.

b2. Right-click the 'Logins' folder and choose 'New Login...'.

b3. Click the 'Search...' button to the right of the 'Login Name:' box.

b4. Type the name of the AD account that is running the SSRPM Windows service.

b5. Click 'OK'. You will be dropped back to the 'Login - New' window and the 'Login Name:' box will be populated.

b6. Select 'User Mapping' in the 'Select a page' list.

b7. Check the 'Map' column checkbox next to the database name you wish to give the SSRPM service access (database created in sequence "a" above) in the 'Users mapped to this login:' area. The User column will now be populated with the account name and remain highlighted.

b8. In the 'Database role membership for: *databaseName*' area check the checkbox next to 'db_owner'.

b9. Click OK. The user is now in the SQL server logins list.



After the Jet to SQL data transfer is complete (step sequence a).

c1. Open the SSRPM Management Console.

c2. Click the 'Service Management' > 'Configure...' menu.

c3. Within the Service configuration window click the 'Database' tab.

c4. Click the 'Microsoft SQL' radio button.

c5. A warning about changing the connection string will display. Click 'Yes'.

c6. Click the 'Connection String Wizard...' button.

c7. In the 'Data Link Properties' window click 'Microsoft OLE DB Provider for SQL Server'.

c8. Click 'Next >>'.

c9. Enter the SQL server name into box 1 or click the dropdown menu to select the server.

c10. Choose the 'Use Windows NT Integrated security:' radio button.

c11. Select the 'Select the database on the server:' ratio button.

c12. Click the dropdown list of existing databases and choose the SQL database created earlier in this process.

c13. Click 'OK'. The Connection String box will now have a SQL connection string listed.

c14. Click 'OK'.

c15. Close the SSRPM admin Console and re-open it. Your console should still show the same number of enrolled users.