RAID Controller Not Initializing on boot after restart

I ran into an interesting issue with an older Dell server that I have. I tried to add some RAM to it, and one of the RAM sticks ended up being bad, but in the process of trying to boot up, it seems to have tried to load the BIOS information, but then failed when it hit the bad RAM.

So, what it did, was reset the BIOS! I didn't figure this out at first because I was getting nervous that the server would skip over the normal "Controller 0... Initializing..." part and then fail because it couldn't find a boot device.

The fix:

1) Start the Server

2) Go into SETUP

3) Go to INTEGRATED DEVICES

4) Look for the SCSI Setup (was on the top of the window in my screens)

5) Set the value to SCSI or RAID, depending on your setup

6) Exit and Save from the BIOS

Hopefully, if you situation is the same, this will fix it. :)

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.