Application Error Event ID 0 Integral Sql Agent Service

Issue

Microsoft Event Viewer - Application:
 

Integral Sql Agent Service | None | ID 0 | Description: Exception thrown attempting to run sql command, error: Cannot open database "DigitalSentry" request by the login. The login failed. Login failed for user 'hostname\DSNVSUser'.

MSSQL$DS_MSSQLSERVER | Logon | ID 18456 | Description: Login failed for user "hostname\DSNVSUser'. Reason: Failed to open the explicitly specified database. [CLIENT: ::1]

Product Line

Pelco Video Management

Environment

  • DSSRV2
  • DSSRV
  • DS

Cause

DSNVSUser is not a valid account in the SQL database.

Resolution

Add/verify DSNVSUser and DSServiceUser are located in Microsoft SQL Server Management Studio.

  1. Go to Start > All Programs > Microsoft SQL Server 2008 R2
  2. Select SQL Server Management Studio


     
  3. Login to Microsoft SQL Server using sa by changing the Authentication type to SQL Server Authentication
  4. Login = sa / password = LETmein333 (default)
  5. Expand Security > Logins
  6. Verify there are no accounts listed as hostname\DSNVSUser and hostname\DSSerivceUser
  7. If you have the above user with the old hostname (computer name) delete these accounts.
  8. Add user accounts
    1. Right click on Logins > Select New Login
    2. In the Login name: click Search > Advanced > Find Now
    3. Locate and Select the DSNVSUser and click OK twice
    4. Select Server Roles and check sysadmin, leave public checked
    5. Select OK
    6. Right click on Logins > Select New Login
    7. In the Login name: click Search > Advanced > Find Now
    8. Locate and Select the DSServiceUser and click OK twice
    9. Select Server Roles and check sysadmin, leave public checked
    10. Select User Mapping, check DigitalSENTRY and FLLog
    11. Under Default Schema click on the three periods and type dbo, hit OK (do this for both DigitalSENTRY and FLLog)
    12. Select OK


       
  9. Restart the DigitalSENTRY Video Server Service