I have a new SQL 2005 reporting services installation and it doesn't work.
我有一个新的SQL 2005报告服务安装,它不起作用。
Database access works fine.
数据库访问工作正常。
I've setup a new IIS site, set it to run on port 90. It has the two virtual folders - Reports and ReportServer. I can access ReportServer just fine, but Reports (the report manager) throws HTTP 400 error.
我已经设置了一个新的IIS站点,将其设置为在端口90上运行。它有两个虚拟文件夹 - Reports和ReportServer。我可以正常访问ReportServer,但Reports(报表管理器)会抛出HTTP 400错误。
I've changed the URL in rsreportserver.config and RSWebApplication.config but it still throws that error.
我已经更改了rsreportserver.config和RSWebApplication.config中的URL,但它仍然会抛出该错误。
5 个解决方案
#1
Download a copy of Fiddler. Check to make sure that your browser requests are what you think they are. Watch each request, especially the one that generates the HTTP/400. Does that request look good to you? This will give you a base from which to troubleshoot.
下载Fiddler的副本。检查以确保您的浏览器请求符合您的要求。观察每个请求,尤其是生成HTTP / 400的请求。这个要求对你好吗?这将为您提供进行故障排除的基础。
#2
I fixed it on another server - the solution is simply to delete the IIS site which holds Report server and report manager, then create a new IIS site, configure IP and port mapping and recreate the virtual directories.
我将其修复在另一台服务器上 - 解决方案只是删除保存报表服务器和报表管理器的IIS站点,然后创建新的IIS站点,配置IP和端口映射并重新创建虚拟目录。
#3
Does the reporting services configuration tool report anything awry? What is it logging in the event log on the server?
报告服务配置工具是否报告任何错误?什么是在服务器上记录事件日志?
#4
Config tool says everything is fine.
配置工具说一切都很好。
Nothing is logged in the event log from reporting services.
报告服务的事件日志中没有记录任何内容。
In the reporting services trace log I can find only initialization items (setting default values for variables).
在报告服务跟踪日志中,我只能找到初始化项(设置变量的默认值)。
When I look into the IIS log, I can see that an anonymous request comes in from my IP addess to /Reports, it's rejected, then it comes back with Windows authentication and that's it. /Reports does not fire a request to /ReportServer, it does not redirect me to /Reports/Folder - I think that's what it should do, right?
当我查看IIS日志时,我可以看到匿名请求从我的IP地址进入/ Reports,它被拒绝,然后它返回Windows身份验证,就是这样。 / Reports不会向/ ReportServer发出请求,它不会将我重定向到/ Reports / Folder - 我认为这应该是什么,对吧?
#5
Finally I manager to solve it.
最后我经理解决它。
What I did is I deleted the IIS website, started with plain vanilla web site (listening to all IP addresses) and reporting services running on local admin and sa in the database.
我做的是删除了IIS网站,从普通的vanilla网站(收听所有IP地址)开始,并在本地管理员和sa数据库中运行报告服务。
Then, confirmed that it's working, I went step-by-step and:
然后,确认它正在工作,我一步一步地走了:
- changed IP address
- changed port
- lowered local user rights
- lowered database rights
更改了IP地址
降低了本地用户权限
降低数据库权限
and after every step, everything was still working fine.
并且在每一步之后,一切都仍然正常。
I don't know what was the issue exactly, but this helped.
我不知道到底是什么问题,但这有帮助。
I have another server that shows the same problems, I will start there by just deleting and recreating the website (I think that solved the problem) and will let you know.
我有另一台服务器显示相同的问题,我将从那里开始只是删除并重新创建网站(我认为这解决了问题),并会让你知道。
#1
Download a copy of Fiddler. Check to make sure that your browser requests are what you think they are. Watch each request, especially the one that generates the HTTP/400. Does that request look good to you? This will give you a base from which to troubleshoot.
下载Fiddler的副本。检查以确保您的浏览器请求符合您的要求。观察每个请求,尤其是生成HTTP / 400的请求。这个要求对你好吗?这将为您提供进行故障排除的基础。
#2
I fixed it on another server - the solution is simply to delete the IIS site which holds Report server and report manager, then create a new IIS site, configure IP and port mapping and recreate the virtual directories.
我将其修复在另一台服务器上 - 解决方案只是删除保存报表服务器和报表管理器的IIS站点,然后创建新的IIS站点,配置IP和端口映射并重新创建虚拟目录。
#3
Does the reporting services configuration tool report anything awry? What is it logging in the event log on the server?
报告服务配置工具是否报告任何错误?什么是在服务器上记录事件日志?
#4
Config tool says everything is fine.
配置工具说一切都很好。
Nothing is logged in the event log from reporting services.
报告服务的事件日志中没有记录任何内容。
In the reporting services trace log I can find only initialization items (setting default values for variables).
在报告服务跟踪日志中,我只能找到初始化项(设置变量的默认值)。
When I look into the IIS log, I can see that an anonymous request comes in from my IP addess to /Reports, it's rejected, then it comes back with Windows authentication and that's it. /Reports does not fire a request to /ReportServer, it does not redirect me to /Reports/Folder - I think that's what it should do, right?
当我查看IIS日志时,我可以看到匿名请求从我的IP地址进入/ Reports,它被拒绝,然后它返回Windows身份验证,就是这样。 / Reports不会向/ ReportServer发出请求,它不会将我重定向到/ Reports / Folder - 我认为这应该是什么,对吧?
#5
Finally I manager to solve it.
最后我经理解决它。
What I did is I deleted the IIS website, started with plain vanilla web site (listening to all IP addresses) and reporting services running on local admin and sa in the database.
我做的是删除了IIS网站,从普通的vanilla网站(收听所有IP地址)开始,并在本地管理员和sa数据库中运行报告服务。
Then, confirmed that it's working, I went step-by-step and:
然后,确认它正在工作,我一步一步地走了:
- changed IP address
- changed port
- lowered local user rights
- lowered database rights
更改了IP地址
降低了本地用户权限
降低数据库权限
and after every step, everything was still working fine.
并且在每一步之后,一切都仍然正常。
I don't know what was the issue exactly, but this helped.
我不知道到底是什么问题,但这有帮助。
I have another server that shows the same problems, I will start there by just deleting and recreating the website (I think that solved the problem) and will let you know.
我有另一台服务器显示相同的问题,我将从那里开始只是删除并重新创建网站(我认为这解决了问题),并会让你知道。