If VMS gives a big red database error in the viewer. Two things to check.
- Make sure the VMS instance of SQL Server is running: "SQL Server (VMS)".
- Open SQL Server Configuration Manager.
- Click on "Protocols for VMS".
- Right-click TCP/IP.
- Click properties.
- Move to IP Adresses tab.
- Scroll down to bottom, under IPAll check, to make sure the TCP Port is 53224 and the TCP Dynamic Ports is blank.