Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 4492
  • Last Modified:

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
0
f_o_o_k_y
Asked:
f_o_o_k_y
  • 3
  • 2
1 Solution
 
pmasottaCommented:
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??
0
 
f_o_o_k_yAuthor Commented:
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.
0
 
pmasottaCommented:
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...
0
 
f_o_o_k_yAuthor Commented:
How can I achieve this?
0
 
pmasottaCommented:
open the profile let say "default.pfl" and edit the parameters like

dbs/mss/schema=erd
dbs/mss/dbname=ERD

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

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now