SAP DB Connection error 000256

Posted on 2011-04-27
Last Modified: 2013-11-16
I have SAP CRM 7.0 and after migrating to another server i have problem with database connection:

In syslog I have:

SAP-Basis System: Initialization           DB-Connect Failed, Return Code  000256

In dev_w0 file:

ThInit: running on host db-sap02
M Tue Apr 26 14:38:32 2011
M  calling db_connect ...
C  Warning: Env(MSSQL_DBNAME) [ERD] <> Prof(dbs/mss/dbname) [CRD]. Profile value will be used.
C  Warning: Env(MSSQL_SCHEMA) [erd] <> Prof(dbs/mss/schema) [crd]. Profile value will be used.
C  Thread ID:2836
C  Thank You for using the SLOLEDB-interface
C  Using dynamic link library 'E:\usr\sap\CRD\DVEBMGS01\exe\dbmssslib.dll'
C  dbmssslib.dll patch info
C    patchlevel   0
C    patchno      110
C    patchcomment MSSQL: Connect error handling (1053754)
C  Network connection used from DB-SAP02 to DB-SAP01 using tcp:DB-SAP01
C  CopyLocalParameters: dbuser is 'crd'
C  dbs/oledb/schema crd <> SAPSYSTEMNAME ERD ==> connect terminated
M  ***LOG R19=> ThInit, db_connect ( DB-Connect 000256) [thxxhead.c   1426]
M  in_ThErrHandle: 1
M  *** ERROR => ThInit: db_connect (step 1, th_errno 13, action 3, level 1) [thxxhead.c   10283]

Open in new window

I've checked all environment setting I only could imagine.
I hope someone can help me with that.

Best Regards
Question by:f_o_o_k_y
    LVL 11

    Expert Comment

    it seems the migrated database does not have the same name and schema, have you checked that?
    C  Warning: Env(MSSQL_DBNAME) [ERD] <> Prof(dbs/mss/dbname) [CRD]. Profile value will be used.
    C  Warning: Env(MSSQL_SCHEMA) [erd] <> Prof(dbs/mss/schema) [crd]. Profile value will be used.

     are you trying to connect to a database whose name probably doesn't exist??
    LVL 11

    Author Comment

    On signle database instance I have three databses ERD, BWL, CRD
    and on second machine (SAPGLOBALHOST) I have two instances (applications) ERD - SAP ERP and CRD - SAP CRM

    ERD is working correctly.

    If you have any suggestion where I can check something, this ENV settings or anything else.
    LVL 11

    Expert Comment

    the warning says that the ENV settings and Profile settings are different and is taking the values from the profile
    Database "CRD", Schema "crd"

    later it says that the crd schema  points somehoy to ERD data SAPSYSTEMNAME ERD ,an aborts the coonection...

    then get rid of the first 2 warnings making the info on ENV and Prof being compatible...
    LVL 11

    Author Comment

    How can I achieve this?
    LVL 11

    Accepted Solution

    open the profile let say "default.pfl" and edit the parameters like


    and see if you can connect to ERD now...

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    Suggested Solutions

    Read about achieving the basic levels of HRIS security in the workplace.
    Messaging apps are amazing tools with the power to do a lot of good, but the truth is the process of collaborating with coworkers requires relationships established through meaningful communication - the kind of communication that only happens face-…
    Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
    This video discusses moving either the default database or any database to a new volume.

    754 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    25 Experts available now in Live!

    Get 1:1 Help Now