Unable to open Report Manager URL
Hi I've a weird issue going on.
I've installed SQL 2008 on my system as a default instance on my machine. (it includes SSIS,SSAS and SSRS)...It was working fine before
I tried to install SQL 2005 as a default instance without knowing that we can have only one instance in one machine. It got installed but from then many issues started.
My 2008 SSRS was not working, and 2005 SSRS was working fine. Unfortunately SSSRS 2005 is working with the default instance of SSRS.
I removed both 2005 and 2008 from my machine, and installed 2008 as a fresh installation.
I installed it as Default Instance, with the instance ID = MSSQL2008
It installed properly, I'm able to connect to SSRS. However I'm not able to this instance MSSQL2008. I'm able to connect to the previous instance (which I uninstalled).
and when I open the Report Manager URL it is saying that
"
Server cannot access application directory 'C:\Program Files\Microsoft SQL Server\MSSQL.1\Reporting Services\ReportServer\'. The directory does not exist or is not accessible because of security settings.
"
that means my new SSRS is still pointing to the previous directory in programfiles. How could I tell to SSRS to go connect to
Server cannot access application directory 'C:\Program Files\Microsoft SQL Server\MSSQL2008\Reporting Services\ReportServer\'. The directory does not exist or is not accessible because of security settings.
What did i miss in all this mess up?
I can install as many SSIS as I can, there is no instance specification is over there, however in reporting services does it need to be a new instance every time I install?
Unknown
June 30th, 2011 10:40am
I guess I found out something Here...
I opened the IIS Manager and I wondered to see that the Reports virtucal Directory and ReportServer Virtual directory were shown as Error. I removed them and added 2 new virtual Directories with the same names ReportServer and Reports. I gave
the path for ReportServer as " C:\Program Files\Microsoft SQL Server\MSRS10.MSSQL2008\Reporting Services\Reportserver"
and For Reports virtual Directory I gave the path as "C:\Program Files\Microsoft SQL Server\MSRS10.MSSQL2008\Reporting Services\ReportManager "
Now If I open http://localhost/reports/
this is showing something I never usually saw before.
this is what it is showing
[To Parent Directory] Thursday, June 30, 2011 8:56 AM <dir> Bin Thursday, June 30, 2011 8:56 AM <dir> de Thursday, June 30, 2011 8:56 AM <dir> en Thursday, June 30, 2011 8:56 AM <dir> es Thursday, June 30, 2011 8:56 AM <dir> fr Thursday, July 03, 2008 10:20 PM 100 Global.asax Thursday, July 03, 2008 10:20 PM 250 Home.aspx Thursday, June 30, 2011 8:56 AM <dir> images Thursday, June 30, 2011 8:56 AM <dir> it Thursday, June 30, 2011 8:56 AM <dir> ja Thursday, June 30, 2011 8:56 AM <dir> js Thursday, June 30, 2011 8:56 AM <dir> ko Thursday, June 30, 2011 8:57 AM <dir> Pages Thursday, June 30, 2011 8:56 AM <dir> pt Thursday, July 03, 2008 10:20 PM 10807 rsmgrpolicy.config Thursday, July 03, 2008 10:20 PM 141 RSWebApplication.config Thursday, June 30, 2011 8:56 AM <dir> ru Thursday, June 30, 2011 8:56 AM <dir> Styles Thursday, June 30, 2011 9:03 AM 3526 Web.config Thursday, June 30, 2011 8:56 AM <dir> zh-CHS Thursday, June 30, 2011 8:56 AM <dir> zh-CHT
Same with the http://localhost/reportserver/
what am I missing here????
Unknown
Free Windows Admin Tool Kit Click here and download it now
June 30th, 2011 11:39am
I'm answering my self, no one is responding to my question. Did you understand what I've asked?
Now I clicked on
Home.aspx from top and I got the following error...please let me know where and what I can do to fix this?
The current identity (MYUSERNAME\ASPNET) does not have write access to 'C:\Program Files\Microsoft SQL Server\MSRS10.MSSQL2008\Reporting Services\RSTempFiles\'.
Description:
An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Web.HttpException: The current identity (WITJMOHAMMED01\ASPNET) does not have write access to 'C:\Program Files\Microsoft SQL Server\MSRS10.MSSQL2008\Reporting Services\RSTempFiles\'.
Thursday, July 03, 2008 10:20 PM 250 Home.aspxUnknown
June 30th, 2011 12:43pm
Funny for the first time in microsoft forum I didn't get any reply for 3 hours...
even funny part is that my reporting services 2005 working fine...only 2008 is creating this much pain...Unknown
Free Windows Admin Tool Kit Click here and download it now
June 30th, 2011 2:23pm
Hi,
Since you have removed both 2005 and 2008 from your machine just like you mentioned, I am not sure why you can connect to your previous instance(uninstalled), it seems uninstall has not been completed.Please remember to mark the replies as answers if they help and unmark them if they provide no help.
July 4th, 2011 10:50pm
A couple of clarifications:
Do u still have both SSRS 2005 and SSRS 2008 ? Looks like there might be some Uninstallation issues with your previous install. Can you check on the Service Accounts being used, and if they have right permissions?
In your message above, it looks like you modified the Virtual Directories to point to SSRS 2008 locations. You don't need to do them, as SSRS 2008 has no dependeny on IIS. If you already uninstalled SSRS2005, go ahead and remove those SSRS 2005 virtual directories.
I would suggest you to use SSRS 2008 configuration manager, and check the configuration settings. Check :
http://technet.microsoft.com/en-us/library/ms156305(SQL.100).aspx
What is the exact requirement? Are you planning to use SSRS 2005, and SSRS 2008 simultaneously? If yes, then you can use without any issues. Reporting Services 2005 needs IIS, where as SSRS 2008 doesn't need IIS to be installed. There shouldn't be any conflict.
If you are planning to upgrade SSRS 2005 to SSRS 2008, then refer:
http://technet.microsoft.com/en-us/library/ms143747(SQL.100).aspx
Hope this helps..
Thanks,
Chaitanya( Twitter |
Blogs )
Any documentation bug? Tell us about it at
Connect. Please feel free to add any community comments in any of the MSDN/technet articles.
This posting is provided "AS IS" with no warranties, and confers no rights.
The next CTP for SQL Server Code Name "Denali" is coming soon.
Sign up now to be notified of the next CTP release.
Free Windows Admin Tool Kit Click here and download it now
July 5th, 2011 1:28am


