Browse FAQs

Power Monitoring Expert - Insufficient SQL Server Role to open Database Manager

Published date: 29 July 2019

Issue:
The following error is displayed when trying to open the Database Manager

          
cannot open the Database Manager. To open the Database Manager a user must be a member of the SQL sysadmin server role.

Product Line:
Power Monitoring Expert 8.1 (and higher) / 9.0

Environment:
Database Manager
SQL Server Management Studio (SSMS)

Cause:
Power Monitoring Expert 8.1 removed the 'sysadmin' role from the 'ION' SQL account. 

Resolution:
In order to use the Database Manager in Power Monitoring Expert 8.1 and newer, the user must log into Windows using an account that has been granted 'sysadmin' role in SQL Server Management Studio. 

*Warning: Irreparable Database Damage can occur.  This procedure should only be performed by users familiar with SQL Server Management Studio.  Databases should be backed up prior to performing this procedure.*
Note: In some cases, a domain account may appear to have the 'sysadmin' role checked in SQL but are still unable to log in due to domain policy restrictions. To check and see if the user account does indeed have 'sysadmin' rights, the following query can be run in SQL Server Management Studio. 

SELECT IS_SRVROLEMEMBER ('sysadmin',''

          

If the value returned is a zero '0' the user does not have syadmin rights.

Note: More information on how to determine if a SQL Server login is a member of a specified server role can be found in FA346467.

Was this helpful?

What can we do to improve the information ?

Can't find what you are looking for?

Reach out to our customer care team to receive information on technical support, assistance for complaints and more.