SQL2005 reporting server: intense security activity

Posted by David Wimbush on Server Fault See other posts from Server Fault or by David Wimbush
Published on 2009-09-24T09:08:30Z Indexed on 2010/03/22 17:01 UTC
Read the original article Hit count: 249

Filed under:

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?

© Server Fault or respective owner

Related posts about sql-server-2005