Resolution
fact
NetIQ Vulnerability Manager 5.0
fact
NetIQ Vulnerability Manager 5.5
fact
NetIQ Vulnerability Manager Agent for Windows 5.0
fact
NetIQ Vulnerability Manager Agent for Windows 5.5
symptom
Error: 'User 'vigilentservice' does not have permission to run DBCC CHECKIDENT for object 'HistoricalTasks'.'
cause
This error most likely occurs when a user is trying to lock down account permissions and removes needed permissions from certain accounts.
fix
NetIQ Vulnerability Manager 5.0
fact
NetIQ Vulnerability Manager 5.5
fact
NetIQ Vulnerability Manager Agent for Windows 5.0
fact
NetIQ Vulnerability Manager Agent for Windows 5.5
symptom
Error: 'User 'vigilentservice' does not have permission to run DBCC CHECKIDENT for object 'HistoricalTasks'.'
cause
This error most likely occurs when a user is trying to lock down account permissions and removes needed permissions from certain accounts.
fix
To correct this problem, complete the following steps:
- On the Vulnerability Manager database computer, open SQL Server Enterprise Manager.
- In the tree pane, expand Microsoft SQL Servers > SQL Server Group > (local) > Databases > VigilEnt.
- Expand the VigilEnt database and click Users.
- Select the VigilEntService user.
- On the Action menu, click Properties.
- Ensure the following database roles are selected: public, db_securityadmin, db_ddladmin, VigilEntUserAccess.
- Click OK.
- Close SQL Server Enterprise Manager.
Additional Information
Formerly known as NETIQKB47118