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

[Former Member]

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?

[Former Member]

I am having the same problem to install the CMS on a SQL server 2005 x64 bit server. It seems like a straight forward installation. I have tried several times and still no success. If someone has a solution to this I would certainly appreciate some feedback. This is my first install of the CR server software. I am anxious to get in in production!

Regards,

Ron

[Former Member]

Hi,

Pleaes check the following -

1. Check that the database and architecture platform is supported.

2. Use SQL server native 32bit client for the DSN.

Hope it helps.

Cheers,

Subhodeep

[Former Member]

The workaround was, I installed the SQL Server Client tools and created a System DataSource and then had to create a user DataSource (it is a quirk in the installer I guess) to get past this point in the installation. Now I have an even bigger problem. Everything but the CMS installed and the installer hung at the "Configuring the CMS" part. The installation finished but when I tried to log into the Central managment console I got this error:

Error: Server GSD-RRPT-RDC:6400 not found or server may be down (FWM 01003) null

I looked at the forums for the cause of this error and came to the conclusion that BOEXI does not support an installation on SQL Server 2005 when using Integrated Authentication to the SQL Server. See the engineers here disabled SQL Authentication for the SQL Server and will not allow it.

Is this true? Or is there a workaround to install the CMS using Integrated Authentication in the DataSource ?

Thanks.

[BasicTek]

there was a bug in XIR2 for installing the DB with AD accounts. I think it was fixed at some point(not sure when) and I'm pretty sure it's working on XI 3.1.

Regards,

Tim

[Former Member]

Hi

did you setup the odbc with the 32 driver.

C:\Windows\SysWOW64\odbcad32.exe

Do not use the one in the control panel.

Rob