When trying to set up the reporting services for Spotlight on SQL Server Enterprise you may get the following error message:
An error has occurred during report processing. (rsProcessingAborted)
Cannot create a connection to data source 'SpotlightStatisticsRepository'. (rsErrorOpeningConnection)
Keyword not supported: '<servername>;integrated security'.
Incorrect syntax for data source name was used.
Please make sure your connection string for your DSN looks like the following:
Data Source="SQLServerName";Initial Catalog=SpotlightStatisticsRepository
For example:
Data Source=sql2k501;Initial Catalog=SpotlightStatisticsRepository
Run the following query to make sure the correct SQL Server name is used:
select @@servername
