none
BIDS installation for SQL 2008 R2 Reporting Services

    Question

  • We have a server with SQL Server 2008 R2 Enterprise and my work PC has Visual Studio 2010 Ultimate. We would like to start working with Reporting Services but need to install BIDS. I have read that i need Visual Studio 2008 for this. Is there another alternative?
    Monday, February 13, 2012 6:16 PM

Answers

  • Hi Rick131,

    BIDS for the latest version (SQL Server 2008 R2) still uses VS 2008, and is not compatible with VS 2010. Besides, even if you already have VS 2008, you still won't have those project templates unless you install BIDS from the SQL Server installer.

    VS 2010 natively supports developing local reports (reports hosted in your .NET application and not on a report server or SharePoint), and displaying it using the Microsoft ReportViewer control.

    For more information please refer to this thread which talks about it through:
    http://social.msdn.microsoft.com/Forums/en/vsreportcontrols/thread/78bd6eb6-9d14-48e2-80eb-8c8e66b52534

    Sincerely,

    Helen Zhou [MSFT]
    MSDN Community Support | Feedback to us

    • Proposed as answer by Helen Zhou Thursday, February 16, 2012 2:18 AM
    • Marked as answer by Helen Zhou Saturday, February 18, 2012 8:08 AM
    Tuesday, February 14, 2012 3:28 AM
  • Hi Rick131, you do not need to install VS 2008 on the SQL Server 2008 R2 Enterprise server box.

    All you need to do right now is to install any edition (Standard, Enterprise, Developer) of SQL Server 2008 R2 on your computer, and you will be able to select the "Business Intelligence Development Studio" feature on the "Feature Selection" screen during the SQL Server 2008 R2 installation.

    Regarding your concern about the licensing, I would suggest you check what type of licensing your company has bought in order for you to to determine if you can install it on your computer.

    Please do refer to this link that contains a PDF file regarding SQL Server licensing and also on the top right, there are telephone numbers (US/Canada) for you to contact Microsoft Representative regarding your licensing doubts.

    • Proposed as answer by Helen Zhou Friday, February 17, 2012 7:22 AM
    • Marked as answer by Helen Zhou Saturday, February 18, 2012 8:08 AM
    Thursday, February 16, 2012 5:51 AM
  • Hi Rick131, looking at your screenshot again, it seems that you have downloaded MS SQL Server 2008 R2 Express with Advanced Services from http://www.microsoft.com/download/en/details.aspx?id=25174, is that correct?

    If it is, the Express version does not have BIDS included. My suggestion to you is that you install a version of SQL Server 2008 R2 that is not an Express edition. BIDS is provided with the Standard, Developer and Enterprise editions.

    • Proposed as answer by Helen Zhou Wednesday, February 15, 2012 9:03 AM
    • Marked as answer by Helen Zhou Saturday, February 18, 2012 8:08 AM
    Wednesday, February 15, 2012 2:00 AM

