RTM version - SQL Express failed

RTM version - SQL Express failed

• Mehyar Yahfoufi

  Hi
  
  Sorry, I could not wait anymore so I did the brute-force method and deleted directories and registry keys manually as found in a post in this forum.
  
  Lets just say that I had a ghost of my machine before attempting...  But it went fine.
  
  
  

• The Omnipotent

  try removing it using:
  
  msiexec /x {982DB00A-9C4E-436B-8707-18E113BAA44C}
  msiexec /x {3BDB182E-8371-46BD-AC39-C14A91D5EEF8}
  

• MRoy

  Hi
  
  Have you looked for the short version of these guids, in the Installer\UserData\S-1-5-18\Products branch, the guids have no delimiters.
  
  i.e. 2AFFFDD7ED854A908C525DA9EBDC9B8F
  
  But since the products mentionned are SQL Express the uninstall tool should have been able to uninstall.
  
  Search the registry for the installation path of SQL Express, it should give you something.  All instances of MS SQL have a distinct install folder starting at MSQL, then being incremented like MSSQL.1, MSSQL.2.
  
  

• 虫豸

  Here's what I found while digging in the SQL Server log dir
  
  It seems there's something remaining of SQL Reporting Services, but it's not present in the add/remove programs.  How can I uninstall whatever is there
  
  -------------------------------------------------------------
  Running: PerformSCCAction2 at: 2005/10/3 10:10:1
  Loaded DLL:C:\WINDOWS\system32\msi.dll Version:3.1.4000.2435
  Product "{982DB00A-9C4E-436B-8707-18E113BAA44C}" versioned 9.00.1116 is not compatible with current builds of SQL Server.Expected at least version: 9.00.1399.06
  The Product Name is "Microsoft SQL Server 2005 Analysis Services CTP"
  Product "{3BDB182E-8371-46BD-AC39-C14A91D5EEF8}" versioned 9.00.1116 is not compatible with current builds of SQL Server.Expected at least version: 9.00.1399.06
  The Product Name is "Microsoft SQL Server 2005 Reporting Services CTP"
  Loaded DLL:C:\WINDOWS\system32\msi.dll Version:3.1.4000.2435
  Error: Action "PerformSCCAction2" threw an exception during execution.
  Return Code: 70032
  Message displayed to user
   SQL Server 2005 Setup has detected incompatible components from beta versions of Visual Studio, .NET Framework, or SQL Server 2005. Use Add or Remove Programs to remove these components, and then run SQL Server 2005 Setup again. For detailed instructions on uninstalling SQL Server 2005, see the SQL Server 2005 Readme.

  Delay load of action "UploadDrWatsonLogAction" returned nothing. No action will occur as a result.
  Message pump returning: 70032

  
  
  

• PaoloC05

  Thanks Maurice,
  
  That certainly helped - I can now clean up the registry and the install gets a lot further. However it still fails whilst trying to install the SQL Active Directory Helper saying I don't have the necessary permissions. I'm logged in as administrator so I don't think it can be a permissions issue. Any further ideas
  
  Regards
  
  
  Jon
  

• Murali Karlapudi

  Hi again
  
  I think the service control manager is taking a lock on the keys when the service is running.  Make sure you stop the service before attempting anything. 
  
  
  
  

• BambooZelD

  Hi
  
  If you dont have a HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Installer\UserData\S-1-5-18\Components\ key then I'm stumped.
  
  Have you tried VS2005 setup   If so then you should have a dd_vserror80.txt log which contains a more descriptive message.
  
  

• Chris Hampton

  Hi,
  
  I've got similar problems trying to install SQL Express RTM after removing Beta2 version.
  
  My installation log reports these errors:
  
  

  Product "{2AFFFDD7-ED85-4A90-8C52-5DA9EBDC9B8F}" versioned 9.00.1116 is not compatible with current builds of SQL Server.Expected at least version: 9.00.1399.06

  The Product Name is "Microsoft SQL Server 2005 Express Edition CTP"

  Product "{2750B389-A2D2-4953-99CA-27C1F2A8E6FD}" versioned 9.00.1116 is not compatible with current builds of SQL Server.Expected at least version: 9.00.1399.06

  The Product Name is "Microsoft SQL Server 2005 Tools Express Edition CTP"
  
  
  
  Clear enough but neither of the above keys is in my registry.
  
  How can I find/remove these references
  
  Thanks for your assistance
  
  
  Jon

  
  

