Sign in to follow this  
Followers 0
obfuscatedv

Anyone have experience with sql native client install?

3 posts in this topic

#1 ·  Posted (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 by obfuscatedv

Share this post


Link to post
Share on other sites



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
1 person likes this

√-1 2^3 ∑ π, and it was delicious!

Share this post


Link to post
Share on other sites

That is pretty close to what I need!  I really appreciate the help! Thanks  :)

Share this post


Link to post
Share on other sites

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 account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0