Error on sysdb database created during SSMA migration

Question

Hi,

I have recently migrated Oracle 10G database to SQL Server 2008 R2, Dtaa migration work has completed successfully but while testing the application we getting error related to sysdb. I think this is something related to security on sysdb database. I am not sure if any privilages need to be given to the application users, as I can only grant permissions to database users in SQL but not in application.

Please find the error message below:

Caused By: java.sql.SQLException: [OWLS][SQLServer JDBC Driver][SQLServer]The server principal "cont_mfg" is not able to access the database "sysdb" under the current security context.

Please let me know if any suggestions on this.

Answer 1

Hello,

Please open SQL Server Management Studio.   In Object Explorer -> Server -> Security -> Logins, right click on “cont_mfg” and choose Properties. On the “User Mapping” page put a check mark on the “sysdb” database, and then add some roles like “db_datareader”, “public”, “db_datawriter”.

Hope this helps.

Regards,
Alberto Morillo
SQLCoffee.com

Answer 2

hi kindly check given link for your reference, it may help you out.

http://www.experts-exchange.com/Database/Oracle/Q_26395310.html

Answer 3

Thank you Alberto.

It worked. I did as you suggested and error gone. But unfortunately another error came. I'll post that as a separate thread.