locked
Error when installing Microsoft SQL Server Management Studio Express on XP - An error occurred during the installation of assembly RRS feed

  • Question

  • I'm trying to install Microsoft SQL Server Management Studio Express on XP SP 3 but I'm getting the following error: 

    Error when installing Microsoft SQL Server Management Studio Express on XP - An error occurred during the installation of assembly 'Microsoft.SqlServer.msxml6_interop,Version="6.0.0.0",Culture="neutral",processorArchitecture="MSIL",PublicKeyToken="89845dcd8080cc91",FileVersion="6.0.0.0"'. Please refer to Help and Support for more information.

    Any help would be much appreciated!!

    Thanks!!




    • Edited by DBAUS Tuesday, July 2, 2013 2:56 PM
    Tuesday, July 2, 2013 2:54 PM

Answers

  • Hi ,

    If ur just installing SSMS 2005 express you need to install .net framework,and core XML first see the link.Go thru read me ,install instruction and system requirement

    http://www.microsoft.com/en-in/download/details.aspx?id=8961

    You can also install sql server 2005 Express edition from link and select client services to install management studio

    http://www.microsoft.com/en-in/download/details.aspx?id=21844

    edit: Can u post complete error message which u got before make sure u meet all requirements for installation


    Please mark this reply as the answer or vote as helpful, as appropriate, to make it useful for other readers


    Tuesday, July 2, 2013 4:01 PM
  • Is this complete log file ,i dont think so...please post complete log file.Also did u went through the link properly and read system requirements and prerequisites properly make sure you do.

    Please mark this reply as the answer or vote as helpful, as appropriate, to make it useful for other readers

    Tuesday, July 23, 2013 4:59 AM

