Wednesday, November 12, 2008

Failed to setup TFS 2008 with SQL Server 2008 on Windows 2008

Finally got around to installing a brand spanky new TFS 2008 + SQL 2008 + Win2008 and out of gate run into a problem:

"The System Health Check has detected a problem that will cause Setup to fail. "
Description A compatible version of SQL Server is not installed.

So, I go over the guide and SQL install to make sure that I did install supported version for TFS08: SQL Server 2008 Enterprise Edition or Standard Edition and of course everything looks good.

On my second pass through the guide and find a small gotcha that I missed in the Prerequisite Installation: Team Foundation Server with a data-tier server that is running SQL Server 2008, you must integrate this service pack with files from the installation DVD for Team Foundation Server.

So to resolve the problem, one must follow instructions from the install guide: How to:

Integrate the Installation of Team Foundation Server and Service Pack 1.

bottom line: pay attention to the TFS Install Guide! ... and you may save a few hours of WTF is going on.


raffaeu said...

Thanks buddy you really helped me. I don't understand why in the latest guide Microsoft didn't mention the SP1, but it just talk about that at the end ...
Anyway, thank you so much for the tip!

Rob said...

O yeah, you'd think so. I'm in my fifth week of trying to install just such a setup for my workgroup. Product support has been online and on the phone with me for longer than nine hours. Still can't add projects from a separate machine on my workgroup with administrator credentials.

This is truly appalling stuff. Big fail, Microsoft. Congratulations. said...

Well, if you are interested contact me at and I am willing to take a whack at it.