Working with errors in SQL Server can be a challenging yet rewarding experience. It allows us to gain a deeper understanding of how SQL Server functions and helps us solve common problems that users encounter on a daily basis. In this blog post, we will explore a specific installation error that a client faced while installing Service Pack 4 for SQL Server 2008 in a clustered environment.

When troubleshooting installation errors, it is important to start by examining the setup logs. In this case, the author looked into the “%programfiles%\MicrosoftSQL Server\110\Setup Bootstrap\Log\” directory and found a folder corresponding to the date and time of the installation. Opening the Summary.txt file within this folder revealed the following errors:

Overall summary:
Final result: The patch installer has failed to update the following instance: MSSQLSERVER. To determine the reason for failure, review the log files.
Exit code (Decimal): -568706566
Exit facility code: 1562
Exit error code: 14842
Exit message: The patch installer has failed to update the following instance: MSSQLSERVER. To determine the reason for failure, review the log files.
Start time: 2016-05-17 03:18:32
End time: 2016-05-17 03:23:33
Requested action: Patch Instance MSSQLSERVER

Overall summary:
Final result: The patch installer has failed to update the shared features. To determine the reason for failure, review the log files.
Exit code (Decimal): -568706566
Exit facility code: 1562
Exit error code: 14842
Exit message: The wrong diskette is in the drive. Insert (Volume Serial Number: ) into drive . (Exception from HRESULT: 0x80070022)
Start time: 2016-05-17 03:19:32
End time: 2016-05-17 03:22:33
Requested action: Patch

Based on the error message, the author was prompted to review the log files for further information. Upon further investigation, the author opened the Detail.txt file for this instance and found the following exception:

Exception type: System.Runtime.InteropServices.COMException
Message: The wrong diskette is in the drive. Insert (Volume Serial Number: ) into drive . (Exception from HRESULT: 0x80070022)

From the exception stack, it became clear that there were issues with the clustered disk. The author advised the client to contact their hardware team to resolve the issue. Once the issue was fixed, the Service Pack installation proceeded successfully.

While it may not always be possible to provide a direct solution to every error, providing guidance and pointing users in the right direction can be just as valuable. If you have encountered this particular installation error or have any questions, please feel free to leave a comment below.