• MikeAlister

  Thanks anyway Maurice,
  
  Just to keep the thread going, I think the problem may be with two registry keys:
  
  HKEY_LOCAL_MACHINE\SYSTEM\ControlSet001\Enum\Root\LEGACY_MSSQL$SQLEXPRESS
  
  HKEY_LOCAL_MACHINE\SYSTEM\ControlSet004\Enum\Root\LEGACY_MSSQL$SQLEXPRESS
  
  I get a message saying they can't be deleted.
  
  BTW I've just discovered that my site hoster is refusing to support SQL Express as it's " a desktop product". And if I want SQL it's going to double my monthly cost.
  
  So it's back to plain vanilla CSV files then.
  
  Regards
  
  
  Jon 
  
  
  

• dtb5571

  I tried  msiexec /x {982DB00A-9C4E-436B-8707-18E113BAA44C}
  And Get a weird Error
  
  
  Product: Microsoft SQL Server 2005 Analysis Services CTP -- Error 29628. The setup has encountered an unexpected error in datastore. The action is RestoreSetupParams. The error is :Failed to read property "InstallIds" {"MachineConfiguration", "", "FREEZE-XP"} from cache
   Unable to write property into cache: IsClustered
    Unable to write property into cache: "IsClustered"
     XmlRW Error: Failure loading xmlrw.dll
      CheckAllProcedures() returned: 2
  

  ANy

  
  

• Shasur

  I found the post, it was not from this forum after all...
  
  http://icelava.net/Forums/ShowPost.aspx PostID=1144
  
  This post was not for my problem specifically, but it inspired(...) me.  The values to look for if you're experiencing the same problem as I was are :
  
  A00BD289E4C9B6347870811E31AB4AC4
  E281BDB31738DB64CA931CA4195DEE8F 
  
  Also note that Reporting services and Analysis services were still installed as windows services.  I deleted them manually. ([HKEY_LOCAL_MACHINE\SYSTEM\ControlSet001\Enum\Root\LEGACY_MSSQLSERVEROLAPSERVICE] for example. but its also in ControlSet002).
  
  I found all this because in my case, I had sub directories called MSSQL.1 and MSSQL.2, so it was easy to find and delete from the registry. Also the instance was called MSSQLSERVER, another thing thats easy to find in the registry.
  
  Good luck.
  
  

• Mark Baird

  Do You remember what reg keys they were
  

• Adrian M

  Maurice,
  
  Thanks for replying.
  
  I don't have an Installer\UserData\S-1-5-18\Products node in my registry and searches for the GUIDS with or without braces proved fruitless.
  
  I tried to delete and MSQL and MSSQL keys and got rid of all I could find. I removed what SQL progs. had been installed and the XML parser. I ran the Windows Installer cleanup to remove all SQL installs. I cleaned my registry and turned to Seattle to pray ( well not this last bit).
  
  Anyhoo, I downloaded the SQL Express package again and re-ran it. I think it got further but eventually failed. Looking at the log, this is the key passage:
  
  

  Running: InstallSqlAction at: 2005/10/11 16:26:17
  Installing: sql on target: SONYPCGFX401
  Failed to install package
  Fatal error during installation.
  Setting package return code to: 28086
  Complete: InstallSqlAction at: 2005/10/11 16:26:39, returned false
  Error: Action "InstallSqlAction" failed during execution. Error information reported during run:
  Target collection includes the local machine.
  Invoking installPackage() on local machine
  
  I got a message about choosing a unique instance name for my installation but no suggestion as to how to do this.
  
  Googling for the 28086  error suggests I'm not alone with this problem but so far no-one seems to have posted a solution.
  
  I'll save the rant for another time but any further help would be much appreciated.
  
  Regards
  
  
  Jon

  
  
• RTM version - SQL Express failed