Error When Deleting a Server

For older versions of VitalSigns, there is a problem with deleting servers from the server list. These steps will guide you through deleting the server directly from the database.

Step 1

Open Microsoft SQL Server Management Studio from the VitalSigns workstation.
Log in using Windows Authentication and using the local SQL Express instance.

If you use your own SQL server, please contact your SQL Server administrator.

Step 2

Select New Query in the top right corner.

Step 3

Choose the "vitalsigns" database from the Available Databases drop down menu.
Copy and paste the query below to list all the servers:
```
SELECT ID,ServerName FROM Servers
```
Select Execute to run the script.

Step 4

Find the name of the server you want to delete and note the corresponding ID number.
Select New Query in the top right corner.
Choose the "vitalsigns" database from the Available Databases drop down menu.
Copy and paste the query below to list all the servers replacing %ENTERSERVERID% with the ID number you noted from the previous table:
```
DELETE FROM DominoServerDetails WHERE ServerID = %ENTERSERVERID%
```
Select Execute to run the script.

You should now be able to remove the server from the VitalSigns UI.