Jump to content

Anyone have experience with sql native client install?


Go to solution Solved by JLogan3o13,

Recommended Posts

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
  • Moderators
  • Solution
Posted

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!

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
  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...