none
Help on installing the SQl Server 2012 integrated along with SharePoint 2010 ?

    Question

  • Hello all,

    I just want to get help regarding the setup configuration .I have downloaded SQL server 2012 and SharePoint 2010 and all I want to know that what are the steps to setup these great products of Microsoft . Also do we have to install visual studio 2010 or we can work on visual studio 2008 itself.

    I want to install the SQl Server 2012 integrated along with SharePoint 2010 and want to try for the SSRS integrated in SharePoint 2010. so what we need to do.

    Hope to hear from you genius guys who have some good idea in this field.

    Thanks,

    Anil Maharjan

    Thursday, April 19, 2012 10:14 AM

Answers

  • Hi Anil,

    here is nice video for installing SQL http://www.youtube.com/watch?v=-6D69P6O9AI

    Basically you just need to be careful with Reporting Services configuration, you need to choose SharePoint Integrated Mode, if you plan to embed reports within your SharePoint.

    Other BI futures (Power Pivot) are also installed from SQL 2012 media, you need to run install again and choose > SQL Power Pivot for SharePoint.

    http://msdn.microsoft.com/en-us/library/hh231680.aspx#bkmk_sp1

    SSRS add-in can be installed separately or with PreRequisiteInstaller.exe (SharePoint media).

    With SQL data tools you will get BIDS 2010 (VS with only DB programming functions available), which will cover your needs about database programming.

    Regards,


    • Edited by Ursa Pangos Thursday, April 19, 2012 10:48 AM
    • Marked as answer by Anil Maharjan Monday, April 23, 2012 11:24 AM
    Thursday, April 19, 2012 10:47 AM

All replies

  • I hope the below link will help

    http://technet.microsoft.com/en-us/sqlserver/ff625277


    Regards,
    Ahmed Ibrahim
    SQL Server Setup Team
    This posting is provided "AS IS" with no warranties, and confers no rights. Please remember to click "Mark as Answer" and "Vote as Helpful" on posts that help you.
    This can be beneficial to other community members reading the thread.

    Thursday, April 19, 2012 10:21 AM
    Moderator
  • Hi Anil,

    here is nice video for installing SQL http://www.youtube.com/watch?v=-6D69P6O9AI

    Basically you just need to be careful with Reporting Services configuration, you need to choose SharePoint Integrated Mode, if you plan to embed reports within your SharePoint.

    Other BI futures (Power Pivot) are also installed from SQL 2012 media, you need to run install again and choose > SQL Power Pivot for SharePoint.

    http://msdn.microsoft.com/en-us/library/hh231680.aspx#bkmk_sp1

    SSRS add-in can be installed separately or with PreRequisiteInstaller.exe (SharePoint media).

    With SQL data tools you will get BIDS 2010 (VS with only DB programming functions available), which will cover your needs about database programming.

    Regards,


    • Edited by Ursa Pangos Thursday, April 19, 2012 10:48 AM
    • Marked as answer by Anil Maharjan Monday, April 23, 2012 11:24 AM
    Thursday, April 19, 2012 10:47 AM
  • Hello Ahmed,

    Thanks for your response  but the link only for SQL related i also want to know about the sharepoint 2010 and visualstudio 2010 .

    simply what are the software and setup steps we need to do in order to install a working copy for sharepoint and SQL 2012 .

    1.MS-SQL 2012,

    2.Sharepoint 2010 which version ? for intergation with SQL-SSRS mostly

    3.Visual studio which verison?

    4. Ms- office 2010

    5. Powerview/Power pivot

    6.Symantic BI model.

    These are the above great software/products, i want to test for 1-2 months and learn inside the story behind these products .so if anybody knows help me some links for setup and whitepapers so that i can enhance my knowledge in those fields more than i can imagine. :)

    Regards,

    Anil Maharjan

    Thursday, April 19, 2012 10:52 AM
  • To add:

    2. For BI futures, choose Enterprise http://sharepoint.microsoft.com/en-us/buy/pages/editions-comparison.aspx

    3. Use VS 2010

    4. Office 2010

    Regards,

    Thursday, April 19, 2012 11:10 AM
  • Hello Ursa,

    Thanks for your helpful reply and link ,i really appricated it.

    I was just looking for similar help .I will try to install as above link description if any issue came up on the way then hope to hear more help from you guys.

    Thanks again Ursa,

    Regards,

    Anil Maharjan

    Thursday, April 19, 2012 11:12 AM
  • Also about analysis services, symantic BI model is new model in 2012 version, brief info:

    http://blogs.msdn.com/b/analysisservices/archive/2011/05/16/analysis-services-vision-amp-roadmap-update.aspx

    Good luck with installation and configuration!

    Thursday, April 19, 2012 11:49 AM
  • Hello Ursa,

    I got an confuse that while installing SQL server 2012 -SQL Server PowerPivot for Sharepoint mode .Can we install and cofig this within a single machine having Windows 7 OS.

    How can we create a domain for single machine having windows 7 OS .Can we install virtual machine and setup windows sever 2008 on it.? So, that we can install the PowerPivot for sharepoint and configure for server farm mode. 

    Hope to hear from you soon.

    Thanks,

    Anil Maharjan


    Friday, April 20, 2012 12:10 PM
  • Hi Anil,

    according to MS, Windows 7 is an unsupported platform for the PowerPivot server components, but it can be done with some workarounds (I haven't used them jet)  http://blog.datainspirations.com/2010/05/23/installing-powerpivot-for-sharepoint-on-windows-7/

    If you have available both OS, I would rather set everything on Server, even if this means virtual machine, as you posted above.

    Regards,

    Monday, April 23, 2012 11:19 AM
  • Hi Ursa ,

    Thanks again for your help and after some research i also came to know as same.so , for now i have tried to learn by installing standalone mode and later on i will be trying the server farm mode .

    But learn some difficulties while installing  SQl Server 2012 along with sharepoint 2010 .

    Thanks,

    Anil Maharjan

    Monday, April 23, 2012 11:24 AM
  • Great,

    good luck :)

    Regards

    Monday, April 23, 2012 11:29 AM