Spotlight was unable to connect to database SpotlightStatisticsRepository
SpotlightStatisticsRepository repository is created on SQL Server 2000
If the SpotlightStatisticsRepository repository is created on SQL Server 2000, try creating the database on SQL 2005 or SQL 2008 instead - Installing the Spotlight Statistics Repository on SQL Server 2000 is not recommended.
1 Click on the Configure tab in Spotlight 7.6
2 Click the Diagnostic Server option
3 Click on Configure the Spotlight Statistics Repository
4 On the Spotlight Options screen, change the instance referenced in the Instance field and provide the authentication type and database name, then click the create button to create and begin using the new SSR on the 2005 instance.
