SQL Server 2008 Developer Installation on Vista x64 Ultimate

Question

Hello,
 

I recently got Server 2008 Developer for testing purposes, and am trying to install it on my Vista x64 Ultimate machine. I previously had SQL Server 2005 which I removed.

When I run the install, I get al the way to where it says: Install_sql_bids_Cpu64_Action: Write_NativeImage_64. Generating Native Images

However, it has been sitting there for over 4 hours. I've canceled out before, and tried to uninstall the installed components, but the uninstall doesn't work either (can't rollback to 2005 because the Native Client doesn't remove properly).

There is activity from the setup100.exe process that is running. Occassionally I'll see it do something on the cpu (0 to 5) but the installation doesn't progress.

Any help would be wonderful. The removal of 2005 was nasty, had to manually delete directories and the uninstall didn't progress properly either.

Answer 1

Hi,

You have sqlncli.msi in ...\Servers\Setup\ folder .

Could you to try to re-install Sql server native client first ? Command is as follows :

sqlncli.msi REINSTALL=ALL REINSTALLMODE=OMUS /QB

HTH

---

Prashant [MSFT] -- This posting is provided "AS IS" with no warranties, and confers no rights.

Answer 2

The reinstall of the SQL Native Client seemed to go fine. I received no errors, and there's no log file to see unfortunately. Should I re-attempt installation, or removal at this point?

Thanks

Answer 3

Yeah, go ahead and try re-installation.

Good Luck !

---

Prashant [MSFT] -- This posting is provided "AS IS" with no warranties, and confers no rights.

Answer 4

I restarted the install, and its been running for about 4 hours now.

Seems to just stop at the generating native images section.

Answer 5

Can you post the log files ?

---

Prashant [MSFT] -- This posting is provided "AS IS" with no warranties, and confers no rights.

Answer 6

Here's the last parts of the Detail.log. I'm not seeing any errors. It just seems that its taking forever to run.


