locked
System.DirectoryServices FileNotFoundException when installing SQL Express 2008 R2 RRS feed

  • Question

  • Using the web platform installer and manual downloads, SQL install fails with the following error. I have tried reinstalling .net framework on my windows 7 64-bit machine under Turn windows features on or off and haven't had any luck repairing the framework.

    Exception type: System.IO.FileNotFoundException
        Message:
            Could not load file or assembly 'System.DirectoryServices, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The system cannot find the file specified.
        Data:
          DisableWatson = true
        Stack:
            at Microsoft.SqlServer.Configuration.Sco.User..ctor(ServiceContainer ctx, String userName)
            at Microsoft.SqlServer.Configuration.SqlEngine.InputValidator.ValidateServiceAccount(String sqlAccount, SqlSecureString sqlPassword, String sqlDomainGroup, ConfigActionScenario scenario, Boolean isExpressSku)
            at Microsoft.SqlServer.Configuration.SqlEngine.InputValidator.ValidateServiceAccountForInstall()
            at Microsoft.SqlServer.Configuration.SqlEngine.InputValidator.ValidateInstallInput()
            at Microsoft.SqlServer.Configuration.SqlEngine.SqlEngineSetupPublic.ValidateSettings()
            at Microsoft.SqlServer.Configuration.SetupExtension.ValidateFeatureSettingsAction.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)

    Tuesday, December 28, 2010 7:53 AM

Answers

  • Hi Dave,

     

    Based on this error message, it might be the assembly System.DirectoryServices is lost from your GAC (Global Assembly Cache), so please go to C:\Windows\assembly to verify it is whether exists.

     

    If it not exists, we need register it back to GAC. Please follow the steps as below:

    1.       Copy file System.DirectoryServices.dll to a location which you have permission to access, for example, D:\Framework.

    ·         If the SQL Server is 32-bit, it would be: C:\Windows\Microsoft.NET\Framework\v2.0.50727.

    ·         If the SQL Server is 64-bit, it would be: C:\Windows\Microsoft.NET\Framework64\v2.0.50727.

    2.       Use gacutil.exe to register this file to GAC in command prompt, here is an example:
    gacutil  /i  D:\Framework\System.DirectoryServices.dll

     

    In addition, please make sure that you have the administrator privileges on the computer when running the Web Platform Installer.

     

    Reference:

    http://msdn.microsoft.com/en-us/library/ex0ss12c(VS.80).aspx(Global Assembly Cache Tool (Gacutil.exe))

     

    Please feel free to ask if you have any questions.

     

    Thanks,
    Weilin Qiao


    Please remember to mark the replies as answers if they help and unmark them if they provide no help. This can be beneficial to other community members reading the thread.
    • Marked as answer by WeiLin Qiao Wednesday, January 5, 2011 8:11 AM
    Thursday, December 30, 2010 4:55 AM

