SQL Server Error when tryingt to install the CMS DB on SQL Server 2005 x64

56 Views

I am trying to install BOEXI R3 on w2k3 64-bit OS in a SQL Server 2005 x64 database, I am currently at the installation step where i Specify an exisiting CMS database. I created a System DSN and tested it, and it was successful. So when I got to the screen where I select my datasource I had to check use trusted connection because the datasource would not show up when Use DSN created by WOW64 option was checked. From there I could select the database I created. Oh yeah, I also made the application server local system account part of my DB admins group so it has full access to the database yet when I click next to connect I get a CMS Database Error: STU000226. here is what I have in my log:

ThreadID Message

(Thu Apr 23 20:57:46 2009) 3024 3028 trace message: findDFA_LLR: (CmdLineDir) C:Documents and SettingsgsdadminDesktopBOEXI and BSM AnalyticsBOEXI R3 Full Version from SAPpackagedbcheck

sqlrule.llr

(Thu Apr 23 20:57:46 2009) 3024 3028 trace message: Loading: database subsystem only

(Thu Apr 23 20:57:46 2009) 3024 3028 trace message: loading libary succeeded

(Thu Apr 23 20:57:46 2009) 3024 3028 trace message: DatabaseSubsystem::Init()

(Thu Apr 23 20:57:46 2009) 3024 3028 (.wireobinit.cpp:96): trace message: Creating the shared CWireObject::PropertyNameMap

(Thu Apr 23 20:57:46 2009) 3024 3028 (.wireobinit.cpp:118): trace message: Setting static property map

(Thu Apr 23 20:57:46 2009) 3024 3028 (.wireobinit.cpp:125): trace message: CWireObject::InitializeStaticPropertyMap() - reference count: 1

(Thu Apr 23 20:57:46 2009) 3024 3028 trace message: initializing subsystem succeeded

(Thu Apr 23 20:57:46 2009) 3024 3028 trace message: Loading: done loading subsystem - database subsystem only

(Thu Apr 23 20:57:46 2009) 3024 3028 trace message: DatabaseSubsystem::Connect()

(Thu Apr 23 20:57:46 2009) 3024 3028 (.DBConnectionManager.cpp:802): trace message: DBConnectionManager - Setting total target number of connections for pool 0 to 1.

(Thu Apr 23 20:57:46 2009) 3024 3028 (.SQLServerDatabase.cpp:119): trace message: SQLServer error found: ErrorMessage( (Microsoft)[ODBC Driver Manager] Data source name not found and no default driver specified), ErrorCode(0)

(Thu Apr 23 20:57:46 2009) 3024 3028 (.dbutils.cpp:820): trace message: Caught DatabaseSubystem Error: BusinessObjects Enterprise CMS: Unable to connect to the CMS system database "BOEXI_CMS". Reason: (Microsoft)[ODBC Driver Manager] Data source name not found and no default driver specified

(Thu Apr 23 20:57:46 2009) 3024 3028 trace message: DatabaseSubsystem::Shutdown()

(Thu Apr 23 20:57:46 2009) 3024 3028 (.wireobinit.cpp:175): trace message: CWireObject::TerminateStaticPropertyMap() - reference count: 1

(Thu Apr 23 20:57:46 2009) 3024 3028 (.wireobinit.cpp:182): trace message: Releasing

static property map

How do I get past this?