修改前请将以下三个文件备份:
\ReportServer\web.config
\ReportServers\rsreportserver.config
\ReportManager\Web.config
1. 打开文件C:\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\ReportingServices\ReportServer下的web.config,修改文件里的
<authentication mode="Windows" />
<identity impersonate="true"/>
改为:
<authentication mode="None" />
<identity impersonate="false" />
2. 打开C:\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\ReportingServices\ReportServer下的rsreportserver.config,修改
<Authentication>
<AuthenticationTypes>
<RSWindowsNegotiate/>
<RSWindowsNTLM/>
</AuthenticationTypes>
<EnableAuthPersistence>true</EnableAuthPersistence>
</Authentication>
改为:
<Authentication>
<AuthenticationTypes>
<Custom/>(只修改这一行)
</AuthenticationTypes>
<EnableAuthPersistence>true</EnableAuthPersistence>
</Authentication>
3. 还在第二步的文件中(rsreportserver.config)找到
<Security>
<Extension Name="Windows" Type="Microsoft.ReportingServices.Authorization.WindowsAuthorization,Microsoft.ReportingServices.Authorization"/>
</Security>
<Authentication>
<Extension Name="Windows"Type="Microsoft.ReportingServices.Authentication.WindowsAuthentication,Microsoft.ReportingServices.Authorization"/>
</Authentication>
在该代码下添加:
<Security>
<Extension Name="None"Type="Microsoft.Samples.ReportingServices.AnonymousSecurity.Authorization,Microsoft.Samples.ReportingServices.AnonymousSecurity"/>
</Security>
<Authentication>
<Extension Name="None"Type="Microsoft.Samples.ReportingServices.AnonymousSecurity.AuthenticationExtension,Microsoft.Samples.ReportingServices.AnonymousSecurity"/>
</Authentication>
4. 在C:\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\ReportingServices\ReportServer\bin
目录下添加:Microsoft.Samples.ReportingServices.AnonymousSecurity.dll文件
5. 修改完重新上传报表避免数据源错误问题
以下是reporting services配置: