Reporting services error

Question

Reporting services error

Viewing 4 posts - 16 through 18 (of 18 total)

You must be logged in to reply to this topic. Login to reply

Gift Peddie SSC Guru Points: 73570 More actions · Answer 1

When the Report Server is separate it is called remote and remote deployment is different your developers need to copy the RDL, images and solution files to your Report Manager for deployment. And I think the least permission I see is publisher because the person need to be able to make changes needed for their code to run. Here are two Microsoft docs that can help you.

http://msdn.microsoft.com/en-us/library/ms156293.aspx

http://msdn.microsoft.com/en-us/library/bb283182.aspx

Kind regards,
Gift Peddie

Ahmad Osama SSCertifiable Points: 7676 More actions · Answer 2

kotlas7 (2/8/2009)
Hi Osama,
From BOL..
The databases can run on a local or remote SQL Server instance. Choosing a local instance is useful if you have sufficient system resources or want to conserve software licenses, but running the databases on a remote computer can improve performance.
I did not go through indetail, but definately this approach improves performance.

please give me the BOL link;I would like to read the complete article.

Regards,
[font="Verdana"]Sqlfrenzy[/font]

AAkula SSCertifiable Points: 5394 More actions · Answer 3

Here is the link

http://technet.microsoft.com/en-us/library/ms156016(SQL.90).aspx

ritz16 SSC Rookie Points: 25 More actions · Answer 4

Hello,

To be more clear the IIS creates two different virtual directories for the Report server as

http://serverA/reports

http://serverA/reportsserver and i think for the web site to work you need to access the second link with instanace name appended to the URL.

Now yr next point regarding deployment of reports for that you will have to provide the permission to the specific users or to the group from SQl server management studio.

Follow the following steps:

1) Go to SQL server management studion.

2) Go View -> Click Registered Servers.

3) Click 3rd tab of reporting services.

4) Right click - > New server registration.

5) Provide the Sql server credentials., then new instance will be created.

6) Right click new instance -> Object Explorer.

7) Right click Home folder -> Under permisioon tab add a user/Group.

8) Provide all the rights and deploy the report.

http://msdn.microsoft.com/en-us/library/aa337471.aspx

Cheers:)