Team Foundation Server 2005 And Sql Express 2005

I haven't seen anything that says SQL Express 2005 is not supported for use with Team Foundation Server 2005. However, when I attempt the installation I get all sorts of errors '

Solution 1:

Yes, SQL Server Standard or higher is required for current versions of TFS. When you purchase a full copy of Team Foundation Server it comes with a restricted use SQL Standard Edition license under the following terms:

• You may only use the SQL Server software with Visual Studio Team Foundation Server; you may not use it for any other purpose.
• You may only install SQL Server on one physical device per Visual Studio Team Foundation Server license.

Solution 2:

Try SQL Server Express Advanced edition ... ( I don't remember if it has analysis services) Analysis services are required to generate reports. Also after installation of 2005 remember to start SQL Agent service.