How to delete drive letter in DS Admin that doesn't exist internally.

Issue

There are drive letter's in DS admin that don't exist internally or externally. 

Product Line

Pelco Video Management

Environment

  • DS
  • DSSRV
  • DSSRV2

Cause

A USB Drive was connected then remove from a digital sentry system.  

Resolution

Delete the drive letter.

  1. Click on START > Programs > Microsoft SQL Server 2008 R2 (or 2005 for older DS versions) > SQL Server Management Studio.
  2. If prompted to carry over settings from SQL 2005, select No both times. The Connect to Server box will open, click Connect.
    (Verify that the DigitalSentry database is accessible [if not login using the "sa" account])
  3. In the SQL Management Studio go to: Databases > DigitalSENTRY > Tables > dbo.StorageLocations.
  4. Right Click dbo.StorageLocations and select "Edit Top 200 Rows"
  5. Right Click on row and select  "Delete" .
  6. Close SQL Server Management Studio. 
  7. Verify in DS admin the drive letter is gone in the storage location tab.

 

If prompted to carry over settings from SQL 2005, select No both times.
The Connect to Server box will open, click Connect. (Verify that the DigitalSentry database is accessible [if not login using the "sa" account])

 

If promptto carry over settings from SQL 2005, select No both times.
The Connect to Server box will open, click Connect. (Verify that the DigitalSentry database is accessible [if not login using the "sa" account])If prompted to carry over settings from SQL 2005, select No both times.
The Connect to Server box will open, click Connect. (Verify that the DigitalSentry database is accessible [if not login using the "sa" account])If prompted to carry over settings from SQL 2005, select No both times.
The Connect to Server box will open, click Connect. (Verify that the DigitalSentry database is accessible [if not login using the "sa" account])