2009-01-22 09:04:40 Slp: Completed Action: ScheduleUpgradePackageInstallActionsAction, returned True
2009-01-22 09:04:40 Slp: ----------------------------------------------------------------------
2009-01-22 09:04:40 Slp: Running Action: NotifyProgressCountDisplay
2009-01-22 09:04:40 Slp: Completed Action: NotifyProgressCountDisplay, returned True
2009-01-22 09:04:41 Slp: ----------------------------------------------------------------------
2009-01-22 09:04:41 Slp: Running Action: ScheduleConfigAction
2009-01-22 09:04:41 Slp: Completed Action: ScheduleConfigAction, returned True
2009-01-22 09:04:42 Slp: ----------------------------------------------------------------------
2009-01-22 09:04:42 Slp: Running Action: ValidationTimingConfigAction
2009-01-22 09:04:42 Slp: Completed Action: ValidationTimingConfigAction, returned True
2009-01-22 09:04:42 Slp: ----------------------------------------------------------------------
2009-01-22 09:04:42 Slp: Running Action: SaveConfigurationFile
2009-01-22 09:04:42 Slp: Completed Action: SaveConfigurationFile, returned True
2009-01-22 09:04:42 Slp: ----------------------------------------------------------------------
2009-01-22 09:04:42 Slp: Running Action: PreMsiTimingConfigAction
2009-01-22 09:04:42 Slp: Completed Action: PreMsiTimingConfigAction, returned True
2009-01-22 09:04:42 Slp: ----------------------------------------------------------------------
2009-01-22 09:04:42 Slp: Running Action: InitializeMsiAction
2009-01-22 09:04:42 Slp: Attempting to pause the 32 bit ngen queue for x64
2009-01-22 09:04:42 Slp: ngen command to be used from .Net Framework Directory: C:\Windows\Microsoft.Net\Framework\v2.0.50727
2009-01-22 09:04:43 Slp: Microsoft (R) CLR Native Image Generator - Version 2.0.50727.3053
2009-01-22 09:04:43 Slp: Copyright (c) Microsoft Corporation.  All rights reserved.
2009-01-22 09:04:44 Slp: The .NET Runtime Optimization Service is started and paused.
2009-01-22 09:04:44 Slp: Attempting to pause the 64 bit ngen queue
2009-01-22 09:04:44 Slp: ngen command to be used from .Net Framework Directory: C:\Windows\Microsoft.Net\Framework64\v2.0.50727
2009-01-22 09:04:45 Slp: Microsoft (R) CLR Native Image Generator - Version 2.0.50727.3053
2009-01-22 09:04:45 Slp: Copyright (c) Microsoft Corporation.  All rights reserved.
2009-01-22 09:04:46 Slp: The .NET Runtime Optimization Service is started and paused.
2009-01-22 09:04:46 Slp: Completed Action: InitializeMsiAction, returned True
2009-01-22 09:04:46 Slp: ----------------------------------------------------------------------
2009-01-22 09:04:46 Slp: Running Action: MsiTimingAction
2009-01-22 09:04:46 Slp: ----------------------------------------------------------------------
2009-01-22 09:04:46 Slp: Running Action: Install_sql_common_core_Cpu64_Action
2009-01-22 09:04:46 Slp: Target package: "F:\x64\setup\sql_common_core_msi\sql_common_core.msi"
2009-01-22 09:05:02 Slp: InstallPackage: MsiInstallProduct returned the result code 0.
2009-01-22 09:05:02 Slp: RunMsiCore succeeded.
2009-01-22 09:05:02 Slp: Checkpoint: INSTALL_SQL_COMMON_CORE_CPU64_ACTION
2009-01-22 09:05:02 Slp: Completed Action: Install_sql_common_core_Cpu64_Action, returned True
2009-01-22 09:05:02 Slp: ----------------------------------------------------------------------
2009-01-22 09:05:02 Slp: Running Action: Install_sql_common_core_loc_Cpu64_1033_Action
2009-01-22 09:05:02 Slp: Target package: "F:\x64\setup\sql_common_core_loc_msi\1033\sql_common_core_loc.msi"
2009-01-22 09:05:06 Slp: InstallPackage: MsiInstallProduct returned the result code 0.
2009-01-22 09:05:06 Slp: RunMsiCore succeeded.
2009-01-22 09:05:06 Slp: Checkpoint: INSTALL_SQL_COMMON_CORE_LOC_CPU64_1033_ACTION
2009-01-22 09:05:06 Slp: Completed Action: Install_sql_common_core_loc_Cpu64_1033_Action, returned True
2009-01-22 09:05:06 Slp: ----------------------------------------------------------------------
2009-01-22 09:05:06 Slp: Running Action: Install_sqlncli_Cpu64_Action
2009-01-22 09:05:06 Slp: Target package: "F:\x64\setup\x64\sqlncli.msi"
2009-01-22 09:05:12 Slp: InstallPackage: MsiInstallProduct returned the result code 0.
2009-01-22 09:05:12 Slp: RunMsiCore succeeded.
2009-01-22 09:05:12 Slp: Checkpoint: INSTALL_SQLNCLI_CPU64_ACTION
2009-01-22 09:05:12 Slp: Completed Action: Install_sqlncli_Cpu64_Action, returned True
2009-01-22 09:05:12 Slp: ----------------------------------------------------------------------
2009-01-22 09:05:12 Slp: Running Action: Install_sql_engine_core_shared_Cpu64_Action
2009-01-22 09:05:12 Slp: Target package: "F:\x64\setup\sql_engine_core_shared_msi\sql_engine_core_shared.msi"
2009-01-22 09:05:43 Slp: InstallPackage: MsiInstallProduct returned the result code 0.
2009-01-22 09:05:43 Slp: RunMsiCore succeeded.
2009-01-22 09:05:43 Slp: Checkpoint: INSTALL_SQL_ENGINE_CORE_SHARED_CPU64_ACTION
2009-01-22 09:05:43 Slp: Completed Action: Install_sql_engine_core_shared_Cpu64_Action, returned True
2009-01-22 09:05:43 Slp: ----------------------------------------------------------------------
2009-01-22 09:05:43 Slp: Running Action: Install_sql_engine_core_shared_loc_Cpu64_1033_Action
2009-01-22 09:05:43 Slp: Target package: "F:\x64\setup\sql_engine_core_shared_loc_msi\1033\sql_engine_core_shared_loc.msi"
2009-01-22 09:05:49 Slp: InstallPackage: MsiInstallProduct returned the result code 0.
2009-01-22 09:05:49 Slp: RunMsiCore succeeded.
2009-01-22 09:05:49 Slp: Checkpoint: INSTALL_SQL_ENGINE_CORE_SHARED_LOC_CPU64_1033_ACTION
2009-01-22 09:05:49 Slp: Completed Action: Install_sql_engine_core_shared_loc_Cpu64_1033_Action, returned True
2009-01-22 09:05:49 Slp: ----------------------------------------------------------------------
2009-01-22 09:05:49 Slp: Running Action: Install_SSCESqlWbTools_Cpu32_Action
2009-01-22 09:05:49 Slp: Target package: "F:\x64\setup\SSCESqlWbTools.msi"
2009-01-22 09:05:51 Slp: InstallPackage: MsiInstallProduct returned the result code 0.
2009-01-22 09:05:51 Slp: RunMsiCore succeeded.
2009-01-22 09:05:51 Slp: Checkpoint: INSTALL_SSCESQLWBTOOLS_CPU32_ACTION
2009-01-22 09:05:51 Slp: Completed Action: Install_SSCESqlWbTools_Cpu32_Action, returned True
2009-01-22 09:05:51 Slp: ----------------------------------------------------------------------
2009-01-22 09:05:51 Slp: Running Action: Install_SqlWriter_Cpu64_Action
2009-01-22 09:05:52 Slp: Target package: "F:\x64\setup\x64\SqlWriter.msi"
2009-01-22 09:06:01 Slp: InstallPackage: MsiInstallProduct returned the result code 0.
2009-01-22 09:06:01 Slp: RunMsiCore succeeded.
2009-01-22 09:06:01 Slp: Checkpoint: INSTALL_SQLWRITER_CPU64_ACTION
2009-01-22 09:06:01 Slp: Completed Action: Install_SqlWriter_Cpu64_Action, returned True
2009-01-22 09:06:01 Slp: ----------------------------------------------------------------------
2009-01-22 09:06:01 Slp: Running Action: Install_BOL_Cpu32_Action
2009-01-22 09:06:01 Slp: Target package: "F:\x64\setup\SqlServer2008_BOL.msi"
2009-01-22 09:07:46 Slp: InstallPackage: MsiInstallProduct returned the result code 0.
2009-01-22 09:07:46 Slp: RunMsiCore succeeded.
2009-01-22 09:07:46 Slp: Checkpoint: INSTALL_BOL_CPU32_ACTION
2009-01-22 09:07:46 Slp: Completed Action: Install_BOL_Cpu32_Action, returned True
2009-01-22 09:07:46 Slp: ----------------------------------------------------------------------
2009-01-22 09:07:46 Slp: Running Action: Install_BestPracticesPolicies_Cpu32_Action
2009-01-22 09:07:46 Slp: Target package: "F:\x64\setup\SQLServerBestPracticesPolicies.msi"
2009-01-22 09:07:49 Slp: InstallPackage: MsiInstallProduct returned the result code 0.
2009-01-22 09:07:49 Slp: RunMsiCore succeeded.
2009-01-22 09:07:49 Slp: Checkpoint: INSTALL_BESTPRACTICESPOLICIES_CPU32_ACTION
2009-01-22 09:07:49 Slp: Completed Action: Install_BestPracticesPolicies_Cpu32_Action, returned True
2009-01-22 09:07:49 Slp: ----------------------------------------------------------------------
2009-01-22 09:07:49 Slp: Running Action: Install_SqlBrowser_Cpu32_Action
2009-01-22 09:07:49 Slp: Target package: "F:\x64\setup\sqlbrowser.msi"
2009-01-22 09:07:54 Slp: InstallPackage: MsiInstallProduct returned the result code 0.
2009-01-22 09:07:54 Slp: RunMsiCore succeeded.
2009-01-22 09:07:54 Slp: Checkpoint: INSTALL_SQLBROWSER_CPU32_ACTION
2009-01-22 09:07:54 Slp: Completed Action: Install_SqlBrowser_Cpu32_Action, returned True
2009-01-22 09:07:54 Slp: ----------------------------------------------------------------------
2009-01-22 09:07:54 Slp: Running Action: Install_sql_engine_core_inst_Cpu64_Action
2009-01-22 09:07:54 Slp: Target package: "F:\x64\setup\sql_engine_core_inst_msi\sql_engine_core_inst.msi"
2009-01-22 09:08:34 Slp: InstallPackage: MsiInstallProduct returned the result code 0.
2009-01-22 09:08:34 Slp: RunMsiCore succeeded.
2009-01-22 09:08:34 Slp: Checkpoint: INSTALL_SQL_ENGINE_CORE_INST_CPU64_ACTION
2009-01-22 09:08:34 Slp: Completed Action: Install_sql_engine_core_inst_Cpu64_Action, returned True
2009-01-22 09:08:34 Slp: ----------------------------------------------------------------------
2009-01-22 09:08:34 Slp: Running Action: Install_sql_engine_core_inst_loc_Cpu64_1033_Action
2009-01-22 09:08:34 Slp: Target package: "F:\x64\setup\sql_engine_core_inst_loc_msi\1033\sql_engine_core_inst_loc.msi"
2009-01-22 09:08:44 Slp: InstallPackage: MsiInstallProduct returned the result code 0.
2009-01-22 09:08:44 Slp: RunMsiCore succeeded.
2009-01-22 09:08:44 Slp: Checkpoint: INSTALL_SQL_ENGINE_CORE_INST_LOC_CPU64_1033_ACTION
2009-01-22 09:08:44 Slp: Completed Action: Install_sql_engine_core_inst_loc_Cpu64_1033_Action, returned True
2009-01-22 09:08:44 Slp: ----------------------------------------------------------------------
2009-01-22 09:08:44 Slp: Running Action: Install_SSCRuntime_Cpu32_Action
2009-01-22 09:08:44 Slp: Target package: "F:\x64\setup\SSCERuntime.msi"
2009-01-22 09:08:48 Slp: InstallPackage: MsiInstallProduct returned the result code 0.
2009-01-22 09:08:48 Slp: RunMsiCore succeeded.
2009-01-22 09:08:48 Slp: Checkpoint: INSTALL_SSCRUNTIME_CPU32_ACTION
2009-01-22 09:08:48 Slp: Completed Action: Install_SSCRuntime_Cpu32_Action, returned True
2009-01-22 09:08:48 Slp: ----------------------------------------------------------------------
2009-01-22 09:08:48 Slp: Running Action: Install_sql_ssms_Cpu64_Action
2009-01-22 09:08:48 Slp: Target package: "F:\x64\setup\sql_ssms.msi"
2009-01-22 09:10:44 Slp: InstallPackage: MsiInstallProduct returned the result code 0.
2009-01-22 09:10:44 Slp: RunMsiCore succeeded.
2009-01-22 09:10:44 Slp: Checkpoint: INSTALL_SQL_SSMS_CPU64_ACTION
2009-01-22 09:10:44 Slp: Completed Action: Install_sql_ssms_Cpu64_Action, returned True
2009-01-22 09:10:44 Slp: ----------------------------------------------------------------------
2009-01-22 09:10:44 Slp: Running Action: Install_sql_tools_Cpu64_Action
2009-01-22 09:10:44 Slp: Target package: "F:\x64\setup\sql_tools.msi"
2009-01-22 09:11:26 Slp: InstallPackage: MsiInstallProduct returned the result code 0.
2009-01-22 09:11:26 Slp: RunMsiCore succeeded.
2009-01-22 09:11:26 Slp: Checkpoint: INSTALL_SQL_TOOLS_CPU64_ACTION
2009-01-22 09:11:26 Slp: Completed Action: Install_sql_tools_Cpu64_Action, returned True
2009-01-22 09:11:26 Slp: ----------------------------------------------------------------------
2009-01-22 09:11:26 Slp: Running Action: Install_sql_tools_loc_Cpu64_1033_Action
2009-01-22 09:11:26 Slp: Target package: "F:\x64\setup\1033\sql_tools_loc.msi"
2009-01-22 09:11:30 Slp: InstallPackage: MsiInstallProduct returned the result code 0.
2009-01-22 09:11:30 Slp: RunMsiCore succeeded.
2009-01-22 09:11:30 Slp: Checkpoint: INSTALL_SQL_TOOLS_LOC_CPU64_1033_ACTION
2009-01-22 09:11:30 Slp: Completed Action: Install_sql_tools_loc_Cpu64_1033_Action, returned True
2009-01-22 09:11:30 Slp: ----------------------------------------------------------------------
2009-01-22 09:11:30 Slp: Running Action: Install_sql_bids_Cpu64_Action
2009-01-22 09:11:30 Slp: Target package: "F:\x64\setup\sql_bids.msi"

