sql server 2008 version upgrade failed access to path is denied

Category: sql server setup

Question

Steve Richter on Tue, 22 Jun 2010 22:12:53


upgrading from 2008 r2 eval to 2008 r2 enterprise.

Use the maintenance option from setup. Get pretty far along in the process.  But then the following error. ( an additional note. setup warns that I am running sql server on a domain controller server. )

The link the error message points to has nothing to say. Why would my sql server upgrade fail? If I have to reinstall, will I lose my database data?

thanks,

 

TITLE: Microsoft SQL Server 2008 R2 Setup
------------------------------

The following error has occurred:

Access to the path 'C:\Program Files\Microsoft SQL Server\100\License Terms\SQLServer2008R2_License_ENT_1033.rtf' is denied.

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+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=10.50.1600.1&EvtType=0x60797DC7%25400xBB814387
 

Replies

Alberto Morillo on Tue, 22 Jun 2010 22:45:51


Hello,

Please verify the Windows account you are using to run SQL Server setup has full control access to “c:\program files\Microsoft SQL Server” directory, even when that Windows account is an administrator.

Use the Run as Administrator option to run SQL Server setup also.

http://www.sevenforums.com/tutorials/11841-run-administrator.html (Second option)

Hope this helps.

Regards,

Alberto Morillo
SQLCoffee.com

Steve Richter on Tue, 22 Jun 2010 22:52:41


more info on this.   Do the edition upgrade process with a sql server 2008 R2 standard edition version. The upgrade completes. Get a message "your sql edition upgrade is complete.  But, attempting to use MS sql server mgmt studio, get the same "eval period has expired" error.

Here are the steps from the install:
  - maintenance, edition upgrade
  - setup support rules - passed
  - warning: computer domain is controller
  - product key - burned in
  - license terms
  - specify instance : MSSQLSERVER
  - edition upgrade rule. passed 5.
  - click upgrade button
  - your sql edition upgrade is complete
  - close

 

 

 

 

 

 

Alberto Morillo on Wed, 23 Jun 2010 11:33:09


Hello,

Happy you upgraded your SQL instance.

The issue with SQL Server Management Studio is a known issue. Please see the following article by Jonathan Kehayias:

http://sqlblog.com/blogs/jonathan_kehayias/archive/2009/02/20/sql-server-2008-evaluation-edition-expiration-woes.aspx


Hope this helps.

Regards,

Alberto Morillo
SQLCoffee.com

Steve Richter on Wed, 23 Jun 2010 16:56:13


ran as administrator ( the title of the window says: "Administrator: Command prompt" ).  same error:

D:\>d:\Setup.exe /q /ACTION=editionupgrade /INSTANCENAME=MSSQLSERVER /IACCEPTSQL
SERVERLICENSETERMS
Microsoft (R) SQL Server 2008 R2 Setup 10.50.1600.01
Copyright (c) Microsoft Corporation.  All rights reserved.

The following error occurred:
Access to the path 'C:\Program Files\Microsoft SQL Server\100\License Terms\SQLSc:
erver2008R2_License_STD_1033.rtf' is denied.

Error result: -2068119551
Result facility code: 1211
Result error code: 1

Please review the summary.txt log for further details

Steve Richter on Wed, 23 Jun 2010 17:10:16


here is the summary.txt log file:

Overall summary:
  Final result:                  Failed: see details below
  Exit code (Decimal):           -2068119551
  Exit facility code:            1211
  Exit error code:               1
  Exit message:                  Access to the path 'C:\Program Files\Microsoft SQL Server\100\License Terms\SQLServer2008R2_License_STD_1033.rtf' is denied.
  Start time:                    2010-06-23 12:40:10
  End time:                      2010-06-23 12:41:28
  Requested action:              EditionUpgrade
  Log with failure:              C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20100623_123902\Detail.txt
  Exception help link:           http%3a%2f%2fgo.microsoft.com%2ffwlink%3fLinkId%3d20476%26ProdName%3dMicrosoft%2bSQL%2bServer%26EvtSrc%3dsetup.rll%26EvtID%3d50000%26ProdVer%3d10.50.1600.1%26EvtType%3d0x60797DC7%400xBB814387

