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

[Former Member]

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.

[denise_meyer]

Hi Vicky,

Are you using the SQL Server express that is installed with BOE?  Please reference KBA 1530972 for more information (https://service.sap.com/sap/support/notes/1530972)

This uses a SQL Server named instance, so to ensure that you are filling out all the parameters correctly, then please refer to this KBA in help with figuring out what the correct hostname\named instance should be as well as port information for it, in order to pass your connection information correctly.

Thanks,

Denise