Does anyone know how to handle assigning permission to user folder without
using the report manager interface?
Through a command line or programmatically'You can do this by writing an application using the Web Service API or via
the Report Server script host (which are basically the same thing).
--
Brian Welcker
Group Program Manager
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Frank" <nospam@.nospam.org> wrote in message
news:uG6FRXddEHA.3148@.TK2MSFTNGP10.phx.gbl...
> Does anyone know how to handle assigning permission to user folder without
> using the report manager interface?
> Through a command line or programmatically'
>|||Some sample security scripting code here:
http://blogs.msdn.com/bryanke/archive/2004/03/17/91736.aspx
--
Bryan Keller
Developer Documentation
SQL Server Reporting Services
A friendly reminder that this posting is provided "AS IS" with no
warranties, and confers no rights.
"Frank" <nospam@.nospam.org> wrote in message
news:uG6FRXddEHA.3148@.TK2MSFTNGP10.phx.gbl...
> Does anyone know how to handle assigning permission to user folder without
> using the report manager interface?
> Through a command line or programmatically'
>|||Thank you all for your help
"Frank" <nospam@.nospam.org> wrote in message
news:uG6FRXddEHA.3148@.TK2MSFTNGP10.phx.gbl...
> Does anyone know how to handle assigning permission to user folder without
> using the report manager interface?
> Through a command line or programmatically'
>
Showing posts with label handle. Show all posts
Showing posts with label handle. Show all posts
Monday, March 12, 2012
Saturday, February 25, 2012
RS can't handle the load -- How can I lower concurrent requests?
I'm running a report schedule with 400 reports on it. RS is trying to run the
reports 8 at a time (according to the Performance Counter), and can't handle
the load. It writes out four or so, then hangs for an hour, occasionally
writing a successful report or failing a request with a "rendering error" or
a "write failure".
Last month we had a much smaller volume of data. This month it's not working
properly.
How do I set the number of concurrent requests that RS tries to run?You can set the MaxQueueThreads element in the RSReportServer.config file.
0 is the default and means RS will attempt to figure out the amount to load.
Any other number is the max number that RS will process at one time.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"AJ Cohen" <AJCohen@.nospam.nospam> wrote in message
news:95AFC3C0-A3D9-44B5-BEF3-C600E9864DA3@.microsoft.com...
> I'm running a report schedule with 400 reports on it. RS is trying to run
> the
> reports 8 at a time (according to the Performance Counter), and can't
> handle
> the load. It writes out four or so, then hangs for an hour, occasionally
> writing a successful report or failing a request with a "rendering error"
> or
> a "write failure".
> Last month we had a much smaller volume of data. This month it's not
> working
> properly.
> How do I set the number of concurrent requests that RS tries to run?
>
reports 8 at a time (according to the Performance Counter), and can't handle
the load. It writes out four or so, then hangs for an hour, occasionally
writing a successful report or failing a request with a "rendering error" or
a "write failure".
Last month we had a much smaller volume of data. This month it's not working
properly.
How do I set the number of concurrent requests that RS tries to run?You can set the MaxQueueThreads element in the RSReportServer.config file.
0 is the default and means RS will attempt to figure out the amount to load.
Any other number is the max number that RS will process at one time.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"AJ Cohen" <AJCohen@.nospam.nospam> wrote in message
news:95AFC3C0-A3D9-44B5-BEF3-C600E9864DA3@.microsoft.com...
> I'm running a report schedule with 400 reports on it. RS is trying to run
> the
> reports 8 at a time (according to the Performance Counter), and can't
> handle
> the load. It writes out four or so, then hangs for an hour, occasionally
> writing a successful report or failing a request with a "rendering error"
> or
> a "write failure".
> Last month we had a much smaller volume of data. This month it's not
> working
> properly.
> How do I set the number of concurrent requests that RS tries to run?
>
Subscribe to:
Comments (Atom)