Thoughts about setup and deployment issues, WiX, XNA, the .NET Framework and Visual Studio
All postings are provided AS IS
with no warranties, and confer no rights. Additionally, views expressed
herein are my own and not those of my employer, Microsoft.
I was asked by a customer a while back about available options for performing silent installation of SQL Server 2005 Express Edition. I haven't had a lot of time to research this issue, and the only steps I knew were the ones used by Visual Studio setup to install SQL Express.
Now that I looked into this scenario a bit more, I found an MSDN document entitled How to: Install SQL Server 2005 from the Command Prompt that provides in-depth instructions regarding supported command line switches for SQL 2005 setup and steps for creating an automated installation answer file.
The instructions in this document will allow you to perform all of the following configuration tasks, plus several more that I didn't list:
Please note that these instructions are generic and apply to all versions of SQL Server 2005. Some of the advanced configuration options are not supported by SQL Server 2005 Express Edition, so you will need to make sure to only attempt to install the Express Edition using switches and options that it supports.
This guide is intended to serve as a collection of links to articles, tools, tips and tricks that explain
I am trying to install SQL Server 2008 R2 Native Client at custom location.
For this I tried various approaches:
1. Installing by double clicking the msi:
In the installer screen browse button is disabled and it's not possible to provide custom installation path.
2. Command line instruction:
- msiexec /i sqlncli_x64.msi /qb /lv %1 INSTALLSHAREDDIR=%3 FEATURE=SQL_SNAC_CORE,SQL_SNAC_SDK IACCEPTSQLNCLILICENSETERMS=YES
where %3 is the user specified custom installation path.
Even after specifying the custom path, the Native Client is getting installed at the default path only. (<program files>\Microsoft SQL Server\).
- I also tried executing the following command but this too is not working:
msiexec /i “<MSI Path>” INSTALLDIR= “<Custom Path>”
When I installed the SQL Server Native Client through SQL Server Installer by providing custom path on the features selection page, the Native Client got installed at custom location.
As SQL Server installer is able to do it, there should be some parameter through which it provides custom path to the Native Client installer.
Please let me know if there is any such parameter or any other way to install SQL Server 2008 R2 Native Client at custom location.
Thanks & regards,
Hi Apeksha - I don't have enough expertise in how SQL Server setup works to be able to answer this question. I'd suggest posting a question on the SQL Server Setup forum at social.msdn.microsoft.com/.../threads and hopefully someone there will be able to help.