SQL2005 reporting server: intense security activity
- by David Wimbush
On my reporting server the Security log shows large numbers of Logon/Logoff events, often 10 or more, when you run pretty much any report in the Report Manager. Is this normal or is it a classic sign of having the wrong setup?
Some system details:
Windows Server 2003 R2 SP2, virtual server running under VMWare).
SQL Server 2005 SP3 Standard Edition, running databases, Report Manager, and Ananlysis Services cubes.
No other major services on the machine (i.e. it's not a domain controller, Exchange server or anything like that).
Any ideas, please, guys?