Machine Properties:
  Machine name:                  ANTEC
  Machine processor count:       4
  OS version:                    Windows Server 2008 R2
  OS service pack:              
  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
  Sql Server 2008 R2   MSSQLSERVER          MSSQL10_50.MSSQLSERVER         Database Engine Services                 1033                 Enterprise Evaluation Edition 10.50.1352.12   No       
  Sql Server 2008 R2   MSSQLSERVER          MSSQL10_50.MSSQLSERVER         SQL Server Replication                   1033                 Enterprise Evaluation Edition 10.50.1352.12   No       
  Sql Server 2008 R2   MSSQLSERVER          MSSQL10_50.MSSQLSERVER         Full-Text Search                         1033                 Enterprise Evaluation Edition 10.50.1352.12   No       
  Sql Server 2008 R2   MSSQLSERVER          MSAS10_50.MSSQLSERVER          Analysis Services                        1033                 Enterprise Evaluation Edition 10.50.1352.12   No       
  Sql Server 2008 R2   MSSQLSERVER          MSRS10_50.MSSQLSERVER          Reporting Services                       1033                 Enterprise Evaluation Edition 10.50.1352.12   No       
  Sql Server 2008 R2                                                       Management Tools - Basic                 1033                 Enterprise Evaluation Edition 10.50.1352.12   No       
  Sql Server 2008 R2                                                       Management Tools - Complete              1033                 Enterprise Evaluation Edition 10.50.1352.12   No       
  Sql Server 2008 R2                                                       Client Tools Connectivity                1033                 Enterprise Evaluation Edition 10.50.1352.12   No       
  Sql Server 2008 R2                                                       Client Tools Backwards Compatibility     1033                 Enterprise Evaluation Edition 10.50.1352.12   No       
  Sql Server 2008 R2                                                       Client Tools SDK                         1033                 Enterprise Evaluation Edition 10.50.1352.12   No       
  Sql Server 2008 R2                                                       Integration Services                     1033                 Enterprise Evaluation Edition 10.50.1352.12   No       

Package properties:
  Description:                   SQL Server Database Services 2008 R2
  ProductName:                   SQL Server 2008 R2
  Type:                          RTM
  Version:                       10
  SPLevel:                       0
  Installation location:         d:\x64\setup\
  Installation edition:          STANDARD

User Input Settings:
  ACTION:                        EditionUpgrade
  CONFIGURATIONFILE:             C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20100623_123902\ConfigurationFile.ini
  ENU:                           True
  FARMACCOUNT:                   <empty>
  FARMADMINPORT:                 0
  FARMPASSWORD:                  *****
  FEATURES:                      OCS,CE_RUNTIME
  HELP:                          False
  IACCEPTSQLSERVERLICENSETERMS:  True
  INDICATEPROGRESS:              False
  INSTANCENAME:                  MSSQLSERVER
  PASSPHRASE:                    *****
  PID:                           *****
  QUIET:                         True
  QUIETSIMPLE:                   False
  UIMODE:                        Normal
  X86:                           False

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

Detailed results:
  Feature:                       SQL Compact Edition Runtime
  Status:                        Skipped
  MSI status:                    Passed
  Configuration status:          Passed

  Feature:                       Microsoft Sync Framework
  Status:                        Skipped
  MSI status:                    Passed
  Configuration status:          Passed

Rules with failures:

Global rules:

There are no scenario-specific rules.

Rules report file:               C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20100623_123902\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.Configuration.Sco.ScoException
    Message:
        Access to the path 'C:\Program Files\Microsoft SQL Server\100\License Terms\SQLServer2008R2_License_STD_1033.rtf' is denied.
    Data:
      WatsonData = License_STD.rtf
      DisableRetry = true
      DisableWatson = true
    Stack:
        at Microsoft.SqlServer.Configuration.Sco.SqlFile.CopyTo(String targetFileFullPath, Boolean bCopyAcl)
        at Microsoft.SqlServer.Configuration.SetupExtension.UpdateLicenseFile.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)
    Inner exception type: System.UnauthorizedAccessException
        Message:
                Access to the path 'C:\Program Files\Microsoft SQL Server\100\License Terms\SQLServer2008R2_License_STD_1033.rtf' is denied.
        Stack:
                at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)
                at System.IO.File.InternalCopy(String sourceFileName, String destFileName, Boolean overwrite)
                at Microsoft.SqlServer.Configuration.Sco.SqlFile.CopyTo(String targetFileFullPath, Boolean bCopyAcl)

