How to Change the name of the SQL database CA Output Management Web Viewe r11.5 is Using

Document ID : KB000009513
Last Modified Date : 14/02/2018
Show Technical Document Details
Introduction:

These are the steps to take to change to a new SQL SERVER Database for CA Web Viewer Output Management Web Viewer 11.5.

Background:

You will be changing the name in the ODBC layer, not in the Admin Tool. The name that you are using in CA Web Viewer is a symbolic name for the data source. CA Web Viewer does not store anything but the symbolic name. It accesses the database through the ODBC connection. The ODBC connection resolves the symbolic name to the actual server name.

Environment:
ODBC
Instructions:

Here are the steps:

  1. Locate the 32 bit version of ODBC- odbcad32.exe in the C:\Windows\SysWOW64 folder and click on it to run it.

    odbc.PNG

  2. VERY IMPORTANT - do not start Data Sources (ODBC) from the control panel as this will start the 64 bit version by default and this will work correctly.
  3. Click on data source name - you will see the ODBC name used by CA Web Viewer.
  4. Click configure and the wizard starts.
  5. In the drop down box labeled:
    Which SQL server do you want to connect to?
    Choose the new server name. (which is the nodename)
  6. Finish the screens in the wizard - you should not have to change anything.

The password that is set in the CA Web Viewer Admin Tool must be updated for the new database.

  1. Update the userid and password in the Admin Tool by selecting FILE-> Configure Server settings.
  2. Recycle IIS using

Net stop iisadmin /y
Net start w3svc

 CA Output Management Web Viewer will now be pointing to the new database you specified.