SQL Server 2012 SP4 Error Code 0x80131500 – How to Resolve

errorsservice-packsql serversql-server-2012

This is an open request for any thoughts, advice or guidance about an issue I have while attempting to apply SP4 to a SQL Server 2012 installation.

The server is currently the secondary node of a two-node AG and has been running well for several years. The SP file is on a local drive and I am running it from the RDP desktop. The error code is 0x80131500.

Though the things I have found so far about that error code all relate to Windows Store on Windows 10.

When I look in the setup logs for the SP I see a "Network Path Not found" error and it seems to be looking for the Primary node of this AG.

Any assistance is appreciated.

Best Answer

Mystery solved. I have found out that the network segment between the nodes of the AG had File and Printer Sharing disabled. Only Sql traffic was allowed. Re-enabling that on both nodes of the AG for the time it takes to apply the patches on both nodes allowed the needed communication between them.

Just another reminder that you should always check the simple things first when you have a problem.

Have a great day Richard

Related Solutions

Sql-server – SQL Server 2012 Edition Upgrade Error

The error sounded very cryptic, but it resulted to be a simple solution:

http://databasebestpractices.com/attributes-match-present-attributes-directory-compressed-included-attributes-0-excluded-attributes-compressed-encrypted/

It meant that the target folder was compressed, I didn't notice before, so I uncompressed "c:\Program Files\Microsoft SQL Server" and the Edition Upgrade ended in 5 minutes succesfully.

Sql-server – Cannot Login to Fresh Installation of SQL Server 2012

Yup, that last little comment was it. Even though you can select a domain group for the Instance administrators, it will create this problem. You must add individual user accounts. Thanks for the help and pointers!

In the end I put it into single user mode and ran the following command from an elevated prompt:

sqlcmd -S localhost from the command prompt

EXEC sp_addsrvrolemember
'domain\username', 'sysadmin'; GO

exit

Restarted the SQL services normally and went right in.

Best Answer

Related Solutions

Sql-server – SQL Server 2012 Edition Upgrade Error

Sql-server – Cannot Login to Fresh Installation of SQL Server 2012

Related Question