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