People often ask me how to deploy SQL Server 2008 Express with applications as a prerequisite with Visual Studio 2008. Most often this situation is encountered when people want to deploy applications using the ClickOnce or they want to build a MSI package with SQL Server 2008 using Visual Studio 2008 and include the SQL Server packages with the setup.
Now I am providing you with a set of steps to demonstrate deployment of SQL Server 2008 with your application as a prerequisite. You can try these steps on your test environment first. SQL Server 2008 Express needs Windows Installer 4.5 and .Net 3.5 SP1 Framework.
In case if you are not on the MSDN blogs then I would request you to please visit my blog at http://blogs.msdn.com/manisblog because at times I improve the existing articles after reading emails from people who enthusiastically provide their feedback. These improvements might not be reflected on the other blog sites who have indexed this article.
DotNetFx35SP1 (folder) dotNetFX20 (folder dotNetFX30 (folder) dotNetFX35 (folder) dotNetMSP (folder) TOOLS folder) en (or some other localized folder) dotNetFx35setup.exe (file)
Open the [Program Files]\Microsoft SDKs\Windows\v6.0A\Bootstrapper\Packages\DotNetFx35SP1 folder or %ProgramFiles(x86)%\Microsoft SDKs\Windows\v6.0A\Bootstrapper\Packages\DotNetFx35SP1 on x64 operating systems Edit the Product.xml file in Notepad. Paste the following into the <PackageFiles> element: <PackageFile Name="TOOLS\clwireg.exe" /> <PackageFile Name="TOOLS\clwireg_x64.exe" /> <PackageFile Name="TOOLS\clwireg_ia64.exe" /> Find the element for <PackageFile Name="dotNetFX30\XPSEPSC-x86-en-US.exe" and change the PublicKey value to: 3082010A0282010100A2DB0A8DCFC2C1499BCDAA3A34AD23596BDB6 CBE2122B794C8EAAEBFC6D526C232118BBCDA5D2CFB36561E152BAE 8F0DDD14A36E284C7F163F41AC8D40B146880DD98194AD9706D057447 65CEAF1FC0EE27F74A333CB74E5EFE361A17E03B745FFD53E12D5B0CA5 E0DD07BF2B7130DFC606A2885758CB7ADBC85E817B490BEF516B6625D ED11DF3AEE215B8BAF8073C345E3958977609BE7AD77C1378D33142F13 DB62C9AE1AA94F9867ADD420393071E08D6746E2C61CF40D5074412FE 805246A216B49B092C4B239C742A56D5C184AAB8FD78E833E780A47D8 A4B28423C3E2F27B66B14A74BD26414B9C6114604E30C882F3D00B707 CEE554D77D2085576810203010001 Find the element for <PackageFile Name="dotNetFX30\XPSEPSC-amd64-en-US.exe" and change the PublicKey value to the same as in step 4 above Save the product.xml file
I referred the following documents / blogs to put these steps together :
Thank you very much for visiting my blog and this article. Please keep a watch on this blog for new posts.