asked on

SAP DB Connection error 000256

Hello,
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  
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]
M

Open in new window

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

Best Regards
FooKy

pmasotta

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??

f_o_o_k_y

ASKER

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.

pmasotta

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...

f_o_o_k_y

ASKER

How can I achieve this?

ASKER CERTIFIED SOLUTION

pmasotta

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial