Skip to Content
0
Former Member
Jun 04, 2008 at 12:54 PM

MSSQL Extraction error

24 Views

Hi all,

I am trying to connect the MSSQL 2005 Database to the SAP BI system through RAC.During the creation of the source System(DB Connect) it placed an error as

DIA RSA1 BY G No shared library found for the database with ID SALMSSQL.

Can someone please let me know how we can comeup with this issue?Where we can download LIB_DBSL.SAR and the process to load it into theDIR_LIBRARY default path as we are using RAC connectivity.During the process of creation DB connect source system for MSS what we need to fill for the Connection Info option i.eConn. info MSSQL_SERVER= ? MSSQL_DBNAME= ?

System IP or the IP of Database and which Databasetable

There are more than one database in the SQL server so should I give only the relevant Database name which I will be using to extract?

Do we need to create views on the tables of SQL or we can directlr generate DS for those?

Please help me on this with steps to be taken.

DB Connection MSSQL

DBMS MSS

User Name sa

DB password /

Conn. info MSSQL_SERVER= ? MSSQL_DBNAME= ?

Connection Limit

Optimum Conns

Will reward points.

Thanks

D