Answer 7

Do you have Visual Studio 2008 already installed in a Non-default location ?

---

Prashant [MSFT] -- This posting is provided "AS IS" with no warranties, and confers no rights.

Answer 8

I apparently have 3 directories referencing VS 2008
c:\program files\Microsoft Visual Studio 9.0
c:\Program Files (x86)\Microsoft Visual Studio
c:\Program Files (x86)\Microsoft Visual Studio 9.0

The last one seems to be the installation location for Visual Studio because that's where my startup link is going.

Answer 9

 Hmmmm 

I hope we are not hitting this . Please run Procmon , apply filter to include msiexec.exe and setup.exe (to avoid noise of the events being captured by ProcMon) , Click on 'Capture Events' and simultaneously re-run the setup . The moment setup hangs , go to ProcMon , stop 'capture events' , save log in .csv , analyze. See if you get some 'Access denied' etc. Let us know the results.

---

Prashant [MSFT] -- This posting is provided "AS IS" with no warranties, and confers no rights.

Answer 10

I ran ProcMon and got a 1.2gb file for the SQL Install.

From what I can tell before I closed it, the process was hanging at Thread Start/Thread Exit.

I tried loading the file into Excel so I could cut/paste it, but it wouldn't load the whole thing.

Tell me what you need from the file, and I'll try to break it out somewhere.

