Unable to connect to SSRS within SSMS
Hi,In a nutshell I'm unable to connect to SSRS within SSMS yet I can connect to SSIS, SSAS and the Database Engine within SSMS from the same named server instance ("BOO\DEMO")"SQL Server 2005 Surface Area Configuration" reports that service status SSRS (DEMO) is running.The only other problem that I have found which may be linked is that within "Reporting Services Configuration Manager BOO\DEMO" there is a red circled crossed next to "Report Manager Virtual Directory", yet this application has just recently reported that I successfully created a virtual directory.Any help or constructive guidance would be greatly appreciated.Thanks in advance,Kieran.
April 9th, 2008 1:45pm

If you type http://<your_server>/reportserver$demo in your browser, what is the result ?
Free Windows Admin Tool Kit Click here and download it now
April 9th, 2008 4:00pm

Many thanks for the reply. I typed http://boo/reportserver$demowithin Internet Explorer and I got the following result; - Server Error in '/ReportServer$DEMO' Application. Server cannot access application directory 'C:\Program Files\Microsoft SQL Server\MSSQL.4\Reporting Services\ReportServer\'. The directory does not exist or is not accessible because of security settings. 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: Server cannot access application directory 'C:\Program Files\Microsoft SQL Server\MSSQL.4\Reporting Services\ReportServer\'. The directory does not exist or is not accessible because of security settings.Source Error: An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. Stack Trace: [HttpException (0x80004005): Server cannot access application directory 'C:\Program Files\Microsoft SQL Server\MSSQL.4\Reporting Services\ReportServer\'. The directory does not exist or is not accessible because of security settings.] System.Web.HttpRuntime.EnsureAccessToApplicationDirectory() +3631790 System.Web.HttpRuntime.HostingInit(HostingEnvironmentFlags hostingFlags) +87 [HttpException (0x80004005): Server cannot access application directory 'C:\Program Files\Microsoft SQL Server\MSSQL.4\Reporting Services\ReportServer\'. The directory does not exist or is not accessible because of security settings.] System.Web.HttpRuntime.FirstRequestInit(HttpContext context) +3540923 System.Web.HttpRuntime.EnsureFirstRequestInit(HttpContext context) +69 System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr) +275 Version Information:Microsoft .NET Framework Version:2.0.50727.832; ASP.NET Version:2.0.50727.832 I'm not sure where to go from here. Thanks again, Kieran.
April 9th, 2008 4:06pm

ok, so does 'C:\Program Files\Microsoft SQL Server\MSSQL.4\Reporting Services\ReportServer\' exist on your server ? If the answer is no, i think that you can reinstall SSRS. If the answer is yes, try to give access to "everyone" read/write on this folder, and type again http://boo/reportserver$demoin IE. If the result is correct, we will try to give correct permission on this folder.
Free Windows Admin Tool Kit Click here and download it now
April 9th, 2008 4:12pm

Many thanks, The directory 'C:\Program Files\Microsoft SQL Server\MSSQL.4\Reporting Services\ReportServer\' did not exist on my server so I did a re-install. I then set up the "Report SeverVirtual Directory" and the "Report Manager Virtual Directory" within the "Report Services Configuration Manager". I am now able to connect to SSRS within SSMS. Thanks again, Kieran.
April 10th, 2008 10:55am

Hi, I have this folder: Question 1) C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer I meant to say-- "ReportServer" dir is in in MSSQL.3 but not in MSSQL.4. In the report services configuration manager- all green. in the browser- I enter- https://personal/reportserver and there is no response. question 2)my computer name is : personal and my loging to computer- manoj. when I connect to SSMS- I see that "PERSONAL\SQL2005 (SQL Server 9.0.4053 - personal\manoj" because of this string - personal\manoj--- I am not sure what to enter in browser for report services--- should it be https:/personal/ReportServer$SQL2005 or https:/manoj/ReportServer$SQL2005 please help.
Free Windows Admin Tool Kit Click here and download it now
December 4th, 2010 7:15pm

Hi Kieran, what is your server name displays? In the report Services configuration manager- for Report server virtual directory- what is the name field has? in the browser - what do you enter to access reports? Thanks
December 4th, 2010 7:21pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics