Skip to Content
0
Former Member
Sep 12, 2007 at 01:01 AM

Clustering and SQL Server 2005 SP1

28 Views

Post Author: acarruth

CA Forum: Administration

Hi, We have one XI R2 SP2 server up and running, and it is leveraging a database on a separate SQL Server 2005 SP1 machine for the CMS DB. We now have a second machine, which is identical to the first in terms of hardware, OS, and XI. I created an ODBC DSN on server 2, which matches what is created on server 1 (same name, uses same credentials, same driver). When I test the connection in the ODBC setup screen, it says it is successful. However, when I point server 2's CMS to this DSN, and then start it, it fails saying (in the Event Viewer):

Event Type: Error Event Source: BusinessObjects_CMS Description: The root server reported an error Initialization Failure. (Reason: Database access error. Reason [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot find the object "CMS_IdNumbers5" because it does not exist or you do not have permissions..).

Has anyone experienced this before? It seems as though only one connection at a time can access the SQL Server database? Windows 2003 Server SP1 SQL Server 2005 SP1 (9.00.2047) BOE XI R2 SP2 RTM SQL Server ODBC Driver 2000.86.1830.00Thanks! Allan