Answer 11

Umm we need to shorten the procomon log. Can you capture events in ProcMon just few seconds before we are supposed to hit the 'hang' ?

---

Prashant [MSFT] -- This posting is provided "AS IS" with no warranties, and confers no rights.

Answer 12

I'm currently importing the file into Access, and then I'll just export the last 50 lines or so back to CSV or Flat File.

Answer 13

Ok, so the file wouldn't import into Access (and since I have no SQL there's that...lol) so I'm re-running the setup.

Answer 14

hmmmmm ok. Good luck this time :-)

---

Prashant [MSFT] -- This posting is provided "AS IS" with no warranties, and confers no rights.

Answer 15

 Ok, so I ran the setup again, in repair mode (because it's failed in the past), and this time it completed. However, I didn't get a lot of the tools (none of the management tools), and I couldn't run an Add from Add/Remove because it kept failing with error SKU. So now I'm in the process of uninstalling it, which of course is taking forever again, but at least it SEEMS to be doing something this time around.

I'm going to try the install again this weekend at home, so we'll see what it can do.

Answer 16

To install Tools only, run setup.exe from Disk 2 .

---

Prashant [MSFT] -- This posting is provided "AS IS" with no warranties, and confers no rights.

Answer 17

I have the DVD version, and don't see an option for that.

I also could not re-install the server, it kept hanging at that same spot again.

*sigh* I'm going to try one final time by logging into the local administrator account on the machine (I'm using my domain admin accnt currently) and try the install again and see what happens.

