

Now we have to extract SQL Server 2008 Service Pack 1 to a subfolder called PCU under the folder to which SQL Express installer files were extracted. This will automatically create the folder if not already present. Issue below command to extract files from installer. Note: These locations and names can be replaced according to your convenience. Here I have SQL Express and SP1 installers on Desktop and used a directory called SQL2008withSP1 on D Drive for slipstreaming. Microsoft SQL Server 2008 Express with Advanced Services Download We have to slipstream SQL 2008 SP1 to SQL 2008 Express with Advanced Services to get it installed on Windows 2008 R2.ĭownload 64 bit SQL 2008 Express with Advanced Services and SP1 from links below if you do not have them.

Note: SQL 2008 Express and SQL 2008 Express with Advanced Services are different. But SQL 2008 Express with Advanced Services with SP1 is not available for download from MS. This is because Windows 2008 R2 supports MS SQL Server 2008 integrated with Service Pack 1. If you still click on Run Program you will get an Setup failure dialogue If you ever tried to install MS SQL 2008 Express with Advanced Services on Windows 2008 R2 machine you would be greeted with Program Compatibility Assistant as below. Microsoft SQL Server 2008 Express with Advanced Services is a free download and is sufficient for many small and medium sized deployments with database size requirements not more than 4 GB.
