obfuscatedv Posted January 24, 2014 Posted January 24, 2014 (edited) I have sql native client that I want to install on a few machines, and have both: sqlncli.msi sqlncli_x64.msi ...depending on the type of machine. Have these in the same directory as my install exe. From what I've found I can run msiexec.exe to install this but have also experimented with ShellExecuteWait(@ScriptDir & "sqlncli_x64.msi") I realize that the short script above only installs the x64 version. I'm just looking for the best way to do each in a clean way: 1. Run sqlncli based on the architecture. @OSArch? 2. Run silently, which includes accepting terms/agreement and installing all SDK components. I've found a parameter for installing the SDK components from technet (ADDLOCAL=ALL) but want to make sure it fully installs the SDK components and I havent had luck as of yet. The info ive found for accepting the license agreement requires the parameter IACCEPTSQLNCLILICENSETERMS=YES. ...but havent had any luck constructing a script that will take care of it. So I thought I'd see if anyone here had experience silently installing sql native client. Any help is appreciated. Thanks Edited January 24, 2014 by obfuscatedv
Moderators Solution JLogan3o13 Posted January 25, 2014 Moderators Solution Posted January 25, 2014 This works for me, from v. 9: #RequireAdmin $x86Path = @ScriptDir & "\sqlncli.msi" $x64Path = @ScriptDir & "\sqlncli_x64.msi" If @OSArch = "X64" Then ShellExecuteWait("msiexec.exe", '/i ' & $x64Path & ' ADDLOCAL=ALL APPGUID={0CC618CE-F36A-415E-84B4-FB1BFF6967E1} IACCEPTSQLNCLILICENSETERMS=YES /qb') Else ShellExecuteWait("msiexec.exe", '/i ' & $x64Path & ' ADDLOCAL=ALL APPGUID={0CC618CE-F36A-415E-84B4-FB1BFF6967E1} IACCEPTSQLNCLILICENSETERMS=YES /qb') EndIf obfuscatedv 1 "Profanity is the last vestige of the feeble mind. For the man who cannot express himself forcibly through intellect must do so through shock and awe" - Spencer W. Kimball How to get your question answered on this forum!
obfuscatedv Posted January 25, 2014 Author Posted January 25, 2014 That is pretty close to what I need! I really appreciate the help! Thanks
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now