Answer 18

I'm trying to install SQL 2008 Express on Vista 64 bit and having no end of problems. I'm using the downloaded file SQLEXPRADV_x64_ENU. Seems no matter what I do it gets to a certain point (around 75%) and just hangs. Even trying to uninstall it fails with it hanging around 75%. The last part of my log shows:

2009-05-02 19:37:10 Slp: Running Action: Install_Synchronization_Cpu64_Action
2009-05-02 19:37:10 Slp: Target package: "{53D7A054-4598-4947-A159-E8FCC77720AB}"
2009-05-02 19:37:15 Slp: InstallPackage: MsiInstallProduct returned the result code 0.
2009-05-02 19:37:15 Slp: RunMsiCore succeeded.
2009-05-02 19:37:15 Slp: Checkpoint: INSTALL_SYNCHRONIZATION_CPU64_ACTION
2009-05-02 19:37:15 Slp: Completed Action: Install_Synchronization_Cpu64_Action, returned True
2009-05-02 19:37:15 Slp: ----------------------------------------------------------------------
2009-05-02 19:37:15 Slp: Running Action: Install_sql_ssms_Cpu64_Action
2009-05-02 19:37:15 Slp: Target package: "{108C8C1D-DA02-4A6C-94CD-5603F6A6FC72}"

I remember having an issue like this way back on XP installing .net framework 3. I couldn't even install that. Finally fixed it using some repair tool from MS (MS Cleanup Tool). Would using that possible work here or is that specifically for .net framework?

---

Dan

Answer 19

Did you ever resolve this Vista problem?  I have the exact same thing and it's endangering my project.