Running reports prompts for connection login credentials every time.
Running reports prompts for connection login credentials every time. How can Spotlight save these credentials so user is not prompted every time a report is opened?
Windows Authentication used for Spotlight Statistics Repository database.
Report Viewer is an outside application opened by Spotlight to generate reports. This application uses local user account when Spotlight Statistics Repository is configured with Windows Authentication. In order to bypass the prompt, configure this database using SQL Server Authentication method. Use Configure | Diagnostic Server | Spotlight Statistics Repository option to do so.