vendredi 12 décembre 2008

Change session timeout on Sql Server Reporting service

Here is a little script changing the session timeout for your SQL reporting server :

Public Sub Main()
Dim props() as [Property]
props = new [Property] () { new [Property](), new [Property]() }
props(0).Name = "SessionTimeout"
props(0).Value = timeout
props(1).Name = "SessionAccessTimeout"
props(1).Value = timeout
rs.SetSystemProperties(props)
End Sub


Copy this script in a textfile named sessionTimeout.rss and run it with rs.exe

rs -i sessionTimeout.rss -s http://localhost/reportserver -v timeout="18000"

the timeout is expressed in seconds

Original Post : http://blogs.msdn.com/jgalla/archive/2006/10/11/session-timeout-during-execution.aspx

Aucun commentaire: