none
SQL Server 2008 standard R2 Install on Windows 7 64-bit

    Question

  • I am having trouble installing SQL server 2008 standard R2 on a Windows 7 64-bit machine.  I have SQL server 2005 installed on my machine which I have all my databases stored.  I backed up all of them which I am not sure how to load them on SQL server 2008 R2 and it would accept them. 

    When I started to install SQL server 2008 R2,  I selected new installation and everthing was good till I got to the step Installation Rules.  Says with red circle X's "SQL Server 2005 Express tools" failed and "Previous releases of Microsoft Visual Studio 2008" failed which I installed vs 2008 sp1 which still registers as failed.  If I uninstall SQL Server 2005 Express tools, will it install SQL Server 2008 tools and I will I be able to use SQL server 2005? 

    I want to make sure that the databases on SQL server 2005 wont get deleted and the databases saved on my hard drive and flash drive will be able to be loaded on SQL server 2008 R2.

    How would I be able to approach this issue?

    Tuesday, December 20, 2011 7:50 PM

Answers

All replies

  • Hello,

    You can use SQL Server setup to upgrade the SQL Server 2005 instance to SQL Server 2008. This is called an in-place upgrade.

    You can also install new SQL Server 2008 instance side-by-side with the SQL Server 2005 instance, then you can transfer databases to the new instance using backup/restore or detach/attach methods.

    You can safely uninstall the tools, but do not uninstall the database engine.


    Hope this helps.


    Regards,

    Alberto Morillo
    SQLCoffee.com

    Tuesday, December 20, 2011 8:42 PM
    Moderator
  • From trying to search for Microsoft SQL Server 2005 express tools in the control panel. I found this link that would remove SQL Server 2005 express tools from the registry.

    http://dotnetguts.blogspot.com/2010/06/remove-sql-server-2005-express-tools.html

    In registry editor (regedit) I followed the directory HKEY_LOCAL_MACHINE/SOFTWARE/Microsoft/Microsoft SQL Server where I included a screen shot below.

    I didn't see a folder named 90 but I see a folder named 100.

    I am not sure where or how to remove SQL Server 2005 express tools?

    Wednesday, December 21, 2011 5:12 PM
  • Hello,

    The following step-by-step guide may be helpful.

    http://www.ehow.com/how_6528715_remove-server-2005-express-tools.html


    Hope this helps.

    Regards,

    Alberto Morillo
    SQLCoffee.com

    Wednesday, December 21, 2011 6:38 PM
    Moderator
  • I found a link which I have Windows 7 64-bit on how to remove the 90 folder for Microsoft SQL Server 2005 express tools .

    http://social.msdn.microsoft.com/Forums/en-US/sqlsetupandupgrade/thread/5fc58507-9f40-4213-acbd-32a57c8822d7

    I used regedit to get into the registry and used the filepath

    HKLM\Software\Wow6432Node\Microsoft\Microsoft SQL Server\90


    which I found the 90 folder that I removed, that I couldn't figure out orginally probably because most of the installations are in 32-bit systems.

     

    Then I reruned the installation of SQL Server 2008 R2 64-bit the SQL Server 2005 Express tools must have been removed, but I get one fail of "Previous releases of Microsoft Visual Studio 2008" and I get the dialog box "Rule "Previous releases of Microsoft Visual Studio 2008" failed" like in the image below

     

     

    So I follow the link in the dialog box and the installation of VS 2008 SP1 installed successful.  Then I Re-runned the Installation rules and I still get one fail of "Previous releases of Microsoft Visual Studio 2008" which I think is keeping me from installing SQL Server 2008 R2.  Is their something in the registry from restricting me from getting through this step or any other method?

    Thursday, December 22, 2011 7:48 PM
  • Hi Kingcandlepin,

    Uninstall the prerelease version of SQL Server 2008. Please make sure you have installed Visual Studio 2008 SP1 before you install SQL Server 2008 R2.

    If you install Visual Studio 2008 after you install SQL Server 2008, you must install Visual Studio 2008 SP1 to have a supported configuration. Visual Studio 2008 SP1 is not required if you have not installed the following features in SQL Server 2008:
      •Management Tools (Basic or Complete)
      • Integration Services Business
      • Intelligence Development Studio

    For more information, please refer to http://support.microsoft.com/kb/956139.

    If you have installed Visual Studio 2008 SP1, please refer to http://weblogs.asp.net/toddanglin/archive/2009/07/08/another-solution-for-defeating-the-sql-server-2008-installer-with-visual-studio-2008.aspx.

     

    Thanks,
    Maggie


    Please remember to mark the replies as answers if they help and unmark them if they provide no help. This can be beneficial to other community members reading the thread.
    Wednesday, January 04, 2012 9:32 AM
    Moderator
  • Hi Maggie,

     

    I installed Microsoft SQL Server 2008 R2 and didn't have any previous version of Microsoft SQL Server 2008. I have Visual Studio 2008 SP1 successfully installed on this computer. The that mean I have to uninstall Microsoft SQL Server 2008 R2 and if I have to uninstall SQL Server 2008 R2 what components do I have to uninstall and which folders do I have to delete in the registry or any place that I have to uninstall components?

    On the link that you sent me:

    http://weblogs.asp.net/toddanglin/archive/2009/07/08/another-solution-for-defeating-the-sql-server-2008-installer-with-visual-studio-2008.aspx

    setup /ACTION=install /SkipRules=VSShellInstalledRule RebootRequiredCheck

    I like that approach but, I don't know where in the registry where I can disable the RebootRequiredCheck and I don't know how to access the directory with the path above in bold font.

    how do I get past this step when I have successfully installed Microsoft Visual Studio 2008 SP1? When in my programs this is the only version of Microsoft Visual Studio 2008 I have on my machine.


     

    Saturday, January 14, 2012 6:39 PM
  • Hi King,


    The SQL Server 2008 installer is checking the HKLM\SOFTWARE\Microsoft\DevDiv\XXX\Servicing\9.0\SP registry keys to tell if SP1 is installed. If you inspect those keys and find any SP keys with the value “0,” that is your road block. If so, you could change the value to “1”.


    Thanks,
    Maggie


    Please remember to mark the replies as answers if they help and unmark them if they provide no help. This can be beneficial to other community members reading the thread.
    Tuesday, January 17, 2012 7:17 AM
    Moderator
  • In addition, you could use command prompt to install SQL Server 2008 R2. You could use the parameter
    setup /ACTION=install /SkipRules=VSShellInstalledRule RebootRequiredCheck.

    How to install SQL Server 2008 R2 from the command prompt: http://msdn.microsoft.com/en-us/library/ms144259(v=sql.105).aspx.


    Thanks,
    Maggie


    Please remember to mark the replies as answers if they help and unmark them if they provide no help. This can be beneficial to other community members reading the thread.
    Tuesday, January 17, 2012 8:18 AM
    Moderator
  • Hi Maggie,

     

    I changed the SP values in the registry to 1 in folder 10.0, folder 9.0 has the exact same values. I have a screenshot of the current changed part of the registry.

     

    After I changed SP values in the registry to the ones above, I restarted my computer and rerunned SQL Server installation center and I still get the error "Previous releases of Microsoft Visual Studio 2008" (with the red circle X) failed.

    I have this command which you would use in the command prompt that would bypass the installation rules:

    Setup /ACTION=install /SkipRules=VSShellInstalledRule

     

    This is the current directory of SQL installation center:

    C:\Temp\SQL Server 2008 R2 standard (x86, x64, ia64 - DVD (English)

     

    This is my view of my Windows Explorer directory:

     

     

    Where do I go to find the proper directory to run the command prompt command:

    Setup /ACTION=install /SkipRules=VSShellInstalledRule

    I have done some command prompt before but I am not sure what the proper execution would be of the command listed above?

    Wednesday, January 18, 2012 6:17 PM
  • Here are the images that were supposed to go with the last message.

     

     

    Wednesday, January 18, 2012 7:14 PM
  • hi Maggie,

    I figured out how to use command prompt to bypass the installation rules that of the installer. I found where the install files are in Windows Explorer and click the down arrow next to the directory path I copied the narrow down path in the attached image.

     

     

     

    Then I changed the directory command prompt which I use the line below:

     

    cd C:\Temp\SQL Server 2008 R2 Standard (x86, x64, ia64) - DVD (English)

     

    Which switch the directory to that path, then I used the line to bypass the installation rules step of the installer which worked like a charm. 

     

    Setup /ACTION=install /SkipRules=VSShellInstalledRule

     

    You have to start the installer by entering the line above with but correct directory path changed to get the installer to work from command prompt.

     

    I thank you so much for the help with this issue, because this was a tricky issue to figure out and I don't think I could've gotten over this without your help.

    Friday, January 27, 2012 9:14 PM