Question Re: Conect to MS SQL SERVER EXPRESS in Technology Q&A

Conect to MS SQL SERVER EXPRESS

elalan — Sat, 12 Sep 2020 01:24:48 GMT

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

Re: Conect to MS SQL SERVER EXPRESS

S_Sriram — Sat, 12 Sep 2020 06:25:26 GMT

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

Re: Conect to MS SQL SERVER EXPRESS

Stefan-Schnell — Sat, 12 Sep 2020 09:21:19 GMT

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

Re: Conect to MS SQL SERVER EXPRESS

elalan — Sat, 12 Sep 2020 11:47:00 GMT

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

Re: Conect to MS SQL SERVER EXPRESS

Stefan-Schnell — Sat, 12 Sep 2020 17:21:31 GMT

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.

Re: Conect to MS SQL SERVER EXPRESS

elalan — Sat, 12 Sep 2020 18:35:59 GMT

Thanks a lot , a million points to ypu