Event Viewer is a great source of logs to show that something is wrong with your setup. Here is one esoteric error and how they were resolved:
Credentials are stored in multiple places and multiple tools. If an error appears in the Event Viewer every 10 seconds from SOLIDWORKS PDM Database Server with a message like Connect to server <ServerName>' Failed: (null) Unknown error 0x80040200 (null) or Login failed for user '<username>'. Reason: Could not find a login matching the name provided. [CLIENT: <local machine>], this means that the Database Archive Server connection is using the wrong account or the wrong password.
Launch the "Database Server Configuration" utility from the Start menu and correct the login to your SQL Admin user. The errors should stop.