All replies

  • Which version of sql you are trying to install....I guess its constraint error that u cannot install..but first please tell me SQL server version ur installing

    Please mark this reply as the answer or vote as helpful, as appropriate, to make it useful for other readers

    Tuesday, July 2, 2013 3:09 PM
  • Hi there,

    I have a version SQL Server 2005 installed on a VPN network and I'm trying to install a standalone version of Microsoft SQL Server Management Studio Express on my XP SP 3 notebook so I can write queries for that that server. I'm just wondering if I would have to install SQLerver 2005 on my notebook before installing  SQL Server Management Studio Express... 

    Tuesday, July 2, 2013 3:41 PM
  • I've tried a fresh install of SQL Server 2005 and it has managed to successfully install several components but it failed with the following error when installing MSSMS:

    An error occurred during the installation of assembly 'Microsoft.SqlServer.Instapi,Version="9.0.242.0",Culture="neutral",processorArchitecture="MSIL",PublicKeyToken="89845dcd8080cc91",FileVersion="9.0.1399.0"'. Please refer to Help and Support for more information. HRESULT:0x80070020

    Very frustrating....


    • Edited by DBAUS Tuesday, July 2, 2013 4:02 PM DBAUS
    Tuesday, July 2, 2013 4:00 PM
  • Hi ,

    If ur just installing SSMS 2005 express you need to install .net framework,and core XML first see the link.Go thru read me ,install instruction and system requirement

    http://www.microsoft.com/en-in/download/details.aspx?id=8961

    You can also install sql server 2005 Express edition from link and select client services to install management studio

    http://www.microsoft.com/en-in/download/details.aspx?id=21844

    edit: Can u post complete error message which u got before make sure u meet all requirements for installation


    Please mark this reply as the answer or vote as helpful, as appropriate, to make it useful for other readers


    Tuesday, July 2, 2013 4:01 PM
  • Microsoft SQL Server 2005 9.00.5000.00 
    ============================== 
    OS Version      : Microsoft Windows XP Professional Service Pack 3 (Build 2600) 
    Time            : Tue Jul 02 13:10:39 2013 
     
    TOSHIBA-720D6E7 : Microsoft Internet Information Services (IIS) is either not installed or is disabled. IIS is required by some SQL Server features.  Without IIS, some SQL Server features will not be available for installation. To install all SQL Server features, install IIS from Add or Remove Programs in Control Panel or enable the IIS service through the Control Panel if it is already installed, and then run SQL Server Setup again. For a list of features that depend on IIS, see Features Supported by Editions of SQL Server in Books Online.
    Machine         : TOSHIBA-720D6E7 
    Product         : Microsoft SQL Server Setup Support Files (English) 
    Product Version : 9.00.5000.00 
    Install         : Successful 
    Log File        : c:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0002_TOSHIBA-720D6E7_SQLSupport_1.log 
    -------------------------------------------------------------------------------- 
    Machine         : TOSHIBA-720D6E7 
    Product         : Microsoft SQL Server Native Client 
    Product Version : 9.00.5000.00 
    Install         : Successful 
    Log File        : c:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0002_TOSHIBA-720D6E7_SQLNCLI_1.log 
    -------------------------------------------------------------------------------- 
    Machine         : TOSHIBA-720D6E7
    Product         : SQL Server Management Studio Express
    Error           : An error occurred during the installation of assembly 'Microsoft.SqlServer.Instapi,Version="9.0.242.0",Culture="neutral",processorArchitecture="MSIL",PublicKeyToken="89845dcd8080cc91",FileVersion="9.0.1399.0"'. Please refer to Help and Support for more information. HRESULT: 0x80070020. 
    --------------------------------------------------------------------------------
    Machine         : TOSHIBA-720D6E7 
    Product         : Microsoft SQL Server Management Studio Express 
    Product Version : 9.00.5000.00 
    Install         : Failed 
    Log File        : c:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0002_TOSHIBA-720D6E7_SSMSEE_1.log 
    Last Action     : InstallFinalize 
    Error String    : An error occurred during the installation of assembly 'Microsoft.SqlServer.Instapi,Version="9.0.242.0",Culture="neutral",processorArchitecture="MSIL",PublicKeyToken="89845dcd8080cc91",FileVersion="9.0.1399.0"'. Please refer to Help and Support for more information. HRESULT: 0x80070020. assembly interface: IAssemblyCacheItem, function: Commit, component: {180F515D-F56C-40DD-9D71-CC532EA8E286} 
    Error Number    : 1935 
    -------------------------------------------------------------------------------- 
    Tuesday, July 2, 2013 4:38 PM
  • -------------------------------------------------------------------------------- 

    Machine         : TOSHIBA-720D6E7 
    Product         : Microsoft SQL Server Native Client 
    Product Version : 9.00.5000.00 
    Install         : Successful 
    Log File        : c:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0002_TOSHIBA-720D6E7_SQLNCLI_1.log 
    -------------------------------------------------------------------------------- 
    Machine         : TOSHIBA-720D6E7
    Product         : SQL Server Management Studio Express
    Error           : An error occurred during the installation of assembly 'Microsoft.SqlServer.Instapi,Version="9.0.242.0",Culture="neutral",processorArchitecture="MSIL",PublicKeyToken="89845dcd8080cc91",FileVersion="9.0.1399.0"'. Please refer to Help and Support for more information. HRESULT: 0x80070020. 
    --------------------------------------------------------------------------------

    Hi,

    9.00.5000.00  this corosponds to sql server SP4, With sql server version it seems SQL server SP4 i think ur doing wrong installation...in my prev post i have given u express edition download link download that and install it on ur machine.

    read system requirements clearly ...and then proceed make sure you meet the prerequisites


    Please mark this reply as the answer or vote as helpful, as appropriate, to make it useful for other readers

    Tuesday, July 2, 2013 5:35 PM
  • Hi there!!

    I've tried the installation from the link you provided (http://www.microsoft.com/en-in/download/details.aspx?id=21844) but I'm getting this error:

    Property(S): GPTSupport = 1
    Property(S): OLEAdvtSupport = 1
    Property(S): ShellAdvtSupport = 1
    Property(S): Intel = 6
    Property(S): PhysicalMemory = 2046
    Property(S): VirtualMemory = 2882
    Property(S): AdminUser = 1
    Property(S): LogonUser = Amandinha
    Property(S): UserSID = S-1-5-21-3522293235-3444969308-2462083946-1005
    Property(S): UserLanguageID = 1033
    Property(S): ComputerName = TOSHIBA-720D6E7
    Property(S): SystemLanguageID = 1033
    Property(S): ScreenX = 1280
    Property(S): ScreenY = 800
    Property(S): CaptionHeight = 26
    Property(S): BorderTop = 1
    Property(S): BorderSide = 1
    Property(S): TextHeight = 16
    Property(S): TextInternalLeading = 3
    Property(S): ColorBits = 32
    Property(S): TTCSupport = 1
    Property(S): Time = 12:24:20
    Property(S): Date = 7/22/2013
    Property(S): MsiNetAssemblySupport = 2.0.50727.3053
    Property(S): MsiWin32AssemblySupport = 5.1.2600.5512
    Property(S): RedirectedDllSupport = 2
    Property(S): Privileged = 1
    Property(S): USERNAME = Amandinha
    Property(S): DATABASE = c:\WINDOWS\Installer\3d4b694.msi
    Property(S): OriginalDatabase = c:\e8bb0d568e5080f346\Setup\SqlSupport.msi
    Property(S): UILevel = 2
    Property(S): Preselected = 1
    Property(S): ACTION = INSTALL
    Property(S): ROOTDRIVE = c:\
    Property(S): CostingComplete = 1
    Property(S): OutOfDiskSpace = 0
    Property(S): OutOfNoRbDiskSpace = 0
    Property(S): PrimaryVolumeSpaceAvailable = 0
    Property(S): PrimaryVolumeSpaceRequired = 0
    Property(S): PrimaryVolumeSpaceRemaining = 0
    Property(S): INSTALLLEVEL = 1
    Property(S): SOURCEDIR = c:\e8bb0d568e5080f346\Setup\
    Property(S): SourcedirProduct = {53F5C3EE-05ED-4830-994B-50B2F0D50FCE}
    Property(S): InstallNgenTicks = 50000
    Property(S): ProductToBeRegistered = 1
    MSI (s) (F0:70) [12:24:20:796]: Note: 1: 1708 
    MSI (s) (F0:70) [12:24:20:796]: Product: Microsoft SQL Server Setup Support Files (English) -- Installation failed.

    MSI (s) (F0:70) [12:24:20:796]: Windows Installer installed the product. Product Name: Microsoft SQL Server Setup Support Files (English). Product Version: 9.00.1399.06. Product Language: 1033. Installation success or error status: 1603.

    MSI (s) (F0:70) [12:24:20:812]: Cleaning up uninstalled install packages, if any exist
    MSI (s) (F0:70) [12:24:20:812]: MainEngineThread is returning 1603
    MSI (s) (F0:44) [12:24:20:906]: No System Restore sequence number for this installation.
    === Logging stopped: 7/22/2013  12:24:20 ===
    MSI (s) (F0:44) [12:24:20:906]: User policy value 'DisableRollback' is 0
    MSI (s) (F0:44) [12:24:20:906]: Machine policy value 'DisableRollback' is 0
    MSI (s) (F0:44) [12:24:20:906]: Incrementing counter to disable shutdown. Counter after increment: 0
    MSI (s) (F0:44) [12:24:20:906]: Note: 1: 1402 2: HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\CurrentVersion\Installer\Rollback\Scripts 3: 2 
    MSI (s) (F0:44) [12:24:20:906]: Note: 1: 1402 2: HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\CurrentVersion\Installer\Rollback\Scripts 3: 2 
    MSI (s) (F0:44) [12:24:20:906]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied.  Counter after decrement: -1
    MSI (s) (F0:44) [12:24:20:921]: Restoring environment variables
    MSI (c) (70:A8) [12:24:20:921]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied.  Counter after decrement: -1
    MSI (c) (70:A8) [12:24:20:921]: MainEngineThread is returning 1603
    === Verbose logging stopped: 7/22/2013  12:24:20 ===

    Any clues??

    Thanks

    Monday, July 22, 2013 3:37 PM
  • Is this complete log file ,i dont think so...please post complete log file.Also did u went through the link properly and read system requirements and prerequisites properly make sure you do.

    Please mark this reply as the answer or vote as helpful, as appropriate, to make it useful for other readers

    Tuesday, July 23, 2013 4:59 AM