Article ID: 946089
Article Last Modified on 12/27/2007
APPLIES TO
- Microsoft SQL Server 2005 Reporting Services, when used with:
- Windows Server 2008 Standard
- Windows Server 2008 Standard 32-Bit
- Windows Server 2008 Enterprise 32-Bit
SYMPTOMS
Consider the following scenario. On a server that is running Windows Server 2003, you have a subscription that uses the file share delivery extension in Microsoft SQL Server 2005 Reporting Services or in Microsoft SQL Server 2008 Reporting Services. Then, you upgrade from Windows Server 2003 to Windows Server 2008. In this scenario, the file share delivery extension does not work if it tries to overwrite a file that existed before the upgrade. Additionally, when you view the status of the subscription, the following error message is generated in the Report Manager tool:
This behavior occurs when the following conditions are true:
- The target folder for the subscription is a folder on the local file system.
- The overwrite option for the subscription is set to overwrite an existing file.
- The owner of the subscription is a member of the local Administrators group.
This behavior does not occur when one of the following conditions is true:
- The report server writes new files to the target folder after the upgrade.
- The overwrite option for the subscription is not set to overwrite an existing file.
- The target folder is located on a remote share.
- The owner of the subscription is a standard user who is not a member of the local Administrators group.
CAUSE
The behavior occurs because of the User Account Control (UAC) feature in Windows Server 2008.
RESOLUTION
To resolve this behavior, explicitly grant the Full Control permission to the owner of the subscription on the existing file that will be overwritten by the report server.
STATUS
This behavior is by design.
MORE INFORMATION
If a user who logs on to Windows Server 2003 is a member of the Administrators group, every process that the user starts has the full administrator access token. When the user creates a file, the ownership of the file is assigned to the Administrators group. After you upgrade from Windows Server 2003 to Windows Server 2008, the ownership for this file is retained.
By default, every process in Windows Server 2008 runs under the standard user token because of UAC access token filtering. Therefore, the file share delivery extension in Windows Server 2008 cannot overwrite a report that existed before the upgrade. This is because the file is owned by the Administrators group. This behavior occurs only when the target folder for the subscription is a local folder. If the target folder is located on a remote share, UAC access token filtering does not occur, and you do not experience the problem that is described in the "Symptoms" section.
Steps to reproduce this behavior
- On a server that is running Windows Server 2003, create a subscription for a report in SQL Server 2005 Reporting Services.
- Under Report Delivery Options, click Windows File Share in the Delivered by list.
- In the Path box, enter a local shared folder.
- In the User Name box, enter a user who is a member of the Administrators group.
- In the Password box, enter the password of the user.
- Click Overwrite an existing file with a newer version, and then click OK to create the subscription.
- After the report is created in the local shared folder, upgrade from Windows Server 2003 to Windows Server 2008.
REFERENCES
For more information about the UAC feature, visit the following Microsoft Web sites:
- http://msdn2.microsoft.com/en-us/library/Aa826699.aspx#handling_remote_connections_under_uac
- http://www.microsoft.com/technet/technetmag/issues/2007/06/UAC/default.aspx
- http://msdn2.microsoft.com/en-us/library/bb756993.aspx
Keywords: kbsql2005rs kbexpertiseadvanced kbtshoot kbprb KB946089