Steve Richter on Wed, 23 Jun 2010 18:52:27


I have opened a support incident on this.

 

Alberto Morillo on Wed, 23 Jun 2010 18:58:49



Hello,

Please give full control access on the “C:\program files\Microsoft SQL” folder and subfolders to the Windows Account you are using to run SQL Server setup. Verify that even if you are logged in as an Administrator.

Hope this helps.

Regards,

Alberto Morillo
SQLCoffee.com

WisdomGuidedByExperience on Mon, 23 Aug 2010 20:34:58


I have opened a support incident on this.

 


Keep us posted because on 2010-08-23, I too am trying to upgrade from SQL Server 2008 Enterprise to SQL Server 2008 R2 Enterprise while logged in as Administrator and have encountered this error three times with no ability to work around it.  The environment is Windows Server 2003 R2 Enterprise 64-bit, fully patched through August 2010 "Patch Tuesday" via standard Microsoft Update process.

a.kazakov on Fri, 10 Sep 2010 11:16:33


Try to turn off UAC. I've got same problem and solved so.

EricShumEric on Wed, 02 Feb 2011 03:23:13


Just rename or delete that file, click the Retry that work!!!

Sir Crispalot on Wed, 23 Feb 2011 14:59:38


Just rename or delete that file, click the Retry that work!!!

I tried the accepted answer (setting the permissions on the SQL Server folder) but that didn't work.  I tried renaming the file and it did work!  Great tip Eric ;)

Chris

Anal Patel on Thu, 02 Feb 2012 18:02:05


Even Go to that path and just remove Read-only from properties and OK then retry also solve the issue.....

Magred on Mon, 23 Apr 2012 09:25:51


Hi,

We are upgrading our SQL Server database 2005 Sp2 to 2008 R2.
During the process of upgrade we are facing issues, "SQL Server 2008
R2 has completed with failures"

Detail:

2012-04-21 23:11:09 Slp: Error result: -2068119551
2012-04-21 23:11:09 Slp: Result facility code: 1211
2012-04-21 23:11:09 Slp: Result error code: 1
2012-04-21 23:11:09 Slp: Sco: Attempting to create base registry key HKEY_LOCAL_MACHINE, machine
2012-04-21 23:11:09 Slp: Sco: Attempting to open registry subkey
2012-04-21 23:11:09 Slp: Sco: Attempting to open registry subkey Software\Microsoft\PCHealth\ErrorReporting\DW\Installed
2012-04-21 23:11:09 Slp: Sco: Attempting to get registry value DW0201
2012-04-21 23:12:04 Slp: Submitted 1 of 1 failures to the Watson data repository

Please suggest.

Regards,

Mag


Crakdkorn on Sun, 24 Jun 2012 16:44:14


Looks like not just the C:\Program Files\Microsoft SQL Server folder requires the full permissions.   I have the same error up and it references:

"Failed to compile C:\Program Files (x86)\Microsoft SQL Server\110\Tools\Binn\DQ\link.exe becase of the following error:  The module was expected to contain an assembly manifest. (Exception from HRESULT: 0x80131018)."   This is in addition to another:

"Failed to compile C:\Program Files (x86)\Microsoft SQL Server\110\DTS\Binn\dtsinstall.exe Error code=0x800700d8"

Oddly, even after providing the permissions, I was unable to allow SQL to have access to those files (there were actually three errors before the installation locked.  However, I was allowed to continue installing and when reaching the end of the installation the only error was for the installation of the Distributed Replay Controller.   The log said to uninstall this feature and reinstall.  Given the permission fix above (thanks Alberto), the reboot and uninstall and reinstall of the Distributed Replay Controller worked without issue.

Bertrand Le Roy on Fri, 14 Dec 2012 06:08:08


I solved the problem by simply deleting that file. After that, I clicked retry and setup proceeded normally.

Samuel Saveca on Fri, 11 Sep 2015 15:59:07


Thank you Eric, i was frustrated since this morning, and you helped me with your post.... :)

HiteshKumar09 on Sat, 27 Feb 2016 07:40:30


worked for me also...

Thanks a lot

HiteshKumar09 on Sat, 27 Feb 2016 07:40:57


Just rename or delete that file, click the Retry that work!!!

worked for me also..thanks a lot