x

SSRS 2008 connectivity

Hi All,

As I understand, SSRS 2008 does not depend on IIS anymore.

But I was not able to connect to SSRS reports page : http://servername/reports (from outisde the server with servername) When I installed IIS, it started working.

Also, from locally when I try http://localhost/reports or http://servername/reports, I get below error: User 'DOMAIN\LOGINNAME' does not have required permissions. Verify that sufficient permissions have been granted and Windows User Account Control (UAC) restrictions have been addressed.

I am the admin on the server and Builtin\Admins is the sysadmin on SSRS. I have added the SSRS website URL to Trusted sites.

Questions: 1. Why dependency on IIS still?

  1. Why the error mentioned above? Answer: The UAC error was resolved when I open the SSRS URL with RUN AS ADMIN in IE.

However, I am still not clear about the dependency of SSRS 2008 R2 on IIS?

Thanks in advance...

Thank you in advance,

more ▼

asked Sep 28, 2011 at 12:47 AM in Default

Mandar Alawani gravatar image

Mandar Alawani
376 32 37 43

(comments are locked)
10|1200 characters needed characters left

1 answer: sort oldest

SQL Server 2008 R2 Reporting Services is not dependent on IIS. It utilizes [http.sys][1], which is a Window Server API process. I have it running in production and on VMs I run at home without IIS installed.

What issue you had, I do not know and since you installed IIS it is probably a mute point now.

[1]: http://msdn.microsoft.com/en-us/library/windows/desktop/aa364510%28v=vs.85%29.aspx
more ▼

answered Nov 03, 2011 at 02:07 PM

Shawn_Melton gravatar image

Shawn_Melton
5.3k 19 21 29

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x553
x113
x87
x46
x5

asked: Sep 28, 2011 at 12:47 AM

Seen: 1385 times

Last Updated: Sep 28, 2011 at 11:13 PM