Installing SQL Server Business Intelligence Development Studio 2005?

All replies

• 

  

  0

  Sign in to vote

  Hi Linn,

  We are still running SQL Server 2005, hopefully with plans to upgrade to 2012 later this year.  We also recently hired someone to develop reports, freeing me of the responsibility.  I would like to install the Business Intelligence Development Studio on the new person's desktop but have some questions.

  How do I install an old version of the development studio?  The one article I found with a link to the express version toolkit only takes me to the 2015 download community.  I've read that if I open a report in the more current version of studio that the report will be upgraded and will no longer run on the older version SSRS.  So I believe I need the old studio.

  I hope you have setup files for the edition of SQL Server that you already installed somewhere on your drives. If you don't, You can use your msdn subscription to logon to Microsoft website and you can download the setup files from there for the edition that you are licenced for. If you can't find both, You may have to contact Microsoft Support for further help.

  If you have the setup file use this to install BIDS for your new colleague. You have to select the following @Feature Selection page> Advanced > Client Components> Business Intelligence Development Studio 

  

  

  The above is for SQL Server 2005. Also recommended is to use the similar version of BIDS(2005) to develop and deploy reports if your SQL Server is 2005 to avoid any compatibility issues.

  What rights would someone need on the SSRS server to publish reports remotely?

  Try and create a role @Report server >Security>roles

  Create a new role call it publisher and grant it with Manage Reports Permissions and view reports permissions.

  Create a windows AD group > Add it to the desired folder on the report server webpage with publisher access.

  Add the new user to the windows AD group.

  https://www.mssqltips.com/sqlservertip/2793/sql-server-reporting-services-2012-permissions/

  Hope this helps

  Thanks

  Bhanu

  • Proposed as answer by Qiuyun YuMicrosoft contingent staff Tuesday, January 5, 2016 5:59 AM
  • Marked as answer by lkubler Wednesday, January 6, 2016 3:33 PM

  Monday, January 4, 2016 8:19 PM
• 

  

  0

  Sign in to vote

  Hi,

  Thanks for the information.  I think I have it all set and installed VS 2005 on a test computer for right now. 

  How do I point it to the server now for deployment of new reports?

  What is the best way to make all of the existing reports available so both myself and the new person can edit them?  I'm going to guess that I can just copy them to a network share and point the Projects and Templates locations in Options to that share.  Is it really that simple?

  What about data sources?

  Thanks,

  Linn

  Tuesday, January 5, 2016 2:16 PM
• 

  

  0

  Sign in to vote

  Hi,

  Never mind, think I figured that out.  It is in the project properties.

  Thanks for the help!

  Linn

  • Marked as answer by Qiuyun YuMicrosoft contingent staff Monday, January 11, 2016 12:28 PM

  Wednesday, January 6, 2016 3:33 PM