none
Trouble Installing SQL Server 2008 on Home Vista

    Question

  • Hi,
    I am trying to install the SQL Server 2008 that comes with my Vista computer. I went to the start menu -> all programs... Then the Microsoft SQL Server 2008 folder. I selected Configuration Tools subfolder and then "SQL Server Installation"

    From there I hit the installation button. Then it asks me to input an installation folder, and when I enter "C:\Program Files\MicrosoftSQLServer" it says "Not a valid installation folder." 

    No matter what folder I come up with it says it is invalid.  I did the test of I believe 14 things to see if your computer is ready for installation, and passed all the tests.

    So I'm stumped. I'd love to find out how to install this.

    Any help would be greatly appreciated.

    All the Best,
    Alex
    Saturday, January 17, 2009 7:06 AM

Answers

  • Hi Alex,

    I'm not sure which version "came with your computer", but I would imagine that it's SQL Express.  Try installing it from here instead - the wizard is much friendlier.

    Let us know how it works out!
    Aaron Alton | thehobt.blogspot.com
    Saturday, January 17, 2009 7:14 AM
    Moderator

All replies

  • Hi Alex,

    I'm not sure which version "came with your computer", but I would imagine that it's SQL Express.  Try installing it from here instead - the wizard is much friendlier.

    Let us know how it works out!
    Aaron Alton | thehobt.blogspot.com
    Saturday, January 17, 2009 7:14 AM
    Moderator
  • Thank you sir!  It seems to be installing as we speak!
    Saturday, January 17, 2009 7:21 AM
  • Great - I'm glad I could help.
    Aaron Alton | thehobt.blogspot.com
    Saturday, January 17, 2009 7:22 AM
    Moderator
  • Installing SQL Server Express 2008 is a total pain in the you know what.  How many hours was it churning away, only to end up having mysterious "errors".  Errors that really it doesn't explain with enough depth to be able to do anything about.  So then it just ends and says, "sorry, didn't install."  I'm not a fan of Microsoft's installers, but dang this one takes the cake!
    Saturday, January 17, 2009 10:08 AM
  • Can you post what the errors were?
    Aaron Alton | thehobt.blogspot.com
    Saturday, January 17, 2009 10:31 PM
    Moderator
  • Hi, I was installing it, and it got near the end.  and it said it could not install the............ let me think, crud.........  I think it was the last thing, maybe some SQL utilities or something....  Sorry but i forget the exact thing it said it was unsuccessful at installing :( 

    Then it said it was done, and couldn't complete the install. 

    Then I gave up.
    Sunday, January 18, 2009 3:50 AM
  • Well, if you are still looking to get it installed, have a look at Summary.txt, and post the relevant portions of it here.  Here is an article on MSDN that talks about finding and searching summary.txt:

    http://msdn.microsoft.com/en-us/library/ms143702.aspx

    HTH...
    Aaron Alton | thehobt.blogspot.com
    Sunday, January 18, 2009 4:06 AM
    Moderator
  • Overall summary:
      Final result:                  SQL Server installation failed. To continue, investigate the reason for the failure, correct the problem, uninstall SQL Server, and then rerun SQL Server Setup.
      Exit code (Decimal):           -2068643839
      Exit facility code:            1203
      Exit error code:               1
      Exit message:                  SQL Server installation failed. To continue, investigate the reason for the failure, correct the problem, uninstall SQL Server, and then rerun SQL Server Setup.
      Start time:                    2009-01-17 03:24:53
      End time:                      2009-01-17 04:35:55
      Requested action:              Install
      Log with failure:              C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20090117_031213\sql_ssms_Cpu32_1.log
      Exception help link:           http://go.microsoft.com/fwlink?LinkId=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=10.0.1600.22

    Machine Properties:
      Machine name:                  ALEX-PC
      Machine processor count:       2
      OS version:                    Windows Vista
      OS service pack:               
      OS region:                     United States
      OS language:                   English (United States)
      OS architecture:               x86
      Process architecture:          32 Bit
      OS clustered:                  No

    Product features discovered:
      Product              Instance             Instance ID                    Feature                                  Language             Edition              Version         Clustered
      Sql Server 2008      SQLEXPRESS           MSSQL10.SQLEXPRESS             Database Engine Services                 1033                 Express Edition      10.0.1600.22    No        
      Sql Server 2008      SQLEXPRESS           MSSQL10.SQLEXPRESS             SQL Server Replication                   1033                 Express Edition      10.0.1600.22    No        

    Package properties:
      Description:                   SQL Server Database Services 2008
      SQLProductFamilyCode:          {628F8F38-600E-493D-9946-F4178F20A8A9}
      ProductName:                   SQL2008
      Type:                          RTM
      Version:                       10
      SPLevel:                       0
      Installation location:         c:\32c3ebdc8e334cc67a543d\x86\setup\
      Installation edition:          EXPRESS_ADVANCED

    User Input Settings:
      ACTION:                        Install
      ADDCURRENTUSERASSQLADMIN:      False
      AGTSVCACCOUNT:                 NT AUTHORITY\NETWORK SERVICE
      AGTSVCPASSWORD:                *****
      AGTSVCSTARTUPTYPE:             Disabled
      ASBACKUPDIR:                   Backup
      ASCOLLATION:                   Latin1_General_CI_AS
      ASCONFIGDIR:                   Config
      ASDATADIR:                     Data
      ASDOMAINGROUP:                 <empty>
      ASLOGDIR:                      Log
      ASPROVIDERMSOLAP:              1
      ASSVCACCOUNT:                  <empty>
      ASSVCPASSWORD:                 *****
      ASSVCSTARTUPTYPE:              Automatic
      ASSYSADMINACCOUNTS:            <empty>
      ASTEMPDIR:                     Temp
      BROWSERSVCSTARTUPTYPE:         Disabled
      CONFIGURATIONFILE:             C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20090117_031213\ConfigurationFile.ini
      ENABLERANU:                    True
      ERRORREPORTING:                False
      FEATURES:                      SQLENGINE,REPLICATION,SSMS
      FILESTREAMLEVEL:               0
      FILESTREAMSHARENAME:           <empty>
      FTSVCACCOUNT:                  NT AUTHORITY\LOCAL SERVICE
      FTSVCPASSWORD:                 *****
      HELP:                          False
      INDICATEPROGRESS:              False
      INSTALLSHAREDDIR:              C:\Program Files\Microsoft SQL Server\
      INSTALLSHAREDWOWDIR:           C:\Program Files\Microsoft SQL Server\
      INSTALLSQLDATADIR:             <empty>
      INSTANCEDIR:                   C:\Program Files\Microsoft SQL Server\
      INSTANCEID:                    SQLExpress2
      INSTANCENAME:                  SQLEXPRESS2
      ISSVCACCOUNT:                  NT AUTHORITY\NetworkService
      ISSVCPASSWORD:                 *****
      ISSVCSTARTUPTYPE:              Automatic
      MEDIASOURCE:                   c:\32c3ebdc8e334cc67a543d\
      NPENABLED:                     0
      PID:                           *****
      QUIET:                         False
      QUIETSIMPLE:                   False
      RSINSTALLMODE:                 FilesOnlyMode
      RSSVCACCOUNT:                  <empty>
      RSSVCPASSWORD:                 *****
      RSSVCSTARTUPTYPE:              Automatic
      SAPWD:                         *****
      SECURITYMODE:                  <empty>
      SQLBACKUPDIR:                  <empty>
      SQLCOLLATION:                  SQL_Latin1_General_CP1_CI_AS
      SQLSVCACCOUNT:                 NT AUTHORITY\SYSTEM
      SQLSVCPASSWORD:                *****
      SQLSVCSTARTUPTYPE:             Automatic
      SQLSYSADMINACCOUNTS:           Alex-PC\Alex
      SQLTEMPDBDIR:                  <empty>
      SQLTEMPDBLOGDIR:               <empty>
      SQLUSERDBDIR:                  <empty>
      SQLUSERDBLOGDIR:               <empty>
      SQMREPORTING:                  False
      TCPENABLED:                    0
      X86:                           False

      Configuration file:            C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20090117_031213\ConfigurationFile.ini

    Detailed results:
      Feature:                       Database Engine Services
      Status:                        Passed
      MSI status:                    Passed
      Configuration status:          Passed

      Feature:                       SQL Server Replication
      Status:                        Passed
      MSI status:                    Passed
      Configuration status:          Passed

      Feature:                       Management Tools - Basic
      Status:                        Failed: see logs for details
      MSI status:                    Passed
      Configuration status:          Passed

    Rules with failures:

    Global rules:

    Scenario specific rules:

    Rules report file:               C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20090117_031213\SystemConfigurationCheck_Report.htm

    Sunday, January 18, 2009 4:11 AM
  • I didn't know what parts were relevant.  Can you point the way? 

    ...

    What I was referring to early were the Management Tools.  They failed to install.
    Sunday, January 18, 2009 4:11 AM
  • Have a look here for more detail: C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20090117_031213\SystemConfigurationCheck_Report.htm

    I would speculate that it's either having an issue with installing the MSXML6 parser, or with a previous (non-SP1) version of Visual Studio 2008, but if you post the SystemConfigurationCheck_Report we can see for sure.
    Aaron Alton | thehobt.blogspot.com
    Sunday, January 18, 2009 4:26 AM
    Moderator
  • I checked that page and it says everything passed, except a warning for windows firewall.  Also two not applicables for







    RS_DoesCatalogExist and
    RS_DoesCatalogTempDBExist
    Sunday, January 18, 2009 4:30 AM
  • Did you check the SSMS Log?

    C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20090117_031213\sql_ssms_Cpu32_1.log


    Aaron Alton | thehobt.blogspot.com
    Sunday, January 18, 2009 7:18 AM
    Moderator
  • It is 16 MB of .txt file.  What exactly should I be looking for in there?
    Sunday, January 18, 2009 10:59 AM
  • The Management Tools wouldn't install for me either, but when I selected 'Repair' I got a sensible error message; could not open ssceruntime-enu.msi.

    I went to the indicated directory, found ssceruntime.msi, and copied it to ssceruntime-enu.msi. The next Repair iteration was successful.

    Now I just need to Register it .....
    Tuesday, January 20, 2009 1:45 PM
  • How can I get to repair, do I have to run the install again?
    Wednesday, January 21, 2009 1:41 AM
  • You can do it through Add/Remove programs (Programs and Features on Vista).  Right Click on SQL Server 2008 > Uninstall/Change > Repair.

    Let us know how you fare!


    Aaron Alton | thehobt.blogspot.com
    Wednesday, January 21, 2009 1:55 AM
    Moderator
  • I could only find "Sql Server CLR Types" in my add/remove programs.  So I clicked repair for that.

    Then I got this message:

    "The feature you are trying to use is on a network resource that is unavailable.

    Click OK to try again, or enter an alternate path... to SQLSysCltTypes.msi"
    Wednesday, January 21, 2009 2:48 AM
  • Can anyone help me?  I am still not sure what to do to get SQL Server Express working.  I want to get it working!
    Thursday, January 22, 2009 10:46 AM
  • You should now have an 'Install and Upgrade Centre' animal (not its exact name; I've not got access to Windows right now) installed and accessible via the Windows Start menus. If you start it up, and select Install, you will see that you have a Repair option. I guess if you copy the file as I indicated, you should only need one shot at it.

     

    Friday, January 23, 2009 1:14 PM

  • Aaron Alton said:

    Hi Alex,

    I'm not sure which version "came with your computer", but I would imagine that it's SQL Express.  Try installing it from here instead - the wizard is much friendlier.

    Let us know how it works out!


    Aaron Alton | thehobt.blogspot.com



     That link only poitnts me to a SQL Server 2005 list - do I have to install 2005 then upgrade to 2008 Express Edition?

    - Thanks
    • Edited by James_c1705 Saturday, March 21, 2009 2:32 PM forgot to quote
    Saturday, March 21, 2009 2:30 PM