Wednesday, February 18, 2009

SQL Reporting Services - Service Unavailable

There you are, happy and excited that you are about to start using SQL Reporting Services, and then it happens... you navigate to your report server (typically http://localhost/Reports) and you get an ugly error "Service Unavailable".

The good news is that it's probably just a quarky .NET 2.0 install that is messing it up. If it is, here's how to easily reinstall .NET 2.0 to make IIS happy:

1) Go to C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\ and copy the path in the "address bar" in Windows Explorer

2) Go to Start > Run and type in CMD

3) In the Command Window, type: cd (and then with your mouse, right-click on the window and then "Paste") -- the end result should be "cd C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727"

4) Type: aspnet_regiis -i and hit [enter]

These steps will reinstall .NET 2.0 and should fix the Service Unavailable error.