none
Install SQL Server problem

    Question

  • I am using Windows 7 Home Premium.

    8 gigs ram

    Trying to install SQL Server 2008 Express.

    I keep getting the message "RANU is supported only for SQL Server Express" and the installation fails.

    I have visual studio express 2010 installes and .Net Framework 4 installed.

    Any help would be appreciated.

    Monday, August 16, 2010 4:02 PM

Answers

  • Hi magicscreen,

     

    According to the error message, “The system cannot find the path specified”, this issue is probably caused by that the path specified do not exist.

     

    To work around this issue, we suggest you to re-install SQL Server Express, and you can try the following steps:

        1. Uninstall the existing SQL Server 2008 R2 Express and all the components from the control panel.

        2. Backup the registry.

        3. Delete the following keys in regedit:

        --HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server

        --HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer

        4. Go to HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall and delete all the sub-keys referencing SQL Server.

        5. Go to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services and delete all the keys referencing SQL Server.

        6. Rename all the SQL Server folders in the computer.

        7. Reboot the machine.

        8. Download and install Microsoft .Net Framework 3.5 SP1 from here.

        9. Download and install Windows Installer 4.5 from here.

        10. Check if the computer has Visual Studio 2008. If so, you need to install Visual Studio 2008 SP1. For more information, please see here.

        11. Download SQL Server 2008 Express with Advanced Services from here and re-install it as suggested in this blog.

     

    In addition, on the Server Configuration page, please choose a local administrator or domain user account for all of these SQL Server services, such as administrator or <DomainName>/<UserName>.

     

    If this not work, could you please help us to collect the detailed error message and the following error log? It is very useful for our research.

    C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\LOG\Summary.txt.

    C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\<YYYYMMDD_HHMM>\Detail.txt

     

    For more information, please visit the following links:

    How to: Uninstall an Existing Instance of SQL Server (Setup): http://msdn.microsoft.com/en-us/library/ms143412.aspx

    A similar thread: http://social.msdn.microsoft.com/forums/en-us/sqlexpress/thread/B27D77D9-E14C-47FC-8459-7E9529623547

     

    If you have any more questions, please feel free to let me know.

     

    Thanks,

    Yoyo Yu

    Monday, August 23, 2010 8:51 AM
    Moderator
  • Hi magicscreen,

     

    According to the error message, “Could not load file or assembly... The system cannot find the file specified (C:\\Users\Administrator\AppData\Local\Microsoft_Corporation\...”, this issue is probably caused by file missing. And this LandingPage.exe error occurs because it couldn’t bind to system assembly.

     

    To work around this issue, please delete the following cache folder, and then re-install the SQL Server Express.

        %AppData%\Local\Microsoft_Corporation\

     

    If this not work, we suggest you to download SQL Server 2008 R2 Express with Advanced Services from here and re-install it as suggested in this blog.

     

    For more information about this issue, please visit the following links.

    SQL Server 2008 Express w/ Tools Setup: http://social.msdn.microsoft.com/Forums/en-US/sqlsetupandupgrade/thread/3c3dd3af-5d43-4a9b-b093-6c4af3464590

    Error installing R2 on Windows 7/.NET v4.0: http://social.msdn.microsoft.com/Forums/en-US/sqlkjsetupandupgrade/thread/35356bf2-6db7-4785-a104-bc62d18913f7

     

    If you have any more questions, please feel free to let me know.

     

    Thanks,

    Yoyo Yu

    Friday, August 20, 2010 9:48 AM
    Moderator

All replies

  • Try using the Run as Administrator option to start the SQL Server installation. Also please check the Setupbootstrap for more detailed information on the failure reasons.

     




    Pradeep Adiga
    My blog: http://www.sqldbadiaries.com
    Recent posts on my blog
    Monday, August 16, 2010 8:00 PM
  • Thanks for your help.

    I tried Run as Administrator and it didn't work.

    What is the setupbootstrap?

    I forgot to mention that I am running 64 bit windows 7.

    Tuesday, August 17, 2010 12:43 PM
  • I am trying to install SQL Server 2008 R2 Express but keep getting the message "RANU is supported only for SQL Server Express". Why am I getting this message if I am trying to install SQL Server 2008 R2 Express? I am using Windows 7 64 bit with 8 gig ram.
    Tuesday, August 17, 2010 4:10 PM
  • Hi magicscreen,

     

    According to the error message, “RANU is supported only for SQL Server Express”, this issue is probably caused by installing SQL Server Express under a network service account. Or the login account doesn't have permissions to install SQL Server Express.  P.S. RANU stands for Run As Normal User.

     

    To work around this issue, please follow the following steps:

        1. Log off or restart the computer.

        2. Use administrator account to login system.

        3. Right-click the setup.exe, select Run as administrator, and then install SQL Server 2008 Express.

     

    In addition, if we use the configuration file on command-line to install SQL Server 2008 Express, we need to set ENABLERANU option to "1" to enable RANU for SQL Server Express in the configuration file.

     

    If this not work, could you please help us to collect the detailed error message and error log? It is very useful for our research. Usually, the error log you should look at is located in:  %Program Files%\Microsoft SQL Server\90\Setup Bootstrap\LOG\Summary.txt. For 32 bit SQL Server, it should locate in Program files (X86), for 64 bit SQL Server, it should locate in Program files.  P.S. Setup Bootstrap used to store the installation information.

     

    For more information, please visit the following links:

    How to Install SQL Server 2008 from the Command Prompt: http://msdn.microsoft.com/en-us/library/ms144259(v=SQL.100).aspx

    How to Install SQL Server 2008 Using a Configuration File: http://msdn.microsoft.com/en-us/library/dd239405(SQL.100).aspx

    How to View and Read SQL Server Setup Log Files: http://msdn.microsoft.com/en-us/library/ms143702.aspx

     

    If you have any more questions, please feel free to let me know.

     

    Thanks,

    Yoyo Yu

    Wednesday, August 18, 2010 9:31 AM
    Moderator
  • I am trying to install sql server 2008 r2 express but keep getting the error "RANU is only supported for sql server express" during the install but that is what I am trying to install.

    I tried this using "run as administrator" as well as signing in with the Administrator account

    The install stops.

    I am using Windows 7 Home Premium 64 bit.

    I do not currently have any other sql servers installed. However, I do have sql server 2008 r2 setup installed.

    I cannot remove it because I get a message stating that I have sql server 2008 r2 common files installed.

    I cannot find these files

    Wednesday, August 18, 2010 2:39 PM
  • I tried to sign in as the Administrator using the Administrator account.

    I tried to install SQL Server 2008 R2 Express with tools and received the following message:

    Unhandles exception has occurred.

    An error occurred creating the configuration section handler for userSettings/Microsoft.SqlServer.Configuration.LandingPage.Properties.Settings

    Could not load file or assembly 'System Version 4.0.0.0 Culture=neutral, PublicKeyToken=b77a5c561934e089' or one of its dependencies. The system cannot find the file specified (C:\\Users\Administrator\AppData\Local\Microsoft_Corporation\LandingPage.exe_StrongName_ryspccglaxmt4nhllj5z3thycltsvyyx\10.0.0.0\user.co

    I tried to copy and paste the message into this email but I could not.

    I also could not locate any error log file.

    I don't understand what you mean by the following statement:

    In addition, if we use the configuration file on command-line to install SQL Server 2008 Express, we need to set ENABLERANU option to "1" to enable RANU for SQL Server Express in the configuration file.

    Where do I set ENABLERANU option to "1"? Is it in the configuration file? If so, where is the configuration file located?

    Thanks again for your help.

    Thursday, August 19, 2010 1:09 PM
  • I did find this file which I think is the summary file for my last install try.

    The name of the file is: Summary_arts-HP-PC_2010819_084742_LandingPage.txt

    Overall summary:
      Final result:                  Passed
      Exit code (Decimal):           0
      Exit message:                  Passed
      Start time:                    2010-08-19 08:47:43
      End time:                      2010-08-19 09:05:06
      Requested action:              LandingPage

    Machine Properties:
      Machine name:                  ARTS-HP-PC
      Machine processor count:       4
      OS version:                    Windows 7
      OS service pack:              
      OS region:                     United States
      OS language:                   English (United States)
      OS architecture:               x64
      Process architecture:          64 Bit
      OS clustered:                  No

    Package properties:
      Description:                   SQL Server Database Services 2008 R2
      ProductName:                   SQL Server 2008 R2
      Type:                          RTM
      Version:                       10
      SPLevel:                       0
      Installation location:         c:\c38137ca358f8a332fb904d5\x64\setup\
      Installation edition:          EXPRESS_ADVANCED

    User Input Settings:
      ACTION:                        LandingPage
      CONFIGURATIONFILE:            
      ENU:                           True
      FARMACCOUNT:                   <empty>
      FARMADMINPORT:                 0
      FARMPASSWORD:                  *****
      HELP:                          False
      IACCEPTSQLSERVERLICENSETERMS:  False
      INDICATEPROGRESS:              False
      PASSPHRASE:                    *****
      QUIET:                         False
      QUIETSIMPLE:                   False
      UIMODE:                        AutoAdvance
      X86:                           False

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

    Detailed results:

    Rules with failures:

    Global rules:

    There are no scenario-specific rules.

    Rules report file:               The rule result report file is not available.

    • Proposed as answer by DEW0362 Wednesday, November 27, 2013 2:21 AM
    • Unproposed as answer by DEW0362 Wednesday, November 27, 2013 2:21 AM
    Thursday, August 19, 2010 1:25 PM
  • Hi magicscreen,

     

    According to the error message, “Could not load file or assembly... The system cannot find the file specified (C:\\Users\Administrator\AppData\Local\Microsoft_Corporation\...”, this issue is probably caused by file missing. And this LandingPage.exe error occurs because it couldn’t bind to system assembly.

     

    To work around this issue, please delete the following cache folder, and then re-install the SQL Server Express.

        %AppData%\Local\Microsoft_Corporation\

     

    If this not work, we suggest you to download SQL Server 2008 R2 Express with Advanced Services from here and re-install it as suggested in this blog.

     

    For more information about this issue, please visit the following links.

    SQL Server 2008 Express w/ Tools Setup: http://social.msdn.microsoft.com/Forums/en-US/sqlsetupandupgrade/thread/3c3dd3af-5d43-4a9b-b093-6c4af3464590

    Error installing R2 on Windows 7/.NET v4.0: http://social.msdn.microsoft.com/Forums/en-US/sqlkjsetupandupgrade/thread/35356bf2-6db7-4785-a104-bc62d18913f7

     

    If you have any more questions, please feel free to let me know.

     

    Thanks,

    Yoyo Yu

    Friday, August 20, 2010 9:48 AM
    Moderator
  • Thank you, I will try what you suggested and inform you of my results.

    Thanks,

    Art

    Friday, August 20, 2010 1:50 PM
  • I tried to install SQL Server 2008 R2 Express with Advanced Services and it failed.

    Below is the log file:

    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:                    2010-08-20 10:41:22
      End time:                      2010-08-20 10:51:29
      Requested action:              Install
      Log with failure:              C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20100820_104021\Detail.txt
      Exception help link:           http%3a%2f%2fgo.microsoft.com%2ffwlink%3fLinkId%3d20476%26ProdName%3dMicrosoft%2bSQL%2bServer%26EvtSrc%3dsetup.rll%26EvtID%3d50000%26ProdVer%3d10.0.1600.22%26EvtType%3d0xF57C3D6F%400xFB92A9BB

    Machine Properties:
      Machine name:                  ARTS-HP-PC
      Machine processor count:       4
      OS version:                    Windows Vista
      OS service pack:              
      OS region:                     United States
      OS language:                   English (United States)
      OS architecture:               x64
      Process architecture:          64 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                                      10.0.1600.22    No       
      Sql Server 2008      SQLEXPRESS           MSSQL10.SQLEXPRESS             SQL Server Replication                   1033                                      10.0.1600.22    No       
      Sql Server 2008      SQLEXPRESS           MSSQL10.SQLEXPRESS             Full-Text Search                         1033                                      10.0.1600.22    No       
      Sql Server 2008      SQLEXPRESS           MSRS10.SQLEXPRESS              Reporting Services                       1033                                      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:\2f37ba3208df872bfbae90eb2e3c7efe\x64\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\20100820_104021\ConfigurationFile.ini
      ENABLERANU:                    True
      ERRORREPORTING:                False
      FEATURES:                      SQLENGINE,FULLTEXT,RS,BIDS,SSMS,SNAC_SDK,OCS
      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 (x86)\Microsoft SQL Server\
      INSTALLSQLDATADIR:             <empty>
      INSTANCEDIR:                   C:\Program Files\Microsoft SQL Server\
      INSTANCEID:                    ArtsSQLExpress
      INSTANCENAME:                  ARTSSQLEXPRESS
      ISSVCACCOUNT:                  NT AUTHORITY\NetworkService
      ISSVCPASSWORD:                 *****
      ISSVCSTARTUPTYPE:              Automatic
      MEDIASOURCE:                   c:\2f37ba3208df872bfbae90eb2e3c7efe\
      NPENABLED:                     0
      PID:                           *****
      QUIET:                         False
      QUIETSIMPLE:                   False
      RSINSTALLMODE:                 DefaultNativeMode
      RSSVCACCOUNT:                  NT AUTHORITY\LOCAL SERVICE
      RSSVCPASSWORD:                 *****
      RSSVCSTARTUPTYPE:              Automatic
      SAPWD:                         *****
      SECURITYMODE:                  <empty>
      SQLBACKUPDIR:                  <empty>
      SQLCOLLATION:                  SQL_Latin1_General_CP1_CI_AS
      SQLSVCACCOUNT:                 NT AUTHORITY\SYSTEM
      SQLSVCPASSWORD:                *****
      SQLSVCSTARTUPTYPE:             Automatic
      SQLSYSADMINACCOUNTS:           arts-HP-PC\arts1
      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\20100820_104021\ConfigurationFile.ini

    Detailed results:
      Feature:                       Database Engine Services
      Status:                        Failed: see logs for details
      MSI status:                    Passed
      Configuration status:          Failed: see details below
      Configuration error code:      0xFB92A9BB
      Configuration error description: The system cannot find the path specified
      Configuration log:             C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20100820_104021\Detail.txt

      Feature:                       SQL Client Connectivity SDK
      Status:                        Passed
      MSI status:                    Passed
      Configuration status:          Passed

      Feature:                       Full-Text Search
      Status:                        Failed: see logs for details
      MSI status:                    Passed
      Configuration status:          Failed: see details below
      Configuration error code:      0xFB92A9BB
      Configuration error description: The system cannot find the path specified
      Configuration log:             C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20100820_104021\Detail.txt

      Feature:                       Reporting Services
      Status:                        Failed: see logs for details
      MSI status:                    Passed
      Configuration status:          Failed: see details below
      Configuration error code:      0xFB92A9BB
      Configuration error description: The system cannot find the path specified
      Configuration log:             C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20100820_104021\Detail.txt

      Feature:                       Management Tools - Basic
      Status:                        Passed
      MSI status:                    Passed
      Configuration status:          Passed

      Feature:                       Business Intelligence Development Studio
      Status:                        Passed
      MSI status:                    Passed
      Configuration status:          Passed

      Feature:                       Microsoft Sync Framework
      Status:                        Passed
      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\20100820_104021\SystemConfigurationCheck_Report.htm

    Friday, August 20, 2010 3:02 PM
  • One thing I forgot to mention to you.

    During the installation a screen appeared for the Server Configuration.

    It wanted an account for the SQL Server Database Engine and the Sql Server Report Services.

    There were two choices for the Database Engine: NT Authority/Network and NT Authority/System.

    I chose NT Authority/System

    Also, there were three choices for the Reporting Services: NT Authority/Network, NT Authority/System and NY Authority Local System.

    I chose NT Authority Local System.

    I had no reason to choose either account. I just guessed.

     I am going to run SQL Server on a single computer running Windows 7 Home premium.

    I also have .Net Framework 4.0 installed.

    Friday, August 20, 2010 3:25 PM
  • Hi magicscreen,

     

    According to the error message, “The system cannot find the path specified”, this issue is probably caused by that the path specified do not exist.

     

    To work around this issue, we suggest you to re-install SQL Server Express, and you can try the following steps:

        1. Uninstall the existing SQL Server 2008 R2 Express and all the components from the control panel.

        2. Backup the registry.

        3. Delete the following keys in regedit:

        --HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server

        --HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer

        4. Go to HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall and delete all the sub-keys referencing SQL Server.

        5. Go to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services and delete all the keys referencing SQL Server.

        6. Rename all the SQL Server folders in the computer.

        7. Reboot the machine.

        8. Download and install Microsoft .Net Framework 3.5 SP1 from here.

        9. Download and install Windows Installer 4.5 from here.

        10. Check if the computer has Visual Studio 2008. If so, you need to install Visual Studio 2008 SP1. For more information, please see here.

        11. Download SQL Server 2008 Express with Advanced Services from here and re-install it as suggested in this blog.

     

    In addition, on the Server Configuration page, please choose a local administrator or domain user account for all of these SQL Server services, such as administrator or <DomainName>/<UserName>.

     

    If this not work, could you please help us to collect the detailed error message and the following error log? It is very useful for our research.

    C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\LOG\Summary.txt.

    C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\<YYYYMMDD_HHMM>\Detail.txt

     

    For more information, please visit the following links:

    How to: Uninstall an Existing Instance of SQL Server (Setup): http://msdn.microsoft.com/en-us/library/ms143412.aspx

    A similar thread: http://social.msdn.microsoft.com/forums/en-us/sqlexpress/thread/B27D77D9-E14C-47FC-8459-7E9529623547

     

    If you have any more questions, please feel free to let me know.

     

    Thanks,

    Yoyo Yu

    Monday, August 23, 2010 8:51 AM
    Moderator
  • Thanks for your help.

    I tried to do the steps you provided.

    I got to the point of trying to install SQL Server 2008 R2 Express after deleting the keys from the registry and renaming the microsoft sql server folders and rebboting.

    The install went up the the point of installing the Setup files and then it ended with no messages.

    I tried doing the install with Run as Administrator as well as signing in as the Administrator with no success.

    Any suggestions would be welcome.

    The log file is below:

    Overall summary:
      Final result:                  Passed
      Exit code (Decimal):           0
      Exit message:                  Passed
      Start time:                    2010-08-23 15:26:43
      End time:                      2010-08-23 15:34:40
      Requested action:              LandingPage

    Machine Properties:
      Machine name:                  ARTS-HP-PC
      Machine processor count:       4
      OS version:                    Windows 7
      OS service pack:              
      OS region:                     United States
      OS language:                   English (United States)
      OS architecture:               x64
      Process architecture:          64 Bit
      OS clustered:                  No

    Package properties:
      Description:                   SQL Server Database Services 2008 R2
      ProductName:                   SQL Server 2008 R2
      Type:                          RTM
      Version:                       10
      SPLevel:                       0
      Installation location:         c:\f00a817a022e953c9f\x64\setup\
      Installation edition:          EXPRESS_ADVANCED

    User Input Settings:
      ACTION:                        LandingPage
      CONFIGURATIONFILE:            
      ENU:                           True
      FARMACCOUNT:                   <empty>
      FARMADMINPORT:                 0
      FARMPASSWORD:                  *****
      HELP:                          False
      IACCEPTSQLSERVERLICENSETERMS:  False
      INDICATEPROGRESS:              False
      PASSPHRASE:                    *****
      QUIET:                         False
      QUIETSIMPLE:                   False
      UIMODE:                        AutoAdvance
      X86:                           False

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

    Detailed results:

    Rules with failures:

    Global rules:

    There are no scenario-specific rules.

    Rules report file:               The rule result report file is not available.

    Monday, August 23, 2010 7:56 PM
  • I also got these results

    Microsoft SQL Server 2008 R2 Setup - System Configuration Check Report

    Computer Name(s): ARTS-HP-PC
    Report Date/Time: 8/23/2010 3:27 PM
    Saved to Directory: C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20100823_152654\SystemConfigurationCheck_Report.htm

    Rule Name Rule Description Result Message/Corrective Action
    GlobalRules: SQL Server 2008 R2 Setup configuration checks for rules group 'GlobalRules'
    AclPermissionsFacet Checks if the SQL Server registry keys are consistent. Passed SQL Server registry keys are consistent and can support SQL Server installation or upgrade.
    MediaPathLength Checks whether the SQL Server installation media is too long. Passed The SQL Server installation media is not too long.
    OsVersionCheck Checks whether the computer meets minimum operating system version requirements. Passed The operating system version meets the minimum requirements for this product.
    RebootRequiredCheck Checks if a pending computer restart is required. A pending restart can cause Setup to fail. Passed The computer does not require a restart.
    SetupCompatibilityCheck Checks whether the current version of SQL Server is compatible with a later installed version. Passed Setup has not detected any incompatibilities.
    ThreadHasAdminPrivilegeCheck Checks whether the account running SQL Server Setup has administrator rights on the computer. Passed The account running SQL Server Setup has administator rights on the computer.
    WmiServiceStateCheck Checks whether the WMI service is started and running on the computer. Passed The Windows Management Instrumentation (WMI) service is running.

    Rules Documentation: http://go.microsoft.com/fwlink/?LinkId=157129
    Community: http://go.microsoft.com/fwlink/?LinkId=157128
    Setup Help File: http://go.microsoft.com/fwlink/?LinkId=157127

    Monday, August 23, 2010 7:58 PM
  • I finally got SQL Server 2008 R2 installed.

    I had an old SQL Setup installed but was unable to uninstall it. After deleting the items from the registry, I was able to uninstall it and then was able to install SQL Server 2008 R2 Express.

    I installed it using the defaults using the Windows Login.

    Now, however, I am getting an error when trying to connect.

    The error states that the server could not be found or was not accessible.

    Then it said: Verify that the instance name is correct and that SQL Server is configured to allow remote connections.

    Provider: Named Pipes Provider Error 40 could not open a connection to SQL Server.

    Under this it had Error 2 Severity 20 State 0

    Any suggestiobs?

    Thanks,

    Art

    Monday, August 23, 2010 8:27 PM
  • Please disregard the last message. I am installed and connected.

    Thanks again for your help.

    You can close this case.

    Monday, August 23, 2010 8:29 PM
  • Thanks again for your help.

    However, I now have another problem with SQL Server 2008 R2 Express with MS Access 2007.

    I can open SQL Server using the Management Screen but I cannot connect to MS Access 2007 using SQL Server Express as the database.

    I keep getting the message that SQL Server 2005 cannot be found. I am using SQL Server 2008.

    It will not allow me to sign onto sql server 2008 starting that it cannot be found.

    Do I have to now run the SQL Server 2008 R2 Express SP1?

    Is there an upgrade to MS Access 2007 which will allow me to use SQL Server 2008 R2 Express?

    Thanks again.

    Monday, August 23, 2010 9:04 PM
  • Hi magicscreen,

     

    Since the question in your latest reply is another question, I recommend that you ask it in a new thread and you will receive more quicker support.

     

    If you have any more questions, please feel free to let me know.

     

    Thanks,

    Yoyo Yu

    Tuesday, August 24, 2010 9:39 AM
    Moderator
  • Same situation here..but I completely remove my previous installation of SQL server 2008 R2 by using the method described on this  www.developerscentral.net/remove-sql-server-2008-r2-completely/.

    And installed it again and this solve my problem.

    Friday, January 24, 2014 7:31 AM