DataPower® Learning Online

Using a non sa login for the DPLOnline database 

DPLOnline is using the MS SQLServer login sa as the default  database login. On MS SQL Servers where DPLOnline is not going to be the only database, the Database Administrator might want to use a different login for DPLOnline. This file describes how to install or set DPLOnline to use a custom SQL Server login. 

1. Installing a new DPLOnline database using a custom login

When installing DPLonline for the first time on a server, this chapter replaces chapter 3 in the original Installation help file. (Readme.htm on the application CD)

  1. Start SQL Enterprise Manager
  2. Create a new database called DPLOnline. Set database file to 50 MB and log to 10 MB
  3. Create a new SQL Server login (eg. DPL), and set a password.
  4. Make the login created in step 3 dbowner of the DPLOnline database. To do this start SQL Server Query Analyser (or i/SQLw in SQL Server 6.5) . Select the DPLOnline database, and change the dbowner by using the sp_changedbower stored procedure (eg. Exec sp_changedbowner 'DPL')
  5. Start Winadmin from the DataPower Learning Online programs group.
  6. In the welcome dialog, supply name for DataPower Learning virtual directory used on the IIS (given in step 1.3.3 or 2.3.3 in the original Installation help file ). If you are going to run DataPower Learning Online from the root directory of your website, leave this field empty.
  7. In the "Data Link Properties" dialog, ensure you are using the "Microsoft OLE DB Provider for SQL Server" data provider, enter server name, enter the login name and password created in step 3, and select the DPLOnline database created in step 2.
    Select OK.
  8. In the "New Administrator" dialog supply given Organization ID and user data for the administrator user account.
  9. In the "Organization" tab supply name and address information of your organization.
  10. Select the "Category" tab to supply from 1 to 5 information categories that the users will be prompted for upon registration. (Department, Skill level ...). This information will also be used for administration and reporting purposes. 

2. Changing database login for an existing DPLOnline database

  1. Start SQL Enterprise Manager
  2. Create a new SQL Server login (eg. DPL), and set a password.
  3. Make the login created in step 3 dbowner of the DPLOnline database. To do this start SQL Server Query Analyser (or i/SQLw in SQL Server 6.5) . Select the DPLOnline database, and change the dbowner by using the sp_changedbower stored procedure (eg. Exec sp_changedbowner 'DPL')
  4. Start Winadmin from the DataPower Learning Online programs group.
  5. Verify that the Virtual directory selection in Winadmin is equal to the setting for the virtual directory used on IIS for DPLOnline. Click the connection button.
  6. Change the login and password setting according to the user created in step 2. Select the 'Allow saving of password' check box. Test the connection. Click OK.
  7. Close winadmin.
  8. To verify that the new login is used, start your browser and go the the following url: http://<YourServer>/<DPLonlineDirectory>/system.asp (eg. http://localhost/dplonline/system.asp). Login with username: info and password: info. Verify that User ID in the DB Connection section equals the login created in step 2.