Jump to content
Sign in to follow this  
obfuscatedv

Anyone have experience with sql native client install?

Recommended Posts

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

"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!

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  

  • Recently Browsing   0 members

    No registered users viewing this page.

×
×
  • Create New...