Connect SQL Server through DBCO - DBCONNECT

[Former Member]

Hi Guys,

I am trying to connect to one of the SQL Server in my Domain. I have made entries as mentioned by SAP note in DBCO Transaction. When I am testing connection through program 'ADBC_TEST_CONNECTION' it is showing me following error:

Testing a Database Connection Defined in DBCON

Could not open connection SQLCONNECTION

sql error 1- occured:

I have already installed DBMSSSLIB.DLL in executable directory also.

Please advice.

Thanks,

Usman Malik

[Former Member]

Hi,

As mentioned I have put these files i.e. DBMSSSLIB.DLL and DBMSSSLIB.PDB (64bit) in the following directories and restarted the server:

X:\usr\sap\SID\D*\exe

X:\usr\sap\SID\sys\exe\run

X:\usr\sap\SID\sys\exe\ (i386 or ntamd64) \ (nuc or uc)

tried again but still it is showing the same error when i execute ADBC_TEST_CONNECTION program in SE38:

-

---

Testing a Database Connection Defined in DBCON

Could not open connection ABC

sql error 1- occured:

-

---

SQL Server is Standard Edition and OS is Windows 2008 R2 64bit. Our SAP Server is also Windows 2008 64bit.

Please advice what to do now because I have done entries in DBCO Transaction correctly as mentioned by the note 178949 i.e.

CON_NAME: <my_conn_name>

DBMS: MSS

USER_NAME: <db_user>

PASSWORD: <password>

CON_ENV: MSSQL_SERVER=<server_name> MSSQL_DBNAME=<db_name>

I am using SQL Server Administrator Username/Password to connect to this Server.

Thanks,

Usman Malik