Access SQLExpress Database in SAP

[Former Member]

Hai everyone,

I have to access database sqlexpress from another computer, I set the connection in DBCO.

but when I run native sql to get connection in the database, the database name changed into 'DEFAULT' and can't connect to the database.

How can i fix the problem ? Any tips welcome

Thanks

[Former Member]

Thanks,

That is a very useful help.

Regards,

Kristanto

[former_member524429]

Hi,

Thanks for closing this thread.

Regards,

Bhavik G. Shroff

[former_member524429]

Hi,

Have you referred this Useful [SAP Note 323151 - Several DB connections with Native SQL|https://service.sap.com/sap/support/notes/323151] and[ SAP Note 738371 - Creating DBCON multiconnect entries for SQL Server|https://service.sap.com/sap/support/notes/738371] ? Read them and do the required configuration settings if any one is missing.

As per SAP Note 738371,

The application server(s) where a DBCON connection is used must be running Windows,
and they must have the MS SQL Server DBSL library dbmssslib.dll installed in the run directory.
If your database platform is not SQL Server, then this DLL must be downloaded from the SAP Service Marketplace for your R/3 kernel version.

Also tell...

Value of <con_name> in CONNECT TO ... and SET CONNECTION... are same ?

SAP System in which DBCO entry is maintained is running on which OS Platform ?

Required DLL (DBMSSSLIB.DLL) has been put in SAP Instance's Kernel executable directory (If SAP system is running on Windows platform)?

Regards,

Bhavik G. Shroff