Common Asset Viewer "Error: An invalid URL was specified; The SELECT permission was denied on the object 'tng_managedobject', database 'mdb', schema 'dbo'"

Document ID : KB000025384
Last Modified Date : 14/02/2018
 Show Technical Document Details

Symptoms:

At times on launching Common Asset Viewer in CA Service Desk Manager, this error message appears:

"Error: An invalid URL was specified; The SELECT permission was denied on the object 'tng_managedobject', database 'mdb', schema 'dbo' "

 

Resolution:

The error occurs because of incorrect permissions on the MDB database. 

  1. Login to SQL Server Management Studio as ServiceDesk or SA
  2. In the Object Explorer, expand Databases
  3. Right click MDB->Properties.
  4. Click on Permissions.
  5. By default only the ServiceDesk user is listed.


    Figure 1

  6. Expand MDB database, click on Security->Roles->Database Roles
  7. Double click on amsgroup and verify if ServiceDesk is listed as a Role Member. If not, click on Add to find ServiceDesk user and add it to the role members. 


    Figure 2

Note: Either the ServiceDesk user can be a Role Member to the amsgroup or amsgroup can be granted permissions on MDB directly.

 

Additional Information:

tng_managedobject - Details on the main table to store all the managed objects. e.g. device, agent, unispace etc.