2

Below is the detailed error message. I can't proceed with installation for the last one week. I've given full rights to registry keys that are associated to SQL Server but nothing has worked out. For the last one week no headway.

(Edit: Originally I posted that we were installing SQL Server version 2012 but that was a misunderstanding between me and my team. It's clear from the error messages it is a 2008 R2 version.)

The following error has occurred:

Attempted to perform an unauthorized operation.

Click 'Retry' to retry the failed action, or click 'Cancel' to cancel this action and continue setup.

For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft%20SQL%20Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=11.0.5058.0&EvtType=0x48BB60BC%25400xBB814387

summary.txt File Overall summary: Final result:
User cancelled Exit code (Decimal): -2068380094 Exit facility code: 1207 Exit error code: 1602
Exit message: User has cancelled. Start time:
2014-10-22 16:42:41 End time: 2014-10-23 06:26:49 Requested action: RunRules

Machine Properties: Machine name: UGJIS011
Machine processor count: 4 OS version:
Windows Server 2008 OS service pack: Service Pack 1
OS region: United States OS language:
English (United States) OS architecture: x64 Process architecture: 64 Bit OS clustered: No

Product features discovered: Product Instance
Instance ID Feature
Language Edition Version Clustered

Package properties: Description: SQL Server Database Services 2008 R2 ProductName: SQL Server 2008 R2 Type: RTM Version:
10 SPLevel: 0 Installation location:
C:\Users\msenfuma - admin\Desktop\SQL_2008_R2\x64\setup\
Installation edition: EVAL

User Input Settings: ACTION: RunRules
CONFIGURATIONFILE: ENU: True FARMACCOUNT: FARMADMINPORT:
0 FARMPASSWORD: ***** FEATURES:
HELP: False IACCEPTSQLSERVERLICENSETERMS: False INDICATEPROGRESS: False INSTANCENAME:
PASSPHRASE: ***** QUIET:
False QUIETSIMPLE: False RULES:
GLOBALRULES,SqlUnsupportedProductBlocker,PerfMonCounterNotCorruptedCheck,Bids2008InstalledCheck,BlockInstallSxS,AclPermissionsFacet,FacetDomainControllerCheck,SSMS_IsInternetConnected,FacetWOW64PlatformCheck,FacetPowerShellCheck UIMODE: Normal X86:
False

Configuration file: C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20141022_164238\ConfigurationFile.ini

Detailed results:

Rules with failures:

Global rules:

There are no scenario-specific rules.

Rules report file: C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20141022_164238\SystemConfigurationCheck_Report.htm

Exception summary: The following is an exception stack listing the exceptions in outermost to innermost order Inner exceptions are being indented

Exception type: Microsoft.SqlServer.Chainer.Infrastructure.CancelException Message: User has cancelled. Stack: at Microsoft.SqlServer.Configuration.UIExtension.Request.Wait() at Microsoft.SqlServer.Configuration.UIExtension.UserInterfaceProxy.NavigateToWaypoint(String moniker) at Microsoft.SqlServer.Configuration.UIExtension.WaypointAction.ExecuteAction(String actionId) at Microsoft.SqlServer.Chainer.Infrastructure.Action.Execute(String actionId, TextWriter errorStream) at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.ExecuteActionHelper(TextWriter statusStream, ISequencedAction actionToRun)

closed as off-topic by Jack Douglas Dec 13 '14 at 7:51

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Too localized - this could be because your code has a typo, basic error, or is not relevant to most of our audience. Consider revising your question so that it appeals to a broader audience. As it stands, the question is unlikely to help other users (regarding typo questions, see this meta question for background)." – Jack Douglas
If this question can be reworded to fit the rules in the help center, please edit the question.

  • 3
  • Please share summary.txt file add that in question use link by Remus to find it – Shanky Nov 26 '14 at 10:54
  • Summary.txt files pasted and Shared in the Question above – Michael Nov 26 '14 at 11:25
  • Start time: 2014-10-22 16:42:41 End time: 2014-10-23 06:26:49 did your SQL Server installation actually reached to installation page or just failed at Configuration check. Did you made sure you meet [Hardware and Software requirements][1] specially the .Net framework. Can you also add contents of file C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20141022_164238\SystemConfigurationCheck_Report.htm Just paste the complete screenshot. [1]: msdn.microsoft.com/en-us/library/… I cannot find anything concrete – Shanky Nov 26 '14 at 19:38
  • 2
    @Shanky my reason is this: "you are actually installing SQL Server 2008 R2 but in your question you have clearly in Bold written SQL Server 2012" - that makes it too localized I think, but lets discuss in The Heap – Jack Douglas Dec 13 '14 at 10:01
4

First you did a bit of mistake you are actually installing SQL Server 2008 R2 but in your question you have clearly in Bold written SQL Server 2012. Since you provided me 2008 r2 setup logs I would assume you did typo and you are installing SQL Server 2008 R2 so Please correct the question

I found below in SystemconfigurationCheck_report.htm

Checks if the SQL Server registry keys are consistent. Failed The SQL Server registry keys from a prior installation cannot be modified. To continue, see SQL Server Setup documentation about how to fix registry keys.

Plus below error

enter image description here

As you already wrote in your question that you fiddled with registry and in this process you made registry inconsistent so SQL Server is not able to proceed with installation of Setup files its failing at setup support file installation like below

enter image description here

Now this means that registry is inconsistent and ACL checks cannot be performed. In that case we have to manually provide access.

  1. Located HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server in registry
  2. Right click and go to Permission
  3. Click on Advance
  4. Tick on both check box (I. Inherit from parent the permission... II. Replace permission entries on all child objects...), click OK
  5. Click OK again

Hopefully this might solve your issue. if not there is log file called as Detail Global rules.txt that would have information about what registry key SQL Server was trying to access it would be better if you also upload that in shared drive.

Do you have visual Studio installed on the same server please tell me ?

Don't play with windows registry unless you are very much confident what you are doing. I dont think This Support article is applicable to your scenario but you must have a look at this

  • Thanks Shanky, I've looked into your Solution and am looking at refreshing. I've realized registry keys are a pain. I've done a fresh installation in a test environment having got your advice. While away my colleagues could have installed SQL server 2008 without my knowledge and it brought the inconsistent state. – Michael Nov 30 '14 at 15:44
  • Of course if you format the system and start fresh installation you would succeed I just wanted your feedback. Anyways thanks for the information :) – Shanky Nov 30 '14 at 15:59

Not the answer you're looking for? Browse other questions tagged or ask your own question.