June 30, 2016 at 1:40 pm
Hi Folks,
In our Production environment, we are trying to add one more additional standalone instance with same SQL Server 2008 R2 version. But during installation we are getting below mentioned error, kindly share your thoughts to fix our current problem. Please do the needful ASAP, it would be great for us.
Main Error: Attempted to perform an unauthorized operation.
Log:
2016-06-30 15:13:50 Slp: Running Action: SqlBrowserConfigEngAction_install_ConfigNonRC_Cpu64
2016-06-30 15:13:50 Slp: Action Data:
2016-06-30 15:13:50 Slp: Feature = SQL_Engine_Core_Inst_sql_engine_core_inst_Cpu64
2016-06-30 15:13:50 Slp: Scenario = install
2016-06-30 15:13:50 Slp: Timing = ConfigNonRC
2016-06-30 15:13:50 Slp: ConfigObjectType = Microsoft.SqlServer.Configuration.SqlBrowser.SqlBrowserPrivateConfig
2016-06-30 15:13:50 Slp: FeatureName = SQL_Engine_Core_Inst
2016-06-30 15:13:50 Slp: FeatureCpuType = Cpu64
2016-06-30 15:13:50 Slp: FeaturePackageId = sql_engine_core_inst
2016-06-30 15:13:50 SQLBrowser: StartMethod Type='SqlBrowserPrivateConfig' Method='Install'.
2016-06-30 15:13:50 SQLBrowser: Timing = 'ConfigNonRC'.
2016-06-30 15:13:50 SQLBrowser: StartMethod Type='SqlBrowserPrivateConfig' Method='RedirectUnitTestScenarioIfNeeded'.
2016-06-30 15:13:50 SQLBrowser: EndMethod Type='SqlBrowserPrivateConfig' Method='RedirectUnitTestScenarioIfNeeded'.
2016-06-30 15:13:50 SQLBrowser: StartMethod Type='SqlBrowserPrivateConfig' Method='ExecWithRetry'.
2016-06-30 15:13:50 SQLBrowser: Timing = 'ConfigNonRC'.
2016-06-30 15:13:50 SQLBrowser: StartMethod Type='SqlBrowserPrivateConfig' Method='SelectAndExecTiming'.
2016-06-30 15:13:50 SQLBrowser: Timing = 'ConfigNonRC'.
2016-06-30 15:13:50 SQLBrowser: StartMethod Type='SqlBrowserPrivateConfig' Method='ExecConfigNonRC'.
2016-06-30 15:13:50 SQLBrowser: Feature = 'SQL_Engine_Core_Inst_sql_engine_core_inst_Cpu64'.
2016-06-30 15:13:50 SQLBrowser: StartMethod Type='SqlBrowserPrivateConfig' Method='RetrieveSQLServer2000Instance'.
2016-06-30 15:13:50 SQLBrowser: SQL Discovery data for SQL Server 2000 instance was found.
2016-06-30 15:13:50 SQLBrowser: No SQL Server 2000 instance was found on the machine.
2016-06-30 15:13:50 SQLBrowser: EndMethod Type='SqlBrowserPrivateConfig' Method='RetrieveSQLServer2000Instance'.
2016-06-30 15:13:50 SQLBrowser: StartMethod Type='SqlBrowserPrivateConfig' Method='ConfigUserProperties'.
2016-06-30 15:13:50 SQLBrowser: StartMethod Type='SqlBrowserPrivateConfig' Method='StopServiceIfNeeded'.
2016-06-30 15:13:50 Slp: Sco: Failed to open service handle for service SQLBrowser
2016-06-30 15:13:50 SQLBrowser: SQL Server Browser service 'SQLBrowser' does not exist. There is no need to stop it.
2016-06-30 15:13:50 SQLBrowser: EndMethod Type='SqlBrowserPrivateConfig' Method='StopServiceIfNeeded'.
2016-06-30 15:13:50 SQLBrowser: StartMethod Type='SqlBrowserPrivateConfig' Method='UpdateAccountIfNeeded'.
2016-06-30 15:13:50 Slp: Sco: Attempting to get start account for service SQLBrowser
2016-06-30 15:13:50 Slp: Sco: Failed to open service handle for service SQLBrowser
2016-06-30 15:13:50 Slp: Prompting user if they want to retry this action due to the following failure:
2016-06-30 15:13:50 Slp: ----------------------------------------
2016-06-30 15:13:50 Slp: The following is an exception stack listing the exceptions in outermost to innermost order
2016-06-30 15:13:50 Slp: Inner exceptions are being indented
2016-06-30 15:13:50 Slp:
2016-06-30 15:13:50 Slp: Exception type: Microsoft.SqlServer.Configuration.Sco.ScoException
2016-06-30 15:13:50 Slp: Message:
2016-06-30 15:13:50 Slp: Attempted to perform an unauthorized operation.
2016-06-30 15:13:50 Slp: Data:
2016-06-30 15:13:50 Slp: WatsonData = SQLBrowser
2016-06-30 15:13:50 Slp: DisableRetry = true
2016-06-30 15:13:50 Slp: Inner exception type: System.UnauthorizedAccessException
2016-06-30 15:13:50 Slp: Message:
2016-06-30 15:13:50 Slp: Attempted to perform an unauthorized operation.
2016-06-30 15:13:50 Slp: Stack:
2016-06-30 15:13:50 Slp: at Microsoft.SqlServer.Configuration.Sco.Service.OpenService()
2016-06-30 15:13:50 Slp: at Microsoft.SqlServer.Configuration.Sco.Service.QueryServiceConfig()
2016-06-30 15:13:50 Slp: at Microsoft.SqlServer.Configuration.Sco.Service.GetStartAccount()
2016-06-30 15:13:50 Slp: ----------------------------------------
June 30, 2016 at 1:57 pm
It looks like the existing SQL service account, or the account that is doing the installation, does not have enough rights to the files and folders.
Also, run the administrator as Administrator
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
July 1, 2016 at 5:46 am
Thanks for your response Michael L John !!
But, I am running as a admin account even assigned same account across all folder and files. It didn't help us 🙁
Is there any other possible way to avoid this error?
Cheers,
Karthik.
July 1, 2016 at 8:01 am
did you right click on setup.exe and select 'run as administrator' ?
---------------------------------------------------------------------
July 1, 2016 at 8:50 am
Yes off-course, also made setup.exe always 'run as administrator' under security tab of setup properties.
Cheers,
Karhtik.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply