First off, forgive the ignorance that I'm sure to display in this post. I'm a total newbie with SRSS and have been using it to follow along with the tutorials offered via the SQL Express website. I'm using it strictly for learning on my local machine for the time being.
All had been working well with Reporting Services until I upgraded Vista Ultimate 64-bit (which was running in free 30-day trial unactivated Evaluation mode) sideways to Vista Ultimate Upgrade Edition 64-bit Edition. (Sounds confusing, I know.) I also subsequently installed a SQL Server 2k5 critical update which was recommended by Windows Update.
Now when I attempt to access Report Manager via localhost the "Home page" is incomplete, showing only the SSRS "Home" page header. There are no properites, data sources, config options, etc. outside of links for "Home|Help". I am running IE as an Admin and all the Reporting Services Configuration settings are green.
Also, when I attempt to deploy from VS 2005 I now receive the error: "Permissions granted to user 'NT Authority\Network Service' are insufficient ..."
Some of the settings inside the Report Sever Config are as follows:
Windows Service Identity:
Service Acct: NT Authority\Network Service; Built-in Account: Network Service
Web Service Identity:
Asp.net Service Account; NT Authority\Network Service; Report Server and Manager are both using Classic.Net AppPool
I've attempted for hours to weed through Google and this forum but have repeatedly wound up back where I started and more confused than when I started. I would deeply appreciate any help in resolving this matter.
I just spent two weeks figuring it out. I have a thread on here somewhere called "Vista & SSRS". It's not like one would expect Microsoft to be able to install their own software properly onto their own OS.....
I had to add both Report Mgr & Reporting Services to the Classic .net pool (whatever that is...it's in SSRS config)
I had to turn off that annoying thingie MS added to Vista to make it impossible to do anything - the thing Apple makes fun of in their commercials.
I had to add my user account and adin acct to the IIS user group
I had to install every IIS option, basic install leaves some out.
I think that was all.....good luck
|||Thanks for the tips, JohnSLG. I had already done all but adding my user and admin accounts to the IIS User group. Unfortunately, my problem is still not resolved.
Just going to have to keep trolling here and Google in the hopes to find an answer. What twists my noodle more than anything is that I went through a helluva long and frustrating effort to get SRSS working before I had to upgrade Vista.
|||I'm now just so flippin' lost ... Was finally able to access Report Manager after I created a new application pools from the RS Config Manager but then was unable to deploy reports from VS2005 and receive error message that "Report Server Web Service is unable to access secure ... verify WebServiceAccount is specified correctly in report server config file". Then I implusively hit "apply default settings" checkbox and then Apply and now I'm back where I started.
The simple fact is that I can no longer keep track of all the various settings I've changed from IIS Manager to RSConfig Manager to rsreportsever.config, user security settings, new app pools, etc. I'd like to start from scratch. removing every app pool every report server etc but that does not work because that stuff shows up again in RS Config Manager even after uninstall/reinstall. I simply don't know how to remove every last scrap and start the whole damn thing from scratch with the defaults. In short, I'm just in over my head and confused.
Think I'm going back to Access databases where I at least know what in the heck I'm doing. Right now, I'm just simply compounding problems by willy-nilly following every seemingly related tip I find on this board. It's my ignorance, but MS really could have done a much better job in making Reporting Services much less complicated with a simple to follow step by step install and configure instructions for those with my specific setup. I've got Vista Ultimate 64-bit edition with SQL Server 2005 Express SP2 and VS Studio 2005 and all I want to do is run the dam thing on my local machine so I can learn how it works. I want to be able to access the Report Manager via localhost\reports and be able to deploy reports from VS2005. Having to mess around with all these relatively arcane configuration and network settings is a royal pain in the rump.
/frustrated whining and moaning
|||I hear you....I'm not sure exactly what I did to finally get it to work for me, but I think it was adding the admin user account to the IIS group. I've since dumped Vista 64 - it's ***, no drivers, buggy and went back to Vista - probably should have gone back to XP....I had to go through the same gyrations to get report manager to work again.....fortunately it worked for me after following my 4 step program.
I don't know why Microsoft cannot install their own software on their own operating systems.
