-
Title
Error opening Spotlight on Messaging Web Reports "Unable to open database" -
Description
When attempting to open Spotlight on Messaging Web Reports user is faced with the following error:
Error
Unable to open database connection. (0x80004005: Invalid connection string attribute), File Name=C:Program Files (x86)\Quest Software\Spotlight on Messaging\Web Reports\WebReports.UDL
(0x80004005) -
Cause
SQL Authentication issues when SQL database and IIS are on separate machines.
-
Resolution
Navigate to (where C is the installed drive) C:\Program Files\Quest Software\Spotlight on Messaging\Web Reports
Find the file WebReports.UDL
Open the file, click on the connection tab, if using Windows NT Integrated (only to be used if SQL is local) switch the account to a SQL account that has access to read from the database. The SQL account used to open SOM reports should have the following roles:
db_datareader
db_datawriter
You can grant these roles using SQL client tools.