All replies

  • Using the web platform installer and manual downloads, SQL install fails with the following error. I posted this here rather than in the sql forum because I have tried reinstalling .net framework on my windows 7 64-bit machine under Turn windows features on or off and haven't had any luck repairing the framework.

    Exception type: System.IO.FileNotFoundException
        Message:
            Could not load file or assembly 'System.DirectoryServices, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The system cannot find the file specified.
        Data:
          DisableWatson = true
        Stack:
            at Microsoft.SqlServer.Configuration.Sco.User..ctor(ServiceContainer ctx, String userName)
            at Microsoft.SqlServer.Configuration.SqlEngine.InputValidator.ValidateServiceAccount(String sqlAccount, SqlSecureString sqlPassword, String sqlDomainGroup, ConfigActionScenario scenario, Boolean isExpressSku)
            at Microsoft.SqlServer.Configuration.SqlEngine.InputValidator.ValidateServiceAccountForInstall()
            at Microsoft.SqlServer.Configuration.SqlEngine.InputValidator.ValidateInstallInput()
            at Microsoft.SqlServer.Configuration.SqlEngine.SqlEngineSetupPublic.ValidateSettings()
            at Microsoft.SqlServer.Configuration.SetupExtension.ValidateFeatureSettingsAction.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)

    • Moved by Arthur Xie Thursday, December 30, 2010 4:48 AM SQL S E insatllation issuue (From:Windows 7 Miscellaneous)
    • Merged by WeiLin Qiao Thursday, December 30, 2010 4:54 AM
    Tuesday, December 28, 2010 7:51 AM
  • Exception type: System.IO.FileNotFoundException
        Message:
            Could not load file or assembly 'System.DirectoryServices, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The system cannot find the file specified.
    ctionInvocation.ExecuteActionHelper(TextWriter statusStream, ISequencedAction actionToRun)

    This message means that the DLL: "C:\Windows\Microsoft.NET\Framework\v2.0.50727\System.DirectoryServices.dll" is not found.

    This file is a Windows DLL which belongs to .net Framework 2.0. Maybe the DLL is damaged or completely missing.

    Please start the command prompt (cmd.exe) with admin right s [1] and run sfc [2]:

    sfc.exe /scannow

    Is it able to find and repair broken files?Does the setup work now?

    If not, extract the DLL from your DVD [3] and store the DLL into the folder C:\Windows\Microsoft.NET\Framework\v2.0.50727\. If this doesn't work, extract the 64Bit version of the DLL from the DVD to this folder: C:\Windows\Microsoft.NET\Framework64\v2.0.50727\.

    best regards
    André

    [1] http://windows.microsoft.com/en-US/windows7/How-do-I-run-an-application-once-with-a-full-administrator-access-token
    [2] http://support.microsoft.com/kb/929833
    [3] http://blog.nirsoft.net/2009/09/17/how-to-extract-missing-system-files-from-the-dvd-of-windows-7vista/


    "A programmer is just a tool which converts caffeine into code" CLIP- Stellvertreter http://www.winvistaside.de/
    Tuesday, December 28, 2010 12:50 PM
  • I copied the System.DirectoryServices.dll from a known working Windows 7 64-bit computer from both the 32 and 64 bit directories with no luck.  sfc /scannow at an elevated command prompt fails

    "Windows Resource Protection found corrupt files but was unable to fix some of them. Details are included in the CBS.log windir\Logs\CBS\CBS.log"



    Wednesday, December 29, 2010 1:53 AM
  • I have a attached part of the CBS.log file which may be of interest but I have copied all of the valid files from a working Windows 7 64bit machine. Please keep in mind that I do not have a windows 7 dvd because this computer was bought directly from the store and it didn't come with it, nor have I been able to find an i386 directory anywhere on the disk.

     

    2010-12-28 20:13:21, Info                  CSI    000001c6 [SR] Verify complete
    2010-12-28 20:13:22, Info                  CSI    000001c7 [SR] Verifying 100 (0x0000000000000064) components
    2010-12-28 20:13:22, Info                  CSI    000001c8 [SR] Beginning Verify and Repair transaction
    2010-12-28 20:13:25, Info                  CSI    000001c9 [SR] Cannot repair member file [l:34{17}]"System.Design.dll" of System.Design, Version = 6.1.7600.16385, pA = PROCESSOR_ARCHITECTURE_MSIL (8), Culture neutral, VersionScope neutral, PublicKeyToken = {l:8 b:b03f5f7f11d50a3a}, Type neutral, TypeName neutral, PublicKey neutral in the store, file is missing
    2010-12-28 20:13:25, Info                  CSI    000001ca [SR] Cannot repair member file [l:34{17}]"System.Design.dll" of System.Design, Version = 6.1.7600.16385, pA = PROCESSOR_ARCHITECTURE_MSIL (8), Culture neutral, VersionScope neutral, PublicKeyToken = {l:8 b:b03f5f7f11d50a3a}, Type neutral, TypeName neutral, PublicKey neutral in the store, file is missing
    2010-12-28 20:13:25, Info                  CSI    000001cb [SR] This component was referenced by [l:202{101}]"Microsoft-Windows-Foundation-Package~31bf3856ad364e35~amd64~~6.1.7600.16385.WindowsFoundationDelivery"
    2010-12-28 20:13:25, Info                  CSI    000001cc Repair results created:
    POQ 77 starts:
     
    POQ 77 ends.
    2010-12-28 20:13:25, Info                  CSI    000001cd [SR] Verify complete
    2010-12-28 20:13:25, Info                  CSI    000001ce [SR] Verifying 100 (0x0000000000000064) components
    2010-12-28 20:13:25, Info                  CSI    000001cf [SR] Beginning Verify and Repair transaction
    2010-12-28 20:13:25, Info                  CSI    000001d0 [SR] Cannot repair member file [l:56{28}]"System.DirectoryServices.dll" of System.DirectoryServices, Version = 6.1.7600.16385, pA = PROCESSOR_ARCHITECTURE_MSIL (8), Culture neutral, VersionScope neutral, PublicKeyToken = {l:8 b:b03f5f7f11d50a3a}, Type neutral, TypeName neutral, PublicKey neutral in the store, file is missing
    2010-12-28 20:13:30, Info                  CSI    000001d1 [SR] Cannot repair member file [l:56{28}]"System.DirectoryServices.dll" of System.DirectoryServices, Version = 6.1.7600.16385, pA = PROCESSOR_ARCHITECTURE_MSIL (8), Culture neutral, VersionScope neutral, PublicKeyToken = {l:8 b:b03f5f7f11d50a3a}, Type neutral, TypeName neutral, PublicKey neutral in the store, file is missing
    2010-12-28 20:13:30, Info                  CSI    000001d2 [SR] This component was referenced by [l:202{101}]"Microsoft-Windows-Foundation-Package~31bf3856ad364e35~amd64~~6.1.7600.16385.WindowsFoundationDelivery"
    2010-12-28 20:13:31, Info                  CSI    000001d3 Repair results created:
    POQ 78 starts:
     
    POQ 78 ends.
    2010-12-28 20:13:31, Info                  CSI    000001d4 [SR] Verify complete
    2010-12-28 20:13:31, Info                  CSI    000001d5 [SR] Verifying 100 (0x0000000000000064) components
    2010-12-28 20:13:31, Info                  CSI    000001d6 [SR] Beginning Verify and Repair transaction
    2010-12-28 20:13:45, Info                  CSI    000001d7 Ignoring duplicate ownership for directory [l:126{63}]"\??\C:\ProgramData\Microsoft\Windows NT\MSFax\Common Coverpages" in component Microsoft-Windows-Fax-Common, Version = 6.1.7600.16385, pA = PROCESSOR_ARCHITECTURE_IA32_ON_WIN64 (10), Culture neutral, VersionScope = 1 nonSxS, PublicKeyToken = {l:8 b:31bf3856ad364e35}, Type neutral, TypeName neutral, PublicKey neutral

    Wednesday, December 29, 2010 2:02 AM
  • The file System.Design.dll is also missing.

    Run an InPlace Upgrade [1][2] to repair your windows. Your programs are still usable after doing the InPlace upgrade. This should repair all missing files.

    Now try to install the SQL Server 2008 R2 again.

    André

    [1] http://support.microsoft.com/kb/2255099
    [2] http://www.sevenforums.com/tutorials/3413-repair-install.html


    "A programmer is just a tool which converts caffeine into code" CLIP- Stellvertreter http://www.winvistaside.de/
    Wednesday, December 29, 2010 12:50 PM
  • Is it possible to do an in place upgrade using a service pack or something? Maybe if I download Windows 7 SP1 RC1? I don't have a windows 7 DVD
    Wednesday, December 29, 2010 11:43 PM
  • Hi,

    This topic should be discussed in SQL forum. There is a forum specially for SQL server installation.

    Welcome and Tips for using this Forum


    Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread. ”
    Thursday, December 30, 2010 4:45 AM
  • Hi Dave,

     

    Based on this error message, it might be the assembly System.DirectoryServices is lost from your GAC (Global Assembly Cache), so please go to C:\Windows\assembly to verify it is whether exists.

     

    If it not exists, we need register it back to GAC. Please follow the steps as below:

    1.       Copy file System.DirectoryServices.dll to a location which you have permission to access, for example, D:\Framework.

    ·         If the SQL Server is 32-bit, it would be: C:\Windows\Microsoft.NET\Framework\v2.0.50727.

    ·         If the SQL Server is 64-bit, it would be: C:\Windows\Microsoft.NET\Framework64\v2.0.50727.

    2.       Use gacutil.exe to register this file to GAC in command prompt, here is an example:
    gacutil  /i  D:\Framework\System.DirectoryServices.dll

     

    In addition, please make sure that you have the administrator privileges on the computer when running the Web Platform Installer.

     

    Reference:

    http://msdn.microsoft.com/en-us/library/ex0ss12c(VS.80).aspx(Global Assembly Cache Tool (Gacutil.exe))

     

    Please feel free to ask if you have any questions.

     

    Thanks,
    Weilin Qiao


    Please remember to mark the replies as answers if they help and unmark them if they provide no help. This can be beneficial to other community members reading the thread.
    • Marked as answer by WeiLin Qiao Wednesday, January 5, 2011 8:11 AM
    Thursday, December 30, 2010 4:55 AM
  • I don't have a windows 7 DVD
    Here are the Windows 7 Prof (x64) ISO link:

    http://msft-dnl.digitalrivercontent.net/msvista/pub/X15-65805/X15-65805.iso

    "A programmer is just a tool which converts caffeine into code" CLIP- Stellvertreter http://www.winvistaside.de/
    Thursday, December 30, 2010 2:02 PM