Issue 1: SQL service did not turn up after the Service pack Upgrade and received the message at Event viewer “service specific error code 3417”
To resolve the issue we have to repair the sql server service.
- Launch the SQL Server 2012 Setup program (setup.exe) from the distribution media.
- In the left navigation area, click Maintenance, and then click Repair.
- Setup support rule and file routines run to ensure that your system has prerequisites installed and that the computer passes Setup validation rules. Click OK or Install to continue.
- On the Select Instance page, select the instance to repair, and then click Next.
- The repair rules will run to validate the operation. To continue, click Next.
- From the Ready to Repair page, click Repair. The Complete page indicates that the operation is finished.
The important note is the sql server is appeared along with all existing user databases so safely we can go for the existing environment. Earlier we have to attach the user database again after rebuild the system databases but in 2012 no need to worry for the same. As a safety you can copy the data file and log files for user database and msdb database. The repair command rebuilds the system databases and the above option applicable if you don’t have the master database backup. Once the repair has been done successfully afterwards you have to start the sql server service manually from configuration manager.
Issue 2: : The patch installer has failed to update the shared features. To determine the reason for failure, review the log files.
To resolve the above issue we have to install the Visual studio service pack. It is a known bug in SQL 2012 SP1 and it forces the need for a complete install of Visual Studio 2010. The version that is installed I don’t think will work.
Note: SQL cannot be updated until Visual Studio is installed, and SP1 applied to VS2010. Then we can update SQL to SP1. Reference link http://social.msdn.microsoft.com/Forums/en-US/sqlsetupandupgrade/thread/2867fe21-6414-4bd9-879e-ded00716ba70