none
sql server 2008 version upgrade failed access to path is denied

    Question

  • 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
     

    Tuesday, June 22, 2010 10:12 PM

Answers

All replies

  • 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

    Tuesday, June 22, 2010 10:45 PM
  • 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

     

     

     

     

     

     

    Tuesday, June 22, 2010 10:52 PM
  • 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

    Wednesday, June 23, 2010 11:33 AM
  • 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

    Wednesday, June 23, 2010 4:56 PM
  • 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)

    Wednesday, June 23, 2010 5:10 PM
  • I have opened a support incident on this.

     

    Wednesday, June 23, 2010 6:52 PM

  • 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

    Wednesday, June 23, 2010 6:58 PM
  • 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.
    If you think development is tough now, try doing it on punched cards :-)
    • Proposed as answer by a.kazakov Friday, September 10, 2010 10:57 AM
    Monday, August 23, 2010 8:34 PM
  • Try to turn off UAC. I've got same problem and solved so.
    Friday, September 10, 2010 11:16 AM
  • Just rename or delete that file, click the Retry that work!!!
    Wednesday, February 02, 2011 3:23 AM
  • 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

    Wednesday, February 23, 2011 2:59 PM
  • Even Go to that path and just remove Read-only from properties and OK then retry also solve the issue.....
    Thursday, February 02, 2012 6:02 PM
  • 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


    Monday, April 23, 2012 9:25 AM
  • 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.


    R, J

    Sunday, June 24, 2012 4:44 PM
  • I solved the problem by simply deleting that file. After that, I clicked retry and setup proceeded normally.
    Friday, December 14, 2012 6:08 AM