Error: "Unspecified error message for master, msdb and other user databases" while querying the 'Database Users' datasource in bv-Control for Microsoft SQL Server

Article:TECH192761  |  Created: 2012-07-11  |  Updated: 2012-08-21  |  Article URL http://www.symantec.com/docs/TECH192761
Article Type
Technical Solution


Issue



Error: "Unspecified error message for master, msdb and other user databases" while querying the 'Database Users' datasource in bv-Control for Microsoft SQL Server.


Solution



One of the reasons for this error message to pop-up while querying the ‘database users’ datasource is that the RMS user account created in the target SQL Server lacks the proper privileges to query the server.

  • Grant the ‘db_datareader’  role to the RMS user account on the  master database and other user databases which needs to be queried from the RMS console .
  • For more information on the privileges required to successfully query the server, please refer to the bv-control for MS SQL Server getting started guide ( 10.5 / 10.5.1)



Article URL http://www.symantec.com/docs/TECH192761


Terms of use for this information are found in Legal Notices