The setup failed to read IIsMimeMap table. The error code is -2147023550.

I've been facing issues with installation of Reporting service 2005 and making it run but for the first time I faced an issue while uninstalling it. On trying to uninstall I got the following error
"The setup failed to read IIsMimeMap table. The error code is -2147023550"
Solution:
1. Stop IIS Admin service
2. Stop IIS
3. Uninstall Reporting service.
Result:
Successfully uninstalled Reporting service 2005

ASP .Net Service account appears blank

Its been time I got a chance to trouble shoot a Reporting Service Problem, and this time it was on Windows 7. Actually I faced this issue once before and I managed to skip trouble shooting that.
Reading the initial "Program incompatible message" on running the setup of SQL 2005 I came to know that its necessary to install SP3 for SQL 2005 to run on Windows 7. I downloaded it and installed successfully.
On opening (my favorite) Reporting service Configuration tool, I observed that the "ASP .Net Service Account" appeared blank and because of that I was not able to change the Application pool to ReportServer (which is created by default)
Reading few blogs I changed the Application Pool to Reportserver (from DefaultAppPool) using IIS-> Advanced Settings
But still the problem of the ASP .Net service account was lingering.
I ran the following command to get the service account appear in the configuration tool.
aspnet_regiis -ga "NT Authority\NetworkService"

Change in PC name, stops Reporting Service 2005

I deployed few reports on my Test Machine with TestMachine. As we wanted to implement a format of PC names, we happened to change the name of the Machine to e.g CompanyTestMachine
Before the rename happened, our system as well as the reports were working properly. Once the name was changed, we started getting error Report Server database not found.
Then I thought to redo the settings of Reporting service so as to change the required settings. On following the steps, I came across a error
User CompanyTestMachine\ASPNet not found
I then tried repairing the Microsoft Framework which didnt help. I ran the aspnet_regiis.exe /i command which also didn't help. I read many blogs but couldn't find a way out so I ended up renaming the machine to its original name.
I am still searching for a solution to this problem, if someone reading this has one I would appreciate if you could share it with me.

Unit Tests : Not Runnable - VSTS 2008 SP1

I am sure most of us are facing this issue. After adding ordered unit tests to our project and creating a test list for these whenever we open the project the Tests are indicated as Not-Runnable.

This can be sorted by pressing the Refresh button in the Test View as below

Read this for more details

http://social.msdn.microsoft.com/forums/en-US/vststest/thread/2f907f7b-c689-439e-9dfb-731b5b7795f4/

Delete a Team Project

One of the new team members accidently created a team project (Remiss of the administrator for giving him full control).
Found out a way to delete the team project
Open a command line on your team foundation server and cd to
drive:/%program files%\Microsoft Visual Studio 9.0\Common7\IDE (For VSTS 2008)

tfsdeleteproject /q /force /server:<tfs server> "<project name>"

Restoring TFS 2008

I am sure everyone will be taking backup of their TFS on regular basis. Being new to TFS I thought to try and restore the TFS on a new machine, to avoid the risk of not taking backup of anything.

I had a spare PC in which I installed the trial of TFS. the environment of the new machine was now exactly the same as that of the old (or existing)machine.
The link which helped me for this was
http://msdn.microsoft.com/en-us/library/ms404869.aspx

Error 28002 : Unknown Error

This was the forth time I was installing TFS 2008 and I got this error for the first time. It has to do with the DNS. TFS is not able to resolve the Domain Name as a result of which it gives TFS3010 (if you see the Event log).
Resolution:
1. Open the web.config from the path below (TFS Root)
%systemdrive%/Program Files\Microsoft Visual Studio 2008 Team Foundation Server/Web Services/Web.config

Add the below key
<add key="<DomainFullyQualifiedPath>" value="dcHostName" />

And hit Retry on the Error message.