Resolved – Setup Doesnot Start For Sql Upgrade/Patch – 0x80004005

Installing SQL Service Pach or Hotfix does nothing;

In general all the install logs will be available at Setup Bootstrap (Example: C:\Program Files\Microsoft SQL Server\140\Setup Bootstrap\Log ), however you will not be able to see any additional infomration.

Before moving QL setup logs, temporary logs will be stored at %temp%, locate sqlsetup.log file from %temp% folder and check for error!

Sample Error:

x80004005

Fix is to reset security policy setting using below command (Ref: https://docs.microsoft.com/en-us/previous-versions/dotnet/netframework-4.0/bk67a586(v=vs.100)?redirectedfrom=MSDN )

caspol –machine –reset

 

Note:

  • You will not be able to execute the command from Powershell but use command prompt
  • The tool is available in multiple .net framework locations but choose the correct one (Example, resetting .NET 4.5 did not help to fix the problem but resetting from v2.0x helped to fix the problem)
  • Sample Screenshot:
    • caspol

 

This entry was posted in SQL, SQL Error, SQL Server, Uncategorized and tagged , , , , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s