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,

Its not Unix.

My SAP Server is Windows 2008 64bit and SQL Server is Windows 2008 R2 64bit.

Thanks,

Usman Malik

[Former Member]

Did you try creating an ODBC for you external system ? as per my previous answer.

Mark

[Former Member]

DB Connection WHATEVER_NAME_YOU_WANT

DBMS MSS

User Name DB_USERNAME

DB password password_is_life /

Conn. info MSSQL_SERVER=MY_SERVER_NAME SQL_DBNAME=SQL_SERVER_DB_NAME