Remember the command you (Alberto M.) showed me to slipstream SP1 onto SQL2K14 SP1?

It worked well. (below is the command).  But when I run it on a W2K12 WSFC cluster it tells me over and over that I either don't have permission, or it can't find the .exe file containing SP1.

Is this SUPPOSED to work, or is a gotcha?   I'm running on W2K12, not R2.

Thanks.

C:\Software-Resources\SQL2K14\setup.exe /action=install /updateenabled=TRUE /UpdateSource="C:\Software-Resources\SQL2K14-SP1\SQLServer2014SP1-KB3058865-x64-ENU.exe"

Hello,

The first paragraph of the following article makes me think is not intended for a cluster, if you are using SQL Server 2012 media. However, this note was removed on the SQL Server 2014 version of the article.

https://technet.microsoft.com/en-us/library/dd638066(v=sql.110).aspx

Does the Windows account you are using to install is an AD domain administrator with permission to Create Computer Objects and to Read All Properties. Please read the following article about the permissions required:

https://technet.microsoft.com/en-us/library/cc731002%28WS.10%29.aspx?f=255&MSPPError=-2147217396#BKMK_requirements


Hope this helps.

Regards,

Alberto Morillo
SQLCoffee.com

• Edited by Alberto MorilloMVP, Moderator 10 hours 27 minutes ago

Yes, I'm the only account in my lab, so I probably do have all the permissions necessary  :-) I'm a -500 sid.

Interestingly, following Peter Saddow's article on slipstreaming SQL2K8 SP1, I had no problems at all.  The slipstreamed media loaded properly on a W2K8 SP2 cluster. But that was yesterday. I will use that technique against SP3 for SQL2K8 next week

I wonder if would work against SQL2K14.  Can I just extract the files from the .exe?

The  account used to install the sql cluster should have create computer objects permissions in AD.

Otherwise you never successed. you can also ask your AD admin to preage the computer objects soem time it works as well.

Hello,

The first paragraph of the following article makes me think is not intended for a cluster, if you are using SQL Server 2012 media. However, this note was removed on the SQL Server 2014 version of the article.

https://technet.microsoft.com/en-us/library/dd638066(v=sql.110).aspx

Does the Windows account you are using to install is an AD domain administrator with permission to Create Computer Objects and to Read All Properties. Please read the following article about the permissions required:

https://technet.microsoft.com/en-us/library/cc731002%28WS.10%29.aspx?f=255&MSPPError=-2147217396#BKMK_requirements


Hope this helps.

Regards,

Alberto Morillo
SQLCoffee.com

• Edited by Alberto MorilloMVP, Moderator Thursday, July 23, 2015 8:40 PM

Hello,

The first paragraph of the following article makes me think is not intended for a cluster, if you are using SQL Server 2012 media. However, this note was removed on the SQL Server 2014 version of the article.

https://technet.microsoft.com/en-us/library/dd638066(v=sql.110).aspx

Does the Windows account you are using to install is an AD domain administrator with permission to Create Computer Objects and to Read All Properties. Please read the following article about the permissions required:

https://technet.microsoft.com/en-us/library/cc731002%28WS.10%29.aspx?f=255&MSPPError=-2147217396#BKMK_requirements


Hope this helps.

Regards,

Alberto Morillo
SQLCoffee.com

• Edited by Alberto MorilloMVP, Moderator Thursday, July 23, 2015 8:40 PM

Thanks for your reply:  I am not having a problem with creating the computer objects, I don't think.  I the problem seems to be that the setup /action= install command cannot find the file that contains the service pack upgrade.

Hello,

No, that wont work. The old way to slipstream a SQL Server 2008 media with an update cannot be used with SQL Server 2014.

Hope this helps.

Regards,

Alberto Morillo
SQLCoffee.com

• Edited by Alberto MorilloMVP, Moderator 6 hours 44 minutes ago

Hello,

No, that wont work. The old way to slipstream a SQL Server 2008 media with an update cannot be used with SQL Server 2014.

Hope this helps.

Regards,

Alberto Morillo
SQLCoffee.com

• Edited by Alberto MorilloMVP, Moderator Saturday, July 25, 2015 12:23 AM

Hello,

No, that wont work. The old way to slipstream a SQL Server 2008 media with an update cannot be used with SQL Server 2014.

Hope this helps.

Regards,

Alberto Morillo
SQLCoffee.com

• Edited by Alberto MorilloMVP, Moderator Saturday, July 25, 2015 12:23 AM
• Proposed as answer by Simon_HouMicrosoft contingent staff, Moderator Monday, July 27, 2015 11:21 AM

Again, thanks for your reply.

I am able to run 'setup.exe' for SQL2K14 on a W2K12R2 two-node cluster.

I just CANNOT get the /action=install command to work, EVEN when I simplify the name of the file containing the service pack to 'sp.exe' and put it in the same folder as the file 'setup.'  

I think that rules out permissions, especially as my account DID install the cluster.

I can only  hope the sp install is simpler than the full thing.  I think it is.

Ah!  Maybe the downloaded service pack is damaged.  That could do it.