Using Spotlight 8.0, error connection to SQL Server instance: “Cannot connect to SQL Server instance ‘instancename’: Format of the initialization string does not conform to specification starting at index 142.”
SQL Server instance is 2008 SP2.
Create another user account with admin rights for instance using a simpler password e.g. avoid using quote-marks or foreign locale characters.
Issue fixed in the current release of Spotlight on SQL Server Enterprise. To upgrade to the latest version without loss of existing connections and configurations, upgrade to Spotlight version 10.0 first. Contact <a href="https://support.quest.com/contact-support">support team</a> to obtain installers of previous versions of Spotlight.