Skip to Content
avatar image
Former Member

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.

dump.png (16.3 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Apr 30, 2016 at 03:55 AM

    Hi Abdul.

    1. From the log you have to check the user id / password or external database access rights

    2. Refer the scn link How to access an external Microsoft SQL Server database

    BR

    SS

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 03, 2016 at 05:06 AM

    Hi ,

    Sorry for the delayed response.

    we are on 700 Kernel Release and level  sp level 31.

    Thanks,

    Abdul

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 03, 2016 at 12:23 PM

    Hi Abdul,

    Kindly check the sapnote 178949 - MSSQL: Database MultiConnect


    is your current SAP system is on mssql database?

    I think there is some problem with the driver.

    1774329 - Preparing your SAP instance to connect to remote SQL server


    2193929 - Remote SQL Server cannot be connected after applying support package.

    With Regards

    Ashutosh Chaturvedi

    Add comment
    10|10000 characters needed characters exceeded