If any one can help me please.. i have sucessfully implemented the forms authentication for ssrs 2008 r2.. the next step which i was trying to look into giving permission to the users for the reports or doing the site setting permission ..
I am getting this error message...
library!ReportServer_0-3!1dc4!09/29/2011-10:01:56:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: , Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. ---> System.Exception: Exception verifying user. A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
Fixed this problem ... however there is another problem for me.. if anyone can help please ....
Did you install SP1 for R2? There was an issue with the RTM version and Forms Authentication.
Thanks ...however my pc is having sql server enterprise version R2 and i am upto date with all the updates and i am getting that error when i am doing the forms authentication .. sucessfully logged in and then i get that page.
Any help will be helpfull.
Can't tell from the top of my head. Please debug the extension.
I received that error recently, when deploying to an additional server. Basically, you have to trick SSRS into using your admin login:
be RDP'ed into server desktopclose any IE windows that are opennavigate to your url, but use the /reportserver url instead of the uilogon, or /reports
use your administrator login from rsreportserver.confignow, without logging out, change the url to the /reports
this will let you into the report manager web interfacego to site settings in upper rightadd yourself to administrator and user, using the custom username you have storedthen go to "home", and add yourself to the security of the Home folder
worked for me, let me know if this helps!