I am trying to establish a new source system in BW 3.1 SP13 with MS SQL server 2000 using DB Connect. We did follow all prerequisites of current DB CONNECT SAP documentation "Transferring Data with DB connect rel 3.0b.
We used transaction RSA1, source system, create, we select Database system (Data and Metadata Using SAP DB Connect) option.
At next screen we entered following parameters:
Logical system name: MSSQL01 (No logical system is yet define in SM59) for this system.
Source system name: MS SQL 01
At next screen:
DBMS= MSS,
User name = SA (Default MS SQL user defined)
DB password: appropriate password
Conn. info = MSSQL_SERVER=xx.xx.xx.xx MSSQL_DBNAME=Master
(This is based on SAP documentation)
Permanent = X
We saved and at the time that we exit the transaction we received an error saying No shared library found for the database ID SQL. (Error message BYG).
Our investigation proved that no ping activities occured on our MS SQL server (IP sniffer proved that)
Does anybody know how to fix this error.
OSS has nothing related to that error.
Prerequisites like DBSL (database Shared library component DLLs files) and DB client seems correct.
Marc