Welcome to the world (new face) of Knowledge Sharing Network.
To track the older blog posts refer to our historical knowledge sharing site  and you will find this as your destination for SQL Server knowledge pool.

Follow SQLMaster on Twitter SqlServer-QA.net - Knowledge Sharing Network (@sqlmaster)

SQL Server Reporting Services - avoid restarting IIS when security groups are added - SQL Server Knowledge Sharing Network (@sqlmaster)

SQL Server Reporting Services - avoid restarting IIS when security groups are added

You may be aware that using normal method of http://servername/reports will give access to the users and if you grant reporting service permissions using the folder properties security (or report manager) to the Windows groups you might need to restart the IIS in order to take the new groups affect.

 In this case it may not be possible to restart IIS services on a production server unless the user activity is low or arranged downtime is agreed, so how to resolve this issue. The default IIS configuration has delay of 15 minutes before users tokens are updated. For example, if you change the password on a user account, you will be able to connect to the server with both the old password and the new password.  So either you have to wait for 15 minutes or change this interval by referring following method that was referred in one of the MS Knowledge base article (I don't remember the number)

1. Run Registry Editor (Regedt32.exe or Regedit.exe).
2. From the HKEY_LOCAL_MACHINE subtree, go to the following key:
\System\CurrentControlSet\Services\InetInfo\Parameters
3. Click Add Value on the Edit menu, and add the following:
Value Name: UserTokenTTL
Data Type: REG_DWORD
Data: (Number of Seconds for token to be cached - 30 sec. Min)

 

Published Monday, April 14, 2008 10:07 AM by ssqa.net

Comments

No Comments