Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Ecc6Sr2 connection to External system mssqlserver 2012 on windows 2003 servers

Hi ,

We had requirement to connect our Sap Ecc6 system which is on windows 2003 server need to integrate with External system mssqlserver 2012

we had already followed the notes as per smp. and configured accordingly but still facing issues. please find the logs below.

Fri Apr 29 23:58:04 2016

B  create_con (con_name=SSGDSN)

B  New connection 3 created

B  Connect to SSGDSN as SelectTimesheet with MSSQL_SERVER=172.2.254.254 MSSQL_DBNAME=Timesheet

C  Thread ID:8932

C  dbmssslib.dll patch info

C    patchlevel  0

C    patchno      350

C    patchcomment Work process can not be cancelled (1740162)

C  Network connection used from SAP-sid-sid to 172.2.254.254 using tcp:172.2.254.254

C

C Fri Apr 29 23:58:05 2016

C  OpenOledbConnection: line 24516. hr: 0x8000ffff Login failed for user 'SelectTimesheet'.

C  sloledb.cpp [OpenOledbConnection,line 24516]: Error/Message: (err 18456, sev 0), Login failed for user 'SelectTimesheet'.

C  Procname: [OpenOledbConnection - no proc]

C  sloledb.cpp [OpenOledbConnection,line 24516]: Error/Message: (err 0, sev 0), Invalid connection string attribute

C  Procname: [OpenOledbConnection - no proc]

C  failed to establish conn to tcp:172.1.254.254.

C  Retrying without protocol specifier: 172.1.254.254

C  OpenOledbConnection: line 24516. hr: 0x8000ffff Login failed for user 'SelectTimesheet'.

C  sloledb.cpp [OpenOledbConnection,line 24516]: Error/Message: (err 18456, sev 0), Login failed for user 'SelectTimesheet'.

C  Procname: [OpenOledbConnection - no proc]

C  sloledb.cpp [OpenOledbConnection,line 24516]: Error/Message: (err 0, sev 0), Invalid connection string attribute

C  Procname: [OpenOledbConnection - no proc]

C  failed to establish conn. 0

B  ***LOG BY2=> sql error -1        performing CON        [dbds#1 @ 1044] [dbds    1044 ]

B  ***LOG BY0=> Login failed for user 'SelectTimesheet'. [dbds#1 @ 1044] [dbds    1044 ]

B  ***LOG BY1=> sql error -1        [dbacds#2 @ 1433] [dbacds  1433 ]

Kindly do the needful asap.

Former Member
Not what you were looking for? View more on this topic or Ask a question