Help on a failed 'SQL 2016 Security Update for SQL Server 2016 Service Pack 1 GDR' windows update
Hello,
I have a message in my windows 10 check update of SQL 2019 service pack which i posted it's image below.
I have sql 2017, do I need this service pack?
If I do, how can successfully install this update?
If I do not need this update, how can delete this continuous windows update check?
Thank you very much.
I have a message in my windows 10 check update of SQL 2019 service pack which i posted it's image below.
I have sql 2017, do I need this service pack?
If I do, how can successfully install this update?
If I do not need this update, how can delete this continuous windows update check?
Thank you very much.
ASKER
I have sql 2017 installed in this computer (I did run the @@version before placing the question).
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you, great advice!
I checked and the programs "sql" installed has sql 2016:
I don't think sql 2016 us being used, is there a way to know what is using sql 2016 prior deleting it?
let me know please
I checked and the programs "sql" installed has sql 2016:
I don't think sql 2016 us being used, is there a way to know what is using sql 2016 prior deleting it?
let me know please
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
It's there...
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Exported the list from SQL services and there is no SQL 2016:
NAME STATE START MODE LOG ON AS PROCESS ID SERVICE TYPE
------------------------------------------------------- ------- ----------------------------------------- --------------------------------------- ------------- -------------------
SQL Server (SQLEXPRESS2017) Running Automatic NT Service\MSSQL$SQLEXPRESS2017 6456 SQL Server
SQL Full-text Filter Daemon Launcher (SQLEXPRESS2017) Running Manual NT Service\MSSQLFDLauncher$SQLEXPRESS2017 6348
SQL Server Launchpad (SQLEXPRESS2017) Running Automatic NT Service\MSSQLLaunchpad$SQLEXPRESS2017 4296
SQL Server Agent (SQLEXPRESS2017) Stopped Other (Boot, System, Disabled or Unknown) NT AUTHORITY\NETWORKSERVICE 0 SQL Agent
SQL Server Browser Stopped Other (Boot, System, Disabled or Unknown) NT AUTHORITY\LOCALSERVICE 0
If that is the case, then please go ahead and uninstall SQL Server 2016 completely.
ASKER
That’s it? Ok, will do.
Sure, update the status once SQL Server 2016 is uninstalled out..
ASKER
I haven gone to the office yet but will do.
What do u mean “update the status once SQL Server 2016 is ”?
What do u mean “update the status once SQL Server 2016 is ”?
Okay, what I meant is update me whether those Windows update was not shown after uninstalling SQL Server 2016 from your Server..
Ideally, uninstalling and restarting the Server should not display that update again..
Ideally, uninstalling and restarting the Server should not display that update again..
ASKER
Ol got it! Thank you very much for your help.
ASKER
Ok (I meant not “Ol”)
No issues, kindly let me know if any assistance required or else request you to close this question accordingly..
ASKER
Thank you!
Welcome..
I doubt that you have SQL Server 2016 along with SQL Server Tools 2017(SSMS 2017) installed in your Server.
If you don't have SQL Server 2016, Windows update won't push you to install Service Pack for SQL Server 2016.
In SSMS, kindly run
Open in new window
to confirm this..If you have SQL Server 2016, then I would recommend you to install SP2 for SQL Server 2016 and the above prompting of Windows update will go away.
https://www.microsoft.com/en-us/download/details.aspx?id=56836
If you don't want to install SP2 for SQL Server 2016, then try downloading KB4458842 directly and install with "Run as Administrator" option to get it fixed out..
http://www.catalog.update.microsoft.com/search.aspx?q=4458842