Home > SQL Server 2012 > SQL server 2012 Service pack 1 upgrade issue

SQL server 2012 Service pack 1 upgrade issue

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.

  1. Launch the SQL Server 2012 Setup program (setup.exe) from the distribution media.
  2. In the left navigation area, click Maintenance, and then click Repair.
  3. 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.
  4. On the Select Instance page, select the instance to repair, and then click Next.
  5. The repair rules will run to validate the operation. To continue, click Next.
  6. 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

Categories: SQL Server 2012
  1. July 22, 2013 at 5:39 pm

    Dear friend. I truly just like your posting and your current web page all in all! That write-up is really plainly composed

    and without difficulty understandable. Your WordPress style is awesome as well! Would be awesome to discover exactly where

    My partner and i are able obtain this. Please hold up the very good work. We all need much more this kind of website

    owners just like you on the web and much less spammers. Wonderful man!
    Hadoop online training

  1. June 27, 2013 at 9:35 am

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s

%d bloggers like this: