cancel
Showing results for 
Search instead for 
Did you mean: 

DB permission missing.

Former Member
0 Kudos

HI,

Due to my server crash, I restored my backup for sql server 2005.

Now ABAP is running.

Java SDM, Dispatcher, Server node are not showing in Java Table of SAP MMC.

I restore only the DEV ( SAPSID ) DB only. I didn't restore the master database. My master backup corrupted. So some of the permission are missing . Due to that java server not showing and not starting.

the user SAP<sid>DB user missing the login name. I created the login name . but it is not sync with DB user. Due to that authorization fails and java not starting.

The configtool also not connecting with DB.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Please download SAP Tools for MS SQL Server from service.sap.com/patches

-> database patches -> MS SQL Server -> JDBC Drivers and Tools.

Note 683447 - SAP Tools for MS SQL Server

Regards,

Nikunj Thaker

Edited by: Nikunj Thaker on Jun 11, 2009 10:57 AM

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi Milan,

check out the script in Note 1294762 - SCHEMA4SAP.VBS. It also recreates the ABAP and JAVA logins - including the necessary authorizations.

Sven