Skip to Content
0
Former Member
Apr 29, 2016 at 06:33 PM

Ecc6Sr2 connection to External system mssqlserver 2012 on windows 2003 servers

175 Views

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.

Attachments

dump.png (16.3 kB)