Open topic with navigation

Troubleshooting New SQL Server

We switched to new SQL servers and now cannot connect to CAMS Enterprise.

Problem: Moved the databases to a new server setup but CAMS Enterprise will not work.. Some errors that may be seen are Internet Client Error: Request Timeout and Object required: ‘objCamsUsers.GetLicenseList(…)’.  Another error you may notice in the Error Log:

Event Type: Error

Event Source: VBRuntime

Event Category: None

Event ID: 1

Date: 6/12/2006

Time: 9:32:40 AM

User: N/A

Computer: CAMS1

Description:

The VB Application identified by the event source logged this Application CamsUser: Thread ID: 4556 ,Logged: New transaction cannot enlist in the specified transaction coordinator. [-2147168246)

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

 

Possible Solution:

  1. Change the database server name in CE global.asa, and all the portal’s global.asa to the new server name,  Also in the SQLServerName field of the CAMS_Administration..CAMSLicenses table from existing server name to the new server name.
  2. Ensure that MSDTC is set up according to the pre-installation checklist and then reboot the IIS server. When it is completely up restart the SQL server. See Msg 7391 on page 47.
  3. Ensure that DNS is correctly set up.  Have TWO people verify the IP addresses.
  4. Ensure that all CAMS related databases, CAMS_Administration, CAMS_Enterprise, and CAMS_Enterprise_Test, have the CAMSUser SQL account as the dbo.
  5. Ensure that all CAMS related databases, CAMS_Administration, CAMS_Enterprise, and CAMS_Enterprise_Test, have the CAMSUser SQL account as the dbo.

Back to Troubleshooting Menu