All replies

  • Hi Rick131, there is no other alternative. As stated here, you will need to install VS 2008 in order to use BIDS with MS SQL 2008 R2.
    • Edited by systemx Monday, February 13, 2012 6:35 PM
    Monday, February 13, 2012 6:33 PM
  • What minimum version do I need of Visual Studio 2008? Is Visual Studio Express 2008 enough?
    • Edited by Rick131 Monday, February 13, 2012 6:57 PM
    Monday, February 13, 2012 6:45 PM
  • Hi Rick131, yes, please try installing VS 2008 Express, and after that, re-run the SQL 2008 R2 installer, and make sure the "Business Intelligence Development Studio" feature is ticked during the feature selection of the SQL installation.
    Monday, February 13, 2012 7:51 PM
  • Hi Rick131,

    BIDS for the latest version (SQL Server 2008 R2) still uses VS 2008, and is not compatible with VS 2010. Besides, even if you already have VS 2008, you still won't have those project templates unless you install BIDS from the SQL Server installer.

    VS 2010 natively supports developing local reports (reports hosted in your .NET application and not on a report server or SharePoint), and displaying it using the Microsoft ReportViewer control.

    For more information please refer to this thread which talks about it through:
    http://social.msdn.microsoft.com/Forums/en/vsreportcontrols/thread/78bd6eb6-9d14-48e2-80eb-8c8e66b52534

    Sincerely,

    Helen Zhou [MSFT]
    MSDN Community Support | Feedback to us

    • Proposed as answer by Helen Zhou Thursday, February 16, 2012 2:18 AM
    • Marked as answer by Helen Zhou Saturday, February 18, 2012 8:08 AM
    Tuesday, February 14, 2012 3:28 AM
  • I installed Visual Basic 2008 express and tried to run the SQL Server 2008 R2 Management Studio Installation, but can't find BIDS install. Do I need to install the the server edition of SQL Server for this?
    Tuesday, February 14, 2012 3:19 PM
  • Hi Rick131, when you ran the SQL Server 2008 R2 setup, are you saying that you were not shown the option of "Business Intelligence Development Studio" as seen in the screenshot below or you could not check the option at all? Could you please clarify?

    Tuesday, February 14, 2012 4:45 PM
  • I am guessing that is on the actual SQL Server Enterprise installation, but like I mentioned before that is on another server and I was trying to install the SQL Server Management Studio on my PC.

    SQL Server 2008 R2 Management Studio Install


    • Edited by Rick131 Tuesday, February 14, 2012 8:28 PM
    Tuesday, February 14, 2012 8:07 PM
  • Hi Rick131, looking at your screenshot again, it seems that you have downloaded MS SQL Server 2008 R2 Express with Advanced Services from http://www.microsoft.com/download/en/details.aspx?id=25174, is that correct?

    If it is, the Express version does not have BIDS included. My suggestion to you is that you install a version of SQL Server 2008 R2 that is not an Express edition. BIDS is provided with the Standard, Developer and Enterprise editions.

    • Proposed as answer by Helen Zhou Wednesday, February 15, 2012 9:03 AM
    • Marked as answer by Helen Zhou Saturday, February 18, 2012 8:08 AM
    Wednesday, February 15, 2012 2:00 AM
  • Hi Rick131,

    Please check this thread which would be great help How to install BIDS for SQL Server 2008 R2 and Visual S...

    Regards,

    Helen Zhou [MSFT]
    MSDN Community Support | Feedback to us

    Wednesday, February 15, 2012 9:13 AM
  • Basically, I would have to install Visual Studio 2008 on the SQL Server 2008 R2 Enterprise Server box and run BIDS there, because I doubt our licensing would allow to install the Enterprise version on a PC or anywhere else for that matter. Our DBA and Network Administrators wouldn't allow running anything other than SQL Server on that server.

    Do I need to install the database Engine on my PC for BIDS?

    Will SQL Server 2012 adress this issue?

    Wednesday, February 15, 2012 2:26 PM
  • Hi Rick131,

    Have you checked the replies from systemx and mine? All they talked about  that one needs to install VS 2008 in order to use BIDS with MS SQL 2008 R2, with you stated "I would have to install Visual Studio 2008 on the SQL Server 2008 R2 Enterprise Server box and run BIDS there, because ...", that isn't that you want? So why and what does that going to mean by "Do I need to install the database Engine on my PC for BIDS?"

    Sincerely,

    Helen Zhou [MSFT]
    MSDN Community Support | Feedback to us

    Thursday, February 16, 2012 2:05 AM
  • Hi Rick131, you do not need to install VS 2008 on the SQL Server 2008 R2 Enterprise server box.

    All you need to do right now is to install any edition (Standard, Enterprise, Developer) of SQL Server 2008 R2 on your computer, and you will be able to select the "Business Intelligence Development Studio" feature on the "Feature Selection" screen during the SQL Server 2008 R2 installation.

    Regarding your concern about the licensing, I would suggest you check what type of licensing your company has bought in order for you to to determine if you can install it on your computer.

    Please do refer to this link that contains a PDF file regarding SQL Server licensing and also on the top right, there are telephone numbers (US/Canada) for you to contact Microsoft Representative regarding your licensing doubts.

    • Proposed as answer by Helen Zhou Friday, February 17, 2012 7:22 AM
    • Marked as answer by Helen Zhou Saturday, February 18, 2012 8:08 AM
    Thursday, February 16, 2012 5:51 AM
  • Hi Rick131,

    Have you checked the replies from systemx and mine? All they talked about  that one needs to install VS 2008 in order to use BIDS with MS SQL 2008 R2, with you stated "I would have to install Visual Studio 2008 on the SQL Server 2008 R2 Enterprise Server box and run BIDS there, because ...", that isn't that you want? So why and what does that going to mean by "Do I need to install the database Engine on my PC for BIDS?"

    Sincerely,

    Helen Zhou [MSFT]
    MSDN Community Support

    I also mentioned my liscencing concern as I really don't need to install the database engine on my PC. Both of which I have stated in my prior reply. This is why I mentioned the opposite as an alternative.

    I did not know that is necesarry to have the full database engine AND Visual Studio running on the same PC. 


    • Edited by Rick131 Thursday, February 16, 2012 12:49 PM
    Thursday, February 16, 2012 12:41 PM