Skip to Content
0
Former Member
Mar 28, 2011 at 07:27 PM

ODBC Connection Issue

66 Views

Business Object XI 3.1 SP3

Windows 2003 server

Microsoft SQL 2000

Hi experts,

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

Local policies:

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

David

Edited by: Labelle David on Mar 28, 2011 9:32 PM