HomeSharePointSQL Server 2012: Installing on a Virtual Machine

Comments

SQL Server 2012: Installing on a Virtual Machine — 19 Comments

  1. If I did not wish to worry about SharePoint (or do I even have a choice about this), would I need to install a clone of the VM, and simply install SQL Server 2012 to one VM? What would be the pros and cons of not having SharePoint 2010 integrated to the SQL Server 2012 install?

    • Hi Jason,

      You are not required to install SharePoint…you can just skip the steps that deal with SharePoint. The cons are you won’t be able to use Power View, PerformancePoint, or PowerPivot for SharePoint.

  2. Great post. Thanks for sharing all this information.

    Could you tell us which is the configuration of your machine?

    Thanks,

    André

  3. Pingback:MSBI # 67 – BI# 5 – SQL Server 2012 – Installation, Problem, Support and Help ! « (B)usiness (I)ntelligence Mentalist

  4. Pingback:Bird’s Eye view of SharePoint BI Dev Environment Setup process | Paras Doshi's Blog

  5. Hi James,

    Can you please include at which point do you need to install Powerpivot for Sharepoint?

    Also, can you first install SQL Server 2012 and confiuring SSRS, and then install Sharepoint? Is the order important here?

    Thank you very much…
    Jon

    • Hi Jon,

      PowerPivot for SharePoint can be installed at step #3 above. In the link in that step it takes you to further instructions where PowerPivot is installed in step #5. But it can actually be installed at any time after that step.

      You can install SSRS before you install SharePoint, but that would install SSRS in native mode. If you want to install SSRS in SharePoint mode, you need to install if after you install SharePoint.

  6. I try to follow the blog “Building a Completely Free Playground for SQL Server” but I stack with secound node. On secound node I can not connect my iSCASI initiator to Target “Connection Failed. I try to ping same address and has this error ” Destination host unreachable”.

  7. Pingback:SQL Server 2012 and SharePoint 2013: Installing on a Virtual Machine | James Serra's Blog

  8. Pingback:Creating a SQL Server 2012 playground (part I) | TFG Blog

  9. Pingback:Virtual SQL Playground Adventure: Building The Virtual Environment

  10. Pingback:Virtual SQL Playground Adventure: Building The Virtual Environment - SQL Server - SQL Server - Toad World

  11. Hi James,

    I am new to sql server and my boss has sent me for sql server 2014 Administrator training course, now he wants me to migrate our sql databases some from version 2005, 2008 to sql server 2014. I am just not so sure where to start ?

    Can you give me some points to start with.
    Thanks in advance,

    Thanh Thai

  12. Hi James,

    I need a advice from you regarding the “SQL as a Service” in virtual environment (VMWare). Is it possible to install SQL Server 2014 in Physical (DB) Server & connect 3 or more virtual DB server to the physical DB server to get the access of it i mean all virtual DB Server will run as individual SQL Server DB & take the Service from the Physical DB without installing the SQL Server.

    Please provide your advice.

Leave a Reply

Your email address will not be published. Required fields are marked *

HTML tags allowed in your comment: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>