Issue: After installing SQL 2012 Database engine, Reporting service may fail with below error:

  Feature:                       Database Engine Services

  Status:                        Failed: see logs for details

  Reason for failure:            An error occurred during the setup process of the feature.

  Next Step:                     Use the following information to resolve the error, uninstall this feature, and then run the setup process again.

  Component name:                SQL Server Database Engine Services Instance Features

  Component error code:          -2147467259

  Error description:             Access is denied

OS is Windows 7 Enterprise

Troubleshooting Steps:

Actually the setup finishes with installing the binaries and system databases. It failed with adding and provisioning the account windows account and Sa account with Sysadmin permission

Here below is how to troubleshoot it:

  1. Make sure the account used to run setup is local admin
  2. Change the SQL server and agent service account to be the account you run the setup. ( in my case change to domain account that I logged in to perform setup
  3. Open SQL server configuration manager using “Run Elevated”:
  4. Change SQL server service startup account ( account used to run the setup)
  5. Then add –m to start SQL server in single user mode
  6. Restart SQL server service
  7. Connect to SQL server using SQLCMD from command line (example : sqlcmd -S SQLINSTANCENAME –E)
  8. Once connected add the account you logged in to sysadmin server role by running the below t-sql 

Use master


sp_addsrvrolemember ‘doamin\useraccount’, ‘sysadmin’


     9.  After disconnecting from command line go back to SQL configuration manager  and remove –m that you added at step 5 and restart SQL server so that

     SQL server can run in multi user mode

    10. Then you can connect using windows/SQL authentication to the SQL server instance




0 Responses to “Troubleshoot_Failed_Setup_SQl2012”

  1. Leave a Comment

Leave a Reply

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

You are commenting using your 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


November 2012
    Dec »

%d bloggers like this: