Skip to Content
0
Former Member
May 07, 2013 at 08:04 AM

Can't connect to DS Repository (SQLServer Express) using al_engine.exe

123 Views

Hi Expert,

We would like to ask a question about using al_engine.exe to backup/import ATL to DS repository.

We referenced the following page and create a bat file to export certain DS repository

http://wiki.sdn.sap.com/wiki/display/Snippets/Data+Services+-+ATL+Import+Automation

Our Server Config:

BO DS 4.0 SP2 Patch 4

DS Client : 14.0.1.142

Repository DB: SQL Server Express 2008 R2

Note: We use Data Services Repository Manager to create the repositories.

We run the bat file in DS server. However there's error to initiate connection to SQL Server database.

D:\DeployConfig\TESTETLScript>set BIN="D:\SAP BusinessObjects\Data Services\bin\al_engine.exe" -g -NMicrosoft_SQL_Server

-SBOE140 -Q<repo_dbname> -U<repo_username> -P<repo_userpwd>

D:\DeployConfig\TESTETLScript>"D:\SAP BusinessObjects\Data Services\bin\al_engine.exe" -g -NMicrosoft_SQL_Server -SBOE14

0 -Q<repo_dbname> -U<repo_username> -P<repo_userpwd> -X

(14.0) 05-07-13 11:25:58 (E) (8584:1804) CON-120302: Initialization

ODBC call <SQLDriverConnect> for data source <BOE140> failed: <[Mic

rosoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not

exist or access denied.>. Notify Customer Support.

Have you encountered this problem before? Any configuration in DS repo / server is missing?

Attached plz find the script and the run log for your reference. Thanks.

Attachments