Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
savior faire
Posting Yak Master
194 Posts |
 Posted - 2009-04-07 : 21:46:06
|
| I am completely stoked. I found the answer to my problem and I hope this helps others!!!http://myprivateblg.blogspot.com/2008/04/sql-server-2005-reporting-services-and.htmlOn Friday I was setting up my new company's laptop (Dell Latitude D630, review/opinion comes later), shipped with Vista Business. First I set up SQL Server 2005 (all components - AS, IS and RS), and afterward I downloaded and installed all available updates. Suddenly, I could not work with Reporting Services anymore. When trying to connect to the Report Manager in IE and to the instance of Reporting Services in Management Studio, I was getting a message that remote host refused connection. Very unpleasant, taking into account that Reporting Services is my main tool.I asked our well-known friend - Mr. Google - about possible solutions of the issue. Searching through the proposals, I found the right one. Since the combination - SQL Server 2005 + MS Vista Business - is not rare (and is expected to show up more and more often in the business world), I decided to post that solution here, with a hope, that this will help others. The original of the article (in German) can be found here:http://www.ct-systeme.com/ct/tipps/Seiten/VistaSP1SQL2005RS.aspx"It can happen that SQL Server 2005 Reporting Services installed on the Vista-equipped PC will not work after installing MS Vista Service Pack 1. The installation of the Service Pack 1 ran smoothly and error-free, but reports from SSRS are not available anymore.The symptoms can be:(1) requests to http://localhost/reports end with error message about failed connection attempt;(2) requests to http://localhost/reportserver end with an "HTTP 403.1" error message ("Forbidden");(3) you may find error messages about failed connection attempt to 127.0.0.1:443 in the log files of the Reporting Services, although you don't use HTTPS/SSL;The solution is easy if you know the reason: the installation of the Service Pack 1 revoked the "Execute script" right of the virtual folder ReportServer. To resolve the issue, do the following:(1) Start IIS Manager(2) Navigate to the virtual folder ReportServer (Computer Name->site where SSRS was installed)(3) Double-click symbol "Handler mappings" in the central part(4) Select link "Edit feature permissions" in the right part of the screen - "Task area"(5) Make sure that Read and Script are enabled (Execute is not required). Installation of the Service Pack 1 has disabled Script option)(6) Click OK(7) Close IIS ManagerReporting Services must work immediately afterwards. Restart is not required."So, I hope this solution will save your time and energy. I will appreciate any feedback.Talk sense to a fool and he calls you foolish. |
|
|
savior faire
Posting Yak Master
194 Posts |
Posted - 2009-04-11 : 07:41:53
|
| Bump for othe poster.Talk sense to a fool and he calls you foolish. |
 |
|
|
|
|
|
|
|
Solution to SSRS and Vista