Hello,

I am trying to upgrade the SQL 2008R2 Servers to SP3 in my environment. Would like to do this silently via SCCM.

Have tried some reference links, one of the link is : 

https://slecluyse.wordpress.com/2012/06/19/sql-server-2008-r2-upgrading-to-service-pack-1-silently/

But following this give an error :

#############################################################################

2015-01-27 11:11:08 Slp:     Message: 
2015-01-27 11:11:08 Slp:         No features were updated during the setup execution. The requested features may not be installed or features are already at a higher patch level. Please review the summary.txt logs for further details.
2015-01-27 11:11:08 Slp:     Data: 
2015-01-27 11:11:08 Slp:       DisableWatson = true
2015-01-27 11:11:08 Slp:     Stack: 
2015-01-27 11:11:08 Slp:         at Microsoft.SqlServer.Configuration.MsiExtension.SetInstanceInstallStateAction.GetEligiableInstances()
2015-01-27 11:11:08 Slp:         at Microsoft.SqlServer.Configuration.MsiExtension.SetInstanceInstallStateAction.ExecuteAction(String actionId)
2015-01-27 11:11:08 Slp:         at Microsoft.SqlServer.Chainer.Infrastructure.Action.Execute(String actionId, TextWriter errorStream)
2015-01-27 11:11:08 Slp:         at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.ExecuteActionHelper(TextWriter statusStream, ISequencedAction actionToRun)
2015-01-27 11:11:08 Slp: 
2015-01-27 11:11:08 Slp: ----------------------------------------------------------------------
2015-01-27 11:11:08 Slp: 
2015-01-27 11:11:08 Slp: Error result: -2068643838
2015-01-27 11:11:08 Slp: Result facility code: 1203
2015-01-27 11:11:08 Slp: Result error code: 2

#############################################################################

Please advise how could i create a silent upgrade package for SP3 to be deployed via SCCM.

##########################################################################

Please advise how could i create a silent upgrade package for SP3 to be deployed via SCCM.

I am not sure whether you perform SP upgrade from SCCM  may be you do I dont have idea about it.

As per  message you posted it says it cannot find any suitable instance to perform upgrade can you post the upgrade script you ran ?

Also please run discovery report using This article and post resul

Hi Vikram,

According to your description, you fail to install SQL Server 2008 R2 SP3. As the error indicates, this issue could be due to that requested features are already installed and there is no need to upgrade. Please run discovery report to detect the installed features according to Shankys post.

To install SQL Server 2008 R2 SP3 silently, the recommended way is to directly apply service pack from the command prompt. Assume that the installation package is located in folder C:\install , you can click on the Start button on the task bar, click run, type the command CMD.exe and execute the following command:

--Complete a silent install of a service pack to a specific instance
C:\install\SQLServer2008R2SP3-KB2979597-x64-ENU.exe /instancename=<instancename> /quiet

--Complete a silent install of a service pack to all instances
C:\install\SQLServer2008R2SP3-KB2979597-x64-ENU.exe/allinstances/quiet

For more information about how to install SQL Server 2008 R2 SP3, please refer to the article: http://www.databasejournal.com/features/mssql/article.php/3623126/SQL-Server-2005-150-Unattended-installation-150-Part-V.htm

However, if you want to deploy a silent upgrade package of SP3 via SCCM, I would like to recommend you post the question in the SCCM forums at https://social.technet.microsoft.com/Forums/systemcenter/en-US/home?category=configurationmanager. It is appropriate and more experts will assist you.

Regards,
Michelle Li

• Edited by Michelle LiMicrosoft contingent staff Friday, January 30, 2015 11:01 AM

Hello Michelle,

I tried running the command C:\install\SQLServer2008R2SP3-KB2979597-x64-ENU.exe/allinstances/quiet

but received the following error.

I have already tried in SCCM forums but there are not sure of the working of SQL SP.

I can create a package once I have the silent deployment script which should install the Service pack without any user intervention. That is what i am looking for.

Hi Vikram,

Regarding the error from the screenshot, the issue is due to that you miss two blanks and it should be the following command:

C:\install\SQLServer2008R2SP3-KB2979597-x64-ENU.exe /allinstances/ quiet

Regards,
Michelle Li