Business Object XI 3.1 SP3
Windows 2003 server
Microsoft SQL 2000
During the installation of Business Object XI 3.1 SP3, I have an error STW00213. I checked all SAP KB for this error and most of the time the answer is "Not enough access" . The user I use for the installation is admin of the server + dbo of the databases + he had a bunch of Local Policies access (see list below). Anyway, when we have the error STW00213, we can click RETRY or CANCEL and continue the installation... I choose cancel because RETRY does nothing. When the installation is done, everything looks good except there is no SIA. Decide to add manually a SIA! I think my real problem start here... When I specify my ODBC in the SIA, I have an error msg
"Database access error. Reason [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near '\'..."
I decide to log all sql query from that odbc and find that the SQL don't have quotes for my credential ex: SELECT * FROM MYDOMAIN\dlab.CMS_Infoobjects6 where ... The sql is supposed to look like that to work SELECT * FROM "MYDOMAIN\dlab".CMS_Infoobjects6 where ...
The option "Use ANSI quoted identifiers" is checked in my DSN configuration.
I tested the ODBC in the DSN configuration interface and everything is good. And for your info, all CMS tables were created during the installation...
I tried ODBC with SQL 2000, native client 2005 and native client 2008
Act as part of the Operating System
Log on as a batch job.
Log on as a service.
Replace Process Level Token Policy.
Adjust memory quotas for a process.
Access this computer from the network.
Allow log on locally
Create a token object
Thank you for your help
Edited by: Labelle David on Mar 28, 2011 9:32 PM