Archive for November, 2012

Troubleshoot_Failed_Setup_SQl2012

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

GO

sp_addsrvrolemember ‘doamin\useraccount’, ‘sysadmin’

GO

     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

 

 

Advertisements

Categories

November 2012
M T W T F S S
    Dec »
 1234
567891011
12131415161718
19202122232425
2627282930