SharePoint 2010 Standalone install - upgrade SQL Express to R2? RRS feed

  • Question

  • I have an existing installation: SharePoint Server 2010 on Windows 7 as a Standalone configuration with the packaged SQL Server 2008 Express. I want to install the SS 2008 R2 Management Studio, so I need to upgrade SS Express to R2.

    Can I perform an upgrade installation on without impacting SharePoint Server?

    Will the resulting R2 installation support using Management Studio wrt server roles, and to add databases?


    Mike Maier

    Tuesday, February 8, 2011 12:55 AM

All replies

  • Mike,

    I am not sure what exactly you are trying to achieve. My assumption is that you want to manage your SQL :) and hence the move from express to the 'real version'

    Well you do have options to install the management studio and you can do this from here

    http://www.microsoft.com/express/Database/InstallOptions.aspx :)

    However, if you want to move then it's best to use backup-spfarm powershell commands (Backup your complete SP Farm) and then start all over with installation of SQL, SP2010... the complete rig... and then restore your SP Farm from Central Administration...


    Alpesh Nakar's Blog Alpesh Just SharePoint Just SharePoint Updates

    SharePoint Saturday India Online Nov 20 2010 Contributing Author SharePoint 2010 Unleashed

    MCTS: SharePoint 2010 Configuration MCITP: SharePoint 2010 Administrator

    Tuesday, February 8, 2011 6:21 AM
  • Like Alpesh says, be sure that the reason for upgrading is the right reason.

    Out of the box, installing sharepoint 2010 on windows 7 is a single server standalone installation.

    this installation type assumes sql express.

    although it's possible to upgrade to sql 2008R2 full version, i don't see a reason for this , besides a database bigger dan 4Gb.



    Willing to learn everything about Sharepoint there is to learn. My blog
    Tuesday, February 8, 2011 10:17 AM
  • Mike

    if your prime requirement is to get an integrated environment for managing Sql Server then you can download Sql Server Management Studio R2 Express Edition.


    Aravind http://aravindrises.blogspot.com
    Tuesday, February 8, 2011 3:57 PM
  • Thanks to all for trying to interpret my very non-specific question. For clarity:

    I want to know if I need to upgrade SQL Server Express to SQL Server Express R2 to install SQL Server Management Studio

    Can I install SQL Server Management Studio R2 on the existing SQL Server Express? Or do I need SQL Server Express R2. Can I just download the SS Exp R2 installer and it will perform an upgrade installation?

    I don't want to mess up my perfectly well-working SharePoint 2010 development environment. What I want to do is create databases and tables and run queries for development. Again, this is just my personal dev machine.

    I will use the powershell backup advice when time to move to my other server machine.


    Mike Maier
    Tuesday, February 8, 2011 5:03 PM
  • You can install the R2 sql management tools without changing your existing/working sharepoint environment. You can use the express tools from the previously provided link, or grab the full version tools from a sql developer/standard/enterprise disc.

    (recopied link for convenience) http://www.microsoft.com/downloads/en/details.aspx?familyid=56AD557C-03E6-4369-9C1D-E81B33D8026B&displaylang=en

    Tuesday, February 8, 2011 5:14 PM
  • Installing Management studio R2 alone will not make any impact on existing Sql Server instance.

    Download SS Express R2 installer ,install and proceed.


    Aravind http://aravindrises.blogspot.com
    Tuesday, February 8, 2011 5:59 PM
  • I'm in the process of setting up a similar development environment. I installed a default instance of SQL Express 2008 R2 w/ Adv. Services, installed all of the other prerequisites and then installed SharePoint Server 2010 in Standalone mode. It still insisted on installing a SharePoint instance of SQL 2008.

    After some other attempts, realized that I could probably just run the Upgrade link from the SQL Express 2008 R2 installer. Did so, and the SharePoint SQL instance successfully upgraded. Just ran PSConfig and all seems to be right with the world.

    The caveat being, I'm doing this on a new install. Can't say for sure how it will behave on a mature install, but should be similar. However, as someone else suggested, I'd make a backup first.

    Jason Eaby

    Thursday, March 3, 2011 12:19 AM
  • How to you installed SharePoint 2010 and Express in stanalone. Accoring Microsoft, you can't install SharePoint 2010 in standalone which is DC, Db server ...


    Thursday, March 3, 2011 1:14 AM
  • You shouldn't install sharepoint and sql on a domain controller. But for sql express + sharepoint just select stand alone mode during sharepoint setup.

    Despite it being against best practices to put sharepoint and sql on a domain controller it still technically works, most of my development VM's are setup this way.

    SharePoint 2010 Extensions - http://sp2010ext.codeplex.com/ My Blog - http://www.withinsharepoint.com Twitter - http://twitter.com/#!/withnsharepoint
    Thursday, March 3, 2011 5:19 PM