TFS 2008 Deployment - 32000 Error

Although it burn in my groynes to start the blog with some Sharepoint or even SQL stuff i think its better to share with the world the solution to one hell of a problem installing (or Upgrading) TFS 2008.

Many of us "TFS" guys came with a error code that goes like this:

Error 32000.The Commandline '"C:\Program Files\Microsoft Visual Studio 2008 Team Foundation Server\Tools\TfsDb.exe" upgrade /server:"" /property:"TFS_SERVICE_ACCOUNT=QUALISYSTEMS\tfsservice;TFS_REPORTING_ACCOUNT=QUALISYSTEMS\TFSREPORTS;LCID=1033;VSTF_AS_INSTANCE=;VSTF_AS_DATABASE=TFSWarehouse" /showui:524548' returned non-zero value: 100

And now after weeks of searching, researching and what not i finally came to a solution to this problem.

For the matter of fact i believe there are many ways to resolve this problem cause, well there are many thing can cause this error code to pop up,

The way to find out what happens is by exploring to your %temp% folder and looking for files called:

• dd_install_vstf*.txt
• vsmsi*.txt

With this files you can accomplish everything (well almost)
In my case I've founded that while migrating the Databases from one server to another the new SQL server "lost" the permission that granted some users

I saw that by looking at the logs and finding the updating and connection to DB failed errors.

In my case i granted extended permission (you can find them under the login section for the user on your SQL Management Studio) and it worked like a charm.

also i came to the point that i needed to change my dbo user (that was assigned to tfsservice) to other user (lets say tfssetup).
i did it by running the stored procedure:

EXEC sp_changedbowner tfssetup

and assigning a new role to tfsservice (adding permissions such as dbo, dbdata-reader\writer)