April 9, 2010 at 3:02 pm
I've been reading thread after thread but don't see the specific answer I am looking for.
We have a contract developer in that we want to have develop some Reporting Services reports. The PC had Visual Studio installed and we wanted to make the SQL Server 2005 BIDS available for use. To do the installation I thought that all that would be needed would be the client components not a Server installation .... is that incorrect? All installation threads keep mentioning installing SQL Server 2005 plus the additional components. Will someone try to clear up my confusion. What does a developer really need installed to be able to create projects for reporting services?
Thank you.
April 10, 2010 at 10:48 am
Ellen-477471 (4/9/2010)
I've been reading thread after thread but don't see the specific answer I am looking for.We have a contract developer in that we want to have develop some Reporting Services reports. The PC had Visual Studio installed and we wanted to make the SQL Server 2005 BIDS available for use. To do the installation I thought that all that would be needed would be the client components not a Server installation .... is that incorrect? All installation threads keep mentioning installing SQL Server 2005 plus the additional components. Will someone try to clear up my confusion. What does a developer really need installed to be able to create projects for reporting services?
Thank you.
To develop Enterprise reports fast a developer needs the developer edition of SQL Server and a development copy of your datasource database because a developer needs access to resources that are not in the client tools. This setup the developer goes into your datasource database to write the T-SQL using local Management Studio and then move to the design, development and test run of all the reports locally, so issues can be resolved before actual deployment.
Kind regards,
Gift Peddie
April 12, 2010 at 12:07 pm
Our developer has access to test and development databases; she has a server login and database access with object permissions. She doesn't need an actual copy of the database.
I am trying to determine the minimum installation requirements.
April 12, 2010 at 2:16 pm
Ellen-477471 (4/12/2010)
Our developer has access to test and development databases; she has a server login and database access with object permissions. She doesn't need an actual copy of the database.I am trying to determine the minimum installation requirements.
If you have test and development servers that is the development copy of the database and the SQL Server developer edition is because so many things in SSRS require high level permissions to get from design to deployment so the developer edition comes with all that a reports developer needs. If you give the developer limited permissions with client tools you may have to do part of the work because SSRS may reject some code.
Kind regards,
Gift Peddie
April 12, 2010 at 3:08 pm
I am trying to understand the components .... we have a development SQL Server that has the ReportServer database and the ReportServer tempdb; it has the dev copies of the datasource databases.
The developer is a user in all three databases and has security to create DDL , read & write in the RS db and read all in datasource db [actually has DDL rights there also from some previous development of stored procs], so I thought that the client/workstation tools were all that should need to be installed on the developer PC along with IIS.
Not sure that it matters, just trying to understand. We have some MSDN licenses and can install SQL Server 2005 from there but I like to do minimum installs and would like to give the setup team precise instruction for setting up developer PCs -- with everything they need, no more no less.
Thank you for your comments.
April 12, 2010 at 5:00 pm
If you have MSDN license here is the setup in a software engineering company for a report developer you give the person publisher permissions in Report Manager or they cannot deploy code. And then you create a single DBO account for your Shared datasource with access to the development datasource database, ReportServerDB and ReportServerTempDB. This means the developer is using their local ReportServerDB and ReportServerTempDB so the only thing they are using in your development server is the datasource database. When it is time for deployment the developer copies all files to Report Manager including the VS2005 solution file and all associated images. The ReportServer IP address or URL needs to be excluded in the developer LAN Setting in IE.
If you give the person the datasource database ERD you coud tell the person through email or verbally not to create any DDL without your approval.
If you skip any of the above you may be called to perform some tasks when SSRS rejects the developer for permissions reason.
Kind regards,
Gift Peddie
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply