Trying to execute OpManager on MSSQL 2005 with non-sysadmin

Trying to execute OpManager on MSSQL 2005 with non-sysadmin

Hello,

I installed OpManager 7.0 Professional with MSSQL 2005 database backend, by means of "sa" user. Later, I checked the installation was fine, and then I tried to change database user, in file "database_params.conf". I created in SQL 2005 a new SQL login, called "opmanager", and made it db_owner of OpManagerDB database.

Then, I restart the application and doesn't work well. Wrapper.log shows the line "Process : DBServer [ FAILED ]" and stderrXX.log shows the line "17:22:54:491 PM ##### PROBLEM IN INITIALIZING MODULE class com.adventnet.nms.eventdb.EventMgr #####" continuously repeating.

When I give sysadmin server role to "opmanager" login, all is fine. By security reasons, I don't want "opmanager" login to be sysadmin.

I'm a newbie with SQL 2005, although not with SQL 2005. I tried to give explicit permissions to "opmanager" user in OpManagerDB database, but nothing is working. :-(

Anybody can help me, please?

Thanks in advance.











                  New to ADSelfService Plus?