Conect to MS SQL SERVER EXPRESS

[elalan]

Hello to all , i read a lot of info but i still not sure , is possible to conect SAP ECC to SQL SERVER EXPRESS ?? ,i mean that sql express is a remote database where i'm gonna read and insert some data but i not sure if dbco can be integrate woth thos version , or is the same as SQL SERVER standar ???, thanks a lot

[stefan_schnell · Accepted solution]

Hello Alan,

sure. Here my DBCO settings. I use the sa (System Administrator) as User Name and in the Connection Info only the IP address of the server.

You can set up the sa account the database engine configuration dialog.

To test your connection, open TAC SE38 and enter the program name ADBC_TEST_CONNECTION, choose the connection name, in this case MSSQL, and execute the report. If all works well, you will see this result.

Best regards
Stefan

P.S. Sorry, it is necessary to post this as answer, it is not possible to submit it as comment.

[elalan · Accepted solution]

Thanks a lot , a million points to ypu

[stefan_schnell]

godstorm

Hello Alan,

yes, it is possible. I tried it a few month ago, but only for experimental reasons. I used Microsoft SQL Server 2019 Express 15.0.2000.5. And don't forget to install the correct dbmssslib library. You can find a good introduction here.

Best regards
Stefan

[elalan]

Thanks a lot , can you help me with the dbco ?? , how do you config it ?

[Sriram2009]

Hi Alan.

I am not sure about the MS Sql express edition, refer the blog it may help you

https://blogs.sap.com/2013/01/19/how-to-access-an-external-microsoft-sql-server-database/

Regards

Sriram