Monday, April 27, 2009

TFS 2008 SP1, WSS3.0 SP1 and SQL Server Express 2008 on Windows 2008 – Won’t work!

  • TFS 2008 SP1 will not work with SQL Express 2008 as Express does not have Agent enabled.
  • You cannot upgrade from Express 2008 to the Standard 2008 as the setup program uses the shell of the installed instance. Instead you have to remove all instances (you can leave the shared tools installed) and then re-run setup from you Standard 2008 setup program
  • When TFS 2008 SP1 installs it assumes that your Analysis Service is on the default sql instance – mine wasn’t. You will need this to change your TFS setup to work.
  • It’s always wise to check that your client is Sql 2008 when you decide to install your server with no interface. I decided to have a light weight server and then had to upgrade my laptop as SQL Server 2005 obviously can’t connect to SQL Server 2008.
  • SQL Server 2008 shared tools need SP1 of Visual Studio installed!
  • You need over 3GB to install the Service Pack and that isn’t going to happen when you only have 2Gb free

What a bloody brilliant afternoon today has been!

No comments: