SQL Server Reporting Services unable to connect to the localhost on Vista

by Rick Glos 7/24/2008 10:44:49 AM

I finally have need to do some development against SQL Server Reporting Services (SSRS).  Unfortunately the first time I tried to browse to http://localhost/reports I get this nice error: Unable to connect to the remote server.

I'm not sure why it got to this state.  I installed SQL Server with the defaults, including SSRS.  It should've been up and running.  But if anything, I've learned Vista has introduced alot of peculiarities.  So here's how I fixed it in case someone else finds this useful.

Here's the screen you'll get when you try and use Report Manager:

image

I guess the problem revolves around IIS 7.  So we need to crack open IIS 7.0 and then navigate down to the ReportServer virtual directory.  Make sure you are in Content View mode (which you can switch from the two tabs on the bottom row or via a right-click).  Double click on Handler Mappings.

image

You should see that ISAPI is disabled.

image

Here's how we enable it.  Click Edit Feature Permissions in the toolbar to the right:

image

In the pop-up windows we need to check the Script and Execute:

image

ISAPI will now be enabled:

image

Now you'll correctly see the SSRS web interface.

image

And you can see that in the screenshot above, I'm not seeing any folders or command options.  Even though my account was in the local administrators group, I still had to add account as Content Manager by launching IE as admin.  Additionally, I also had to add localhost to the Trusted Sites collection.  Once that was done, I was able to see objects and commands...

image

This was alot more complex than I expected.  How does Microsoft expect casual users to configure this stuff?

Anyway, later.

Be the first to rate this post

  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Tags:

programming

Related posts

Comments

10/15/2008 3:53:45 PM

James

Fantastci resource. This worked for me!!

James gb

Add comment


(Will show your Gravatar icon)  

  Country flag





Live preview

11/20/2008 7:34:44 PM

Powered by BlogEngine.NET 1.2.0.0
Theme by Mads Kristensen

About the author

Rick Glos Rick Glos

Moved to the Portland, OR after living 35 years in Chicago, IL and Milwaukee, WI. Write software to pay the bills. Aquire bills by being interested in bicycles, computer gaming, movies, and books.

E-mail me Send mail

Calendar

<<  November 2008  >>
MoTuWeThFrSaSu
272829303112
3456789
10111213141516
17181920212223
24252627282930
1234567

View posts in large calendar

Recent posts

Recent comments

Authors

Disclaimer

The opinions expressed herein are my own personal opinions and do not represent my employer's view in anyway.

© Copyright 2008

Sign in