Problems with connection to external DB

[Sandra_Rossi]

Hi all,

I’m having a problem with a connection to a (external) SQL Server database. I already have a connection that works OK. Now, I’m trying to create a connection to a second DB and keep getting an error message when checking it with ADBC_TEST_CONNECTION. Both connections work ok using an external program (SQUIRREL, using JDBC drivers).

The string I’m using is as follows:

MSSQL_SERVER=xx.xx.xx.xx MSSQL_DBNAME=DBNAME1

When I change the IP and DB Name and try to connect to the new Server I get:

Could not open connection DBNAME2

sql error22occured:

Client unable to establish connection

There are two things to of interest here. The first, that there is no port number for DBNAME1 (which works correctly). Also, for this DB the password consists entirely of numbers, and it does not seem to be encrypted when you check DBCON with SE16n.

So I tried to add the port number to the IP (:1433), and still got an error when trying to connect.

Any ideas?

Thanks beforehand and stay safe,

Regards,

Luis

[Sandra_Rossi]

Did you check the note 178949 - MSSQL: Database MultiConnect? (it's explained how to specify the port)

[luis_rod]

Sandra,

Thanks for your post.

No, I'm afraid I didn't check the note. I assumed that, as the first connection string worked ok (without the port number), the second would work as well.

Also, right now the people in charge of the Notes is out of touch (we are working with a very reduced staff right now, due to lockdowns).

Will try to retrieve it. Thanks

[Sandra_Rossi]

To help, here's an excerpt from the note:

Enter the required connection data into the table DBCON in transaction DBCO...:

CON_NAME: <my_conn_name>
DBMS: MSS
USER_NAME: <db_user>
PASSWORD:  <password>
CON_ENV: MSSQL_SERVER=<server_name> MSSQL_DBNAME=<db_name>

...

A port number can be added to the server name:

<servername>,<port number>

[S_Sriram]

Hi Luis

Could you refer the blog about the external db connection using jdbc driver

https://wiki.scn.sap.com/wiki/display/SAPSQL/Database+Connection+and+DBSL

Regards

SS

[luis_rod]

Will do. Thanks.