[SQL Server] Invalid object name ‘DBPROPERTIES’, ‘SVERS’

Symptom

You are executing a system copy (backup and restore method) and when you are trying the bring up the SAP system – below error coming out.

Your SAP system is installed under Windows Server operating system and Microsoft SQL Server database.

ERROR: -1 in function CheckCodepageType (SQLExecDirect failed) [line 21660]
(208) [42S02] [Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid object name ‘DBPROPERTIES’.

ERROR: -1 in function StartSelect (execute)
(208) [42S02] [Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid object name ‘SVERS’.
ERROR: -1 in function StartSelect (execute)
(8180) [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Statement(s) could not be prepared.
Error 103 (dbcode 208) in StartSelect
StartSelect: stmt of NULL_STMTID
SELECT VERSION FROM SVERS
/* R3::0 T:SVERS M: */

***LOG BZA=> table SVERS does not exist on database
***LOG R19=> ThDbConnect, db_connect ( DB-Connect 004096) [thDatabase.c 79]
in_ThErrHandle: 1
*** ERROR => ThInit: db_connect (step TH_INIT, thRc ERROR-DB-CONNECT_ERROR, action STOP_WP, level 1)

M *****************************************************************************
M *
M * LOCATION SAP-Server IDES_DEV_00 on host IDES (wp 0)
M * ERROR ThInit: db_connect
M *
M * TIME Wed Apr 27 12:39:07 2016
M * RELEASE 742
M * COMPONENT Taskhandler
M Wed Apr 27 12:39:07 2016
M * VERSION 1
M * RC 16797709
M * MODULE D:/depot/bas/742_REL/src/krn/si/th/thxxhead.c
M * LINE 2578
M * COUNTER 1
M *
M *****************************************************************************

Solution

Refer to SAP Note 1294762 – SCHEMA4SAP.VBS, execute the attached script Schema4SAP.zip. Additionally, you may refer to SAP Notes below,

592514 – MSSQL: internal database users, permissions and security
128126 – Database connect for external tools

You May Also Like

Leave a Reply?