Invalid object name 'SVERS'

[Former Member]

Hello,

When trying to perform an Upgrade of a BW3.0B to BW3.5, Prepare Phase, an error occurs in script MSSCONCHECK.SQL.

- Msg 208, Level 16, State 1, Server SRVDW, Line 1

Invalid object name 'SVERS'.

Can anyone help?

Thank you.

Regards,

PT

[Former Member · Accepted solution]

Hi,

If you are re-installing the system with the the same SID, delete the login from Enterpise manager and create it.

Change the SQL Server Authenitcation as Windows and SQL SErver

regards

Anand.M

[Former Member · Accepted solution]

Hello,

Thanks for your answer.

I'm not re-installing BW, i'm performing an upgrade, I have the two users (sidadm and SAPServiceSID) created with windows authentication.

Regards,

Paulo T.

[Former Member · Accepted solution]

Hi,

Change the SQL Server Authentication as

SQL Server and Windows using SQL Server Enterprise Manager and retry.

regards

Anand.M

[Former Member]

Hello

Please check if the following link helps you:

http://sqlserver2000.databases.aspfaq.com/why-do-i-get-object-could-not-be-found-or-invalid-object-n...

Regards

Chen

[Former Member]

I have similar eror message during upgrade from ECC 5.0 to ECC 6.0 on MS SQL 2005. The output from my sapup is as shown below:

>> 07:39:34 PREPARE: START OF PHASE INITPUT_PRE

Supply the following information:

Confirm the name of your SAP system: [AWD]

SAP SYSTEM ID =

The hostname of your central SAP server: [SERVER01]

SAP SYSTEM HOST =

Enter the SAP instance number: [02]

INSTANCE NUMBER =

The system identifier of your database: [AWD]

DATABASE ID =

The hostname of your database server: [SERVER01]

DATABASE HOST =

Executing script MSSCONCHECK ...

MSSCONCHECK: Connection check failed for the user specified

SAPup message

SAPup> Errors were found in the logfile MSSCONCHECK.LOG

after execution of the script MSSCONCHECK.SQL.

SAPup> SAPup cannot proceed until these errors are fixed.

Please, examine MSSCONCHECK.LOG, fix reported errors and then call R3

gain

- "continue"

- "cancel"

Enter one of these options [continue] :=

SAPup message

SAPup> SQL-scripts must be executed by the NT user account SERVER01\awdadm.

Check your installation of the integrated security procedure

on host SERVER01 and make sure that a login for the NT user

SERVER01\awdadm exists with the following rules:

- user SERVER01\awdadm owns the role System Administrators

- user SERVER01\awdadm has the default database AWD

SAPup> Integrated security installed correctly?

- "no"

- "yes"

Enter one of these options [no] := yes

Executing script MSSCONCHECK ...

I'm currently running both Solution Manager 4.0 and mySAP ERP 2004 SR1 on the same box in Development environment.

Has anyone gotten a breakthrough on this error messages? Mode set to both SQL and Windows Authentication, can do selct * from SVERS for solution manager database but not for ECC 5.0.

Urgent!!!!

[Former Member]

i am getting this issue.

Pls let me know how was this solved

[yjhuang2]

Hi,

Check the NT Account <system-sid>adm in SQL server login, the default database must be "<System-sid>", not the "Master",