Hello

I hope this is the right forum for this type of question.

 

I am trying to deploy the SQL Server 2008 R2 Native Client via group policy to a bunch of clients. But i am unable to find any documentation regarding if this is even supported?

I have the two files:  sqlncli(x86).msi and sqlncli(x64).msi that i have attached to a GPO as en assigned application. But the x64 package fails with this error:

Product: Microsoft SQL Server 2008 R2 Native Client -- The required IACCEPTSQLCLILICENSETERMS=YES command-line parameter is missing. By specifying this parameter, you acknowkledge that you accept the end user license terms for the Microsoft SQL Server 2008 R2 Native Client.

Funny thing is the 32 bit installes without this error. But if there is any documentation on this type of deployment and how to pass the parameters to a normal GPO deployment, i would be glad!

I can't find any info on supported deployment options.

Thanks for your time.

 

 

Hello,

Please see the following link to know how to install SQL Server Native Client silently:

http://msdn.microsoft.com/en-us/library/ms131321.aspx (Silent Install section)

 

Any .MSI can be installed using GPO.

 

Hope this helps.  

Regards,

Alberto Morillo
SQLCoffee.com

• Proposed as answer by WeiLin QiaoModerator Thursday, May 26, 2011 5:04 AM
• Marked as answer by WeiLin QiaoModerator Friday, June 03, 2011 2:07 AM

Hello,

Please see the following link to know how to install SQL Server Native Client silently:

http://msdn.microsoft.com/en-us/library/ms131321.aspx (Silent Install section)

 

Any .MSI can be installed using GPO.

 

Hope this helps.  

Regards,

Alberto Morillo
SQLCoffee.com 

Thank you for the answer. But how would I pass the commands to the standard GPO software deployment method?

 

 

Hello,

Please see the following link:

http://technet.microsoft.com/en-us/library/cc784175(WS.10).aspx (See concept of  transform file or ZAP file – command)

http://technet.microsoft.com/en-us/library/bb742606.aspx (section Customizing Applications by Using Command-Line Options)

 

Hope this helps.  

Regards,

Alberto Morillo
SQLCoffee.com

 

 

Thanks for your help!

 

I found the answer on Experts-Exchange. http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL_Server_2008/Q_26794754.html

Quote from that post:

 

I solved by using ORCA to generate an MST file for the install. Couldn't find a flag to set the EULA as accepted, but solved by performing the following action:

* Open sqlncli.msi in Orca
* Transform\New Transform
* Browse to "Custom Action\SNAC_IAcceptSQLNCLILicenseTerms"
* Right-Click\Drop Row
* Transform\Generate Transform

The add the transform file to the Group Policy using advanced configuration. 

 

quote end...

This is propperly unsupported by Microsoft. But it works in my environment too. I wish Microsoft would write more deployment posts. There never seems to be a general way to deploy msi packages. Even though MSI is supposed to be a universal format.

Per default all GPO installations sould supress all modal popups and license agreements! Why is nobody complaining?

• Marked as answer by Mobay Wednesday, June 08, 2011 1:56 PM

I just went through this process, your command line parameter may be off. I found it needed 

msiexec.exe /i "sqlncli64.msi" ALLUSERS=1 /qn /norestart /log output.log ADDLOCAL=ALL APPGUID={0CC618CE-F36A-415E-84B4-FB1BFF6967E1} IACCEPTSQLNCLILICENSETERMS=YES

Are you sure it is IACCEPTSQLCLILICENSETERMS?

For me it worked with IACCEPTSQLNCLILICENSETERMS instead of IACCEPTSQLCLILICENSETERMS

(Only difference is one Letter, the N)

• Edited by EbrithilBowser (Who the fuck is stealing my name) Wednesday, May 21, 2014 5:48 AM
• Proposed as answer by PolishPaul 13 hours 16 minutes ago

This worked for me as well, for NCLI 11 (SQL 2012). I simply added the following property/value in the property table in the transform:

IACCEPTSQLNCLILICENSETERMS / YES

And this worked perfectly fine deploying via GPO. I'm also using WMI filtering to apply the correct version to OS bitness.