Posted: 3/9/2010
I have installed SQL Server 2005 on our server. When I try to go to http://localhost/ReportServer, I can see the page, but when I go to http://localhost/Reports , I get a blank page.
Server is Windows 2003.
I have done: "C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_regiis.exe" -i
Please let me know, if anyone has faced this problem, and what was the resolution.
Try running the browser as administrator.
Posted: 3/10/2010
My userid is in admin group, will that be sufficient, or I need to run as an administrator.
I have seen this issue occur even when the user is an admin. Try run as admin.
If you get a blank page, that means that you can access, but you aint previleges. wich means, everything is correctly installed,. When you installed SS and Reporting did you add the current user (while installing) to the admin of reporting?
I did not see any option for adding current user to the admin of reporting. Can I update now?
Posted: 3/12/2010
If we run IE as admin, we get website cannot display the page error. HTTP 500 Internal Error. The log files has following error:
w3wp!ui!6!3/12/2010-14:33:59:: e ERROR: Requested registry access is not allowed.w3wp!ui!6!3/12/2010-14:33:59:: e ERROR: HTTP status code --> 500-------Details--------System.Security.SecurityException: Requested registry access is not allowed. at System.ThrowHelper.ThrowSecurityException(ExceptionResource resource) at Microsoft.Win32.RegistryKey.OpenSubKey(String name, Boolean writable) at System.Security.Cryptography.Utils.get_FipsAlgorithmPolicy() at System.Security.Cryptography.RijndaelManaged..ctor() at System.Web.Configuration.MachineKeySection.ConfigureEncryptionObject() at System.Web.Configuration.MachineKeySection.EnsureConfig() at System.Web.Configuration.MachineKeySection.EncryptOrDecryptData(Boolean fEncrypt, Byte[] buf, Byte[] modifier, Int32 start, Int32 length, IVType ivType, Boolean useValidationSymAlgo) at System.Web.UI.Page.EncryptStringWithIV(String s, IVType ivType) at System.Web.Handlers.AssemblyResourceLoader.FormatWebResourceUrl(String assemblyName, String resourceName, Int64 assemblyDate, Boolean htmlEncoded) at System.Web.Handlers.AssemblyResourceLoader.GetWebResourceUrlInternal(Assembly assembly, String resourceName, Boolean htmlEncoded) at System.Web.Handlers.AssemblyResourceLoader.GetWebResourceUrl(Type type, String resourceName, Boolean htmlEncoded) at System.Web.UI.ClientScriptManager.GetWebResourceUrl(Page owner, Type type, String resourceName, Boolean htmlEncoded) at System.Web.UI.ClientScriptManager.RegisterClientScriptResource(Type type, String resourceName) at System.Web.UI.WebControls.BaseValidator.RegisterValidatorCommonScript() at System.Web.UI.WebControls.BaseValidator.OnPreRender(EventArgs e) at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
For SSRS 2005 you must set up IIS to host the site. Make sure this is done.
Also try these walkthroughs:
http://msdn.microsoft.com/en-us/library/ms180127(SQL.90).aspx
http://technet.microsoft.com/en-us/library/ms189964(SQL.90).aspx
http://msdn.microsoft.com/en-us/library/ms144290(SQL.90).aspx
If the server is 64 bit
http://www.pythian.com/news/4778/installing-sql-server-2005-reporting-services-32-bit-on-a-windows-server-2003-64-bit/
Posted: 3/15/2010
I can see the sites on IIS. All the permissions looks ok to me.
<!-- /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {mso-style-parent:""; margin:0in; margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:12.0pt; font-family:"Times New Roman"; mso-fareast-font-family:"Times New Roman";} span.EmailStyle15 {mso-style-type:personal; mso-style-noshow:yes; mso-ansi-font-size:10.0pt; mso-bidi-font-size:10.0pt; font-family:Arial; mso-ascii-font-family:Arial; mso-hansi-font-family:Arial; mso-bidi-font-family:Arial; color:windowtext;} @page Section1 {size:8.5in 11.0in; margin:1.0in 1.25in 1.0in 1.25in; mso-header-margin:.5in; mso-footer-margin:.5in; mso-paper-source:0;} div.Section1 {page:Section1;} -->
The image did not show.
I copied, and pasted IIS information, but looks like I cannot insert a picture. Will I be able to insert a picture?
There is an insert image control above the comment reply field, and an upload button above that.
Posted: 3/16/2010
Trying using netstat -ano on the command line to see what all is trying to use port 80. You may have other applications that you don't know about that are using the default port. You could also just quickly change the port to something like 8080 in the report configuration to test.
Posted: 3/23/2010
Looks like the problem was the permission/user that has to set for IIS--> Application Pool cannot be network services. I put there as an individual user id, and I can see the page.