Changing the Servicing Director Customer Self-Service To Use a Different Microsoft SQL Server

Changing the Servicing Director Customer Self-Service To Use a Different Microsoft SQL Server

The Servicing Director Customer Self-Service web page add-on product connects to the Servicing Director SQL server by the following:

  • A Windows ODBC Data Source configured with the Microsoft SQL Server driver to connect to the Servicing Director SQL server.
  • A Customer Self-Service connection string. 

To use a different SQL server, use the procedure below. 

 


Reset your SQL logins:

Reset your Servicing Director SQL logins, using the LSCNFG server application, adding on executing the W_FixRights SQL command. For more information about resetting your Servicing Director SQL logins, search Knowledge Center with the key words Resetting the Servicing Director SQL Server Logins.

To change the ODBC data source: 

  1. On a Windows 32-bit computer, go to Control Panel > Administrative Tools > Data Sources (ODBC).

    On a Windows 64-bit computer, run C:\Windows\SysWOW64\odbcad32.exe.
  1. Click the System DSN tab.
  2. Click Data Source name "Servicing" to highlight it. 
  3. Click the Configure button. 
  4. Change the Server field on the DSN Configuration screen.
    You can enter the correct Microsoft SQL Server name (or Microsoft SQL Server Named Instance in the format ServerName\InstanceName), or you can select it from the list of servers on the list. Make no other selections or changes.
  5. Click Finish.

To change the Customer Self-Service connection string: 

  1. On the web application server, click Start > Programs > D+H > CSSWebAdmin > CSSWebAdmin.
    The CSSWeb Connection Editor screen appears.
  2.  In the Server field, enter your Servicing Director Database SQL server, or SQL server instance name.
  3. Verify the Database field is set to Service.
    Important! Do not change the Database field.
  4. Verify that the Username field is set to ILSWebUser.
    Important! Do not change the Username field.
  5. In the Password field, enter the default ILSWebUser password (shown in your Customer Self-Service Installation or Upgrade guide), or enter your custom password if you changed the ILSWebUser login password after you installed Customer Self-Service.
  6. Click Save.
  7. A message reminds you to restart IIS.
  8. Click OK, and then reset IIS.

Note: The new SQL server must have granted access to Customer Self-Service connections by executing the Service..W_Fixrights and SvcEventMgr..W_Fixrights SQL stored procedures once on the new SQL server. 

ArticleNumber:

000049234

    • Related Articles

    • Preparing a Fusion Servicing Director Disaster Recovery Server

      Use this article to prepare a Servicing Director server as a recovery server before your existing production server suffers a disaster or failure. Once the disaster recovery server is prepared, it can remain offline, until you need to update it with ...

    • Moving Servicing Director to a new production server

      Use the information in this article to move or migrate a Fusion Servicing Director production server to another server, creating a new production server. The procedures below are for your local IT or system administrator familiar with Windows and ...

    • Changing the Servicing Director ODBC Data Sources to To Use a Different Microsoft SQL Server

      The Servicing Director applications use Windows ODBC Data Sources configured with the Microsoft SQL Server driver to connect to the Servicing Director SQL server. The Data Sources for Servicing Director are automatically created by the Servicing ...

    • Resetting the Servicing Director SQL Server Logins

      You use the LSCnfg application Run FixRights option to reset the SQL Server logins used by the Servicing Director applications to connect to the Servicing Director SQL Server. Resetting the SQL Server logins will grant the logins access to newly ...

    • Resetting the Servicing Director 14.2 SQL Server Logins

      You use the LSCnfg application Run FixRights option to reset the SQL Server logins used by the Servicing Director applications to connect to the Servicing Director SQL Server. Resetting the SQL Server logins will grant the logins access to newly ...