Reporting Services Count: user

Showing posts with label user. Show all posts

Friday, March 30, 2012

Reporting Services User Problems...

What I learned this week is that Reporting Services security is annoying as
hell. :-)
I'm curious if there is any logical reason that you cannot create a
subscription out of
a report that references the User!UserID? Perhaps I can see why some other
values
in User! may not be available, but the subscription is clearly associated
with the username
that created it, so I cannot even conceieve why there would be a limitation
like that.
Second, I was curious about the context under which a scheduled report is
executed.
The restriction above seems to indicate that it is run under the context of
some unknown
generic user, but my experience below seems to indicate otherwise.
The nuts and bolts of it is that I am receiving the infamous
"ServerConfigurationErrorException:
The Report Server has encountered a configuration error; more details in the
log files,
AuthzInitializeContextFromSid: Win32 error: 5; possible reason - service
account doesn't
have rights to check domain user SIDs.". I started with the server running
as NETWORK
SERVICE, changed to LOCAL SYSTEM, and am finally using a domain account that
clearly has access to the domain controller to lookup SIDs.
My confusion here is that if *I* create a subscription (being an
administrator) the
subscription runs fine. If any other user creates the subscription, it will
fail with the error
above. I'd sure like some insight into how this authorization crap works to
help track
down the problem.
Thanks,
Joel
jdk6 at case dot eduJoel,
> I'm curious if there is any logical reason that you cannot create a
> subscription out of
> a report that references the User!UserID?
There is a good reason and it is that subscriptions are executed in an
unattended mode by the RS Windows service so any user context is irrelevant.
> Second, I was curious about the context under which a scheduled report is
> executed.
> The restriction above seems to indicate that it is run under the context
of
> some unknown
> generic user, but my experience below seems to indicate otherwise.
Under the context of the RS Windows service account.
Every user with Create Subscription rights should be able to create
subscriptions. From there, it is the RS Windows service responsibility to
handle the subscription.
--
Hope this helps.
----
Teo Lachev, MCSD, MCT
Author: "Microsoft Reporting Services in Action"
Publisher website: http://www.manning.com/lachev
Buy it from Amazon.com: http://shrinkster.com/eq
Home page and blog: http://www.prologika.com/
----
"Joel D Kraft" <jdkraft2@.nospam.nospam> wrote in message
news:eaWoPv4mEHA.316@.TK2MSFTNGP10.phx.gbl...
> What I learned this week is that Reporting Services security is annoying
as
> hell. :-)
> I'm curious if there is any logical reason that you cannot create a
> subscription out of
> a report that references the User!UserID? Perhaps I can see why some
other
> values
> in User! may not be available, but the subscription is clearly associated
> with the username
> that created it, so I cannot even conceieve why there would be a
limitation
> like that.
> Second, I was curious about the context under which a scheduled report is
> executed.
> The restriction above seems to indicate that it is run under the context
of
> some unknown
> generic user, but my experience below seems to indicate otherwise.
> The nuts and bolts of it is that I am receiving the infamous
> "ServerConfigurationErrorException:
> The Report Server has encountered a configuration error; more details in
the
> log files,
> AuthzInitializeContextFromSid: Win32 error: 5; possible reason - service
> account doesn't
> have rights to check domain user SIDs.". I started with the server
running
> as NETWORK
> SERVICE, changed to LOCAL SYSTEM, and am finally using a domain account
that
> clearly has access to the domain controller to lookup SIDs.
> My confusion here is that if *I* create a subscription (being an
> administrator) the
> subscription runs fine. If any other user creates the subscription, it
will
> fail with the error
> above. I'd sure like some insight into how this authorization crap works
to
> help track
> down the problem.
> Thanks,
> Joel
> jdk6 at case dot edu
>
>|||> Joel,
>> I'm curious if there is any logical reason that you cannot create a
>> subscription out of
>> a report that references the User!UserID?
> There is a good reason and it is that subscriptions are executed in an
> unattended mode by the RS Windows service so any user context is
> irrelevant.
> > Second, I was curious about the context under which a scheduled report
> > is
>> executed.
>> The restriction above seems to indicate that it is run under the context
> of
>> some unknown
>> generic user, but my experience below seems to indicate otherwise.
> Under the context of the RS Windows service account.
> Every user with Create Subscription rights should be able to create
> subscriptions. From there, it is the RS Windows service responsibility to
> handle the subscription.
Well at least your answers are consistent! :-)
Which is what I expected, though I cannot say that I agree.
My problem still remains then, is why when I create a subscription as an
administrator,
my subscription is delivered properly, but a subscription created by a
normal user
gets an AuthzInitializeContextFromSid error. This seems inconsistent with
the report
being solely run from the context of the RS Service account... if it had
permission
to process my subscription correctly, it should be able to do them all!!
This is RS 2000 SP1 under Windows 2003 and a Windows 2000 domain
functional level. "Authenticated Users" has the rights to read all of the
user and
group objects...
Joel|||Check the following thread:
http://groups.google.com/groups?q=AuthzInitializeContextFromSid&hl=en&lr=&ie=UTF-8&selm=O4qGzyL%24DHA.1700%40TK2MSFTNGP12.phx.gbl&rnum=7
--
Hope this helps.
----
Teo Lachev, MCSD, MCT
Author: "Microsoft Reporting Services in Action"
Publisher website: http://www.manning.com/lachev
Buy it from Amazon.com: http://shrinkster.com/eq
Home page and blog: http://www.prologika.com/
----
"Joel D Kraft" <jdkraft2@.nospam.nospam> wrote in message
news:%23uO7VJ5mEHA.3296@.TK2MSFTNGP10.phx.gbl...
> > Joel,
> >
> >> I'm curious if there is any logical reason that you cannot create a
> >> subscription out of
> >> a report that references the User!UserID?
> >
> > There is a good reason and it is that subscriptions are executed in an
> > unattended mode by the RS Windows service so any user context is
> > irrelevant.
> > > Second, I was curious about the context under which a scheduled report
> > > is
> >> executed.
> >> The restriction above seems to indicate that it is run under the
context
> > of
> >> some unknown
> >> generic user, but my experience below seems to indicate otherwise.
> >
> > Under the context of the RS Windows service account.
> >
> > Every user with Create Subscription rights should be able to create
> > subscriptions. From there, it is the RS Windows service responsibility
to
> > handle the subscription.
> Well at least your answers are consistent! :-)
> Which is what I expected, though I cannot say that I agree.
> My problem still remains then, is why when I create a subscription as an
> administrator,
> my subscription is delivered properly, but a subscription created by a
> normal user
> gets an AuthzInitializeContextFromSid error. This seems inconsistent with
> the report
> being solely run from the context of the RS Service account... if it had
> permission
> to process my subscription correctly, it should be able to do them all!!
> This is RS 2000 SP1 under Windows 2003 and a Windows 2000 domain
> functional level. "Authenticated Users" has the rights to read all of the
> user and
> group objects...
> Joel
>

Monday, March 26, 2012

Reporting Services Questions

First of all, I like to thank Microsoft for providing Reporting Services with End User Tool.

I am working with CTP release on SQL Server 2005 Reporting Service using SQL Server 2000 as data source in Report Model Project.
I was working with RS2000 earlier, since we are interested in "End user tool" for reporting building, I started working on RS2005.

I have created a model and trying build a Report using Report builder. I have more than 75 fields to select on single report.

My questions are,
1. By using Report builder, I am selecting (by dragging fields) on report. While dragging first field, Report Builder > explorer is showing only directly dependant entities and its attributes. Here, I am not able to select attributes from Report Builder > explorer which are not dependant on other entities because explorer is not showing other entities. While dragging first attributes from one entity, explorer is not showing entities which are not depend on my first selected entities. How can I get other attributes available which is not relevant to my first selected attributes?

2. How to change print orientation of my report in to "landscape"? All of my reports will be printed on "landscape".

3. I am using "Report Builder" using keyboard and without mouse which makes it very difficult to work. Any shortcuts will be available for Report Manager (e.g. Menu Items: New Folder, New Data Source, Upload File, Report Builder etc.) or Report Builder (Explorer, Fields, Run Report, Design Report, Filter, selecting fields etc.)?

4. When will RS2005 will support export to Microsoft Word format?

5. I assume that database structure and Report Model are two separate things, and I can create my own relationship between existing entities in report Model. Is this correct?

6. I assume that RS 2005 Report Manager is accessible via web without any upgrades of Internet Explorer etc. is this correct? At present, I am not able to see all contents of Report Manager.

Above queries are influenced by my client who is using our customised tool as a Report Engine which is tightly coupled with development team and often changing requirements.Comments inline:

1. By using Report builder, I am selecting (by dragging fields) on report. While dragging first field, Report Builder > explorer is showing only directly dependant entities and its attributes. Here, I am not able to select attributes from Report Builder > explorer which are not dependant on other entities because explorer is not showing other entities. While dragging first attributes from one entity, explorer is not showing entities which are not depend on my first selected entities. How can I get other attributes available which is not relevant to my first selected attributes?

For your report to make sense, you have to have a path between the entities in your report. You should be able to navigate between entities by clicking on them. You can also use the find button (not sure how well that was working in CTP June).

2. How to change print orientation of my report in to "landscape"? All of my reports will be printed on "landscape".

In Report Builder, it is in the page properties dialog (not sure if that was fully implemented in CTP June). In Report Designer, make your page width greater than your page height.

Shortcuts will be added for the released product.

4. When will RS2005 will support export to Microsoft Word format?

Unfortunately, we were not able to get it into RS 2005. This is high on the list for a future release.

5. I assume that database structure and Report Model are two separate things, and I can create my own relationship between existing entities in report Model. Is this correct?

Sort of. The relationship has to be defined in the DSV so that we can generate the SQL. You never have to modify the database schema itself.

6. I assume that RS 2005 Report Manager is accessible via web without any upgrades of Internet Explorer etc. is this correct? At present, I am not able to see all contents of Report Manager.

Report Manager works with IE 5.5 and later. Not sure what you are running into.|||

-->>For your report to make sense, you have to have a path between the entities in your report. You should be able to navigate between entities by clicking on them. You can also use the find button (not sure how well that was working in CTP June).

This couldn't be more wrong , if you have 2 fact table sales and customer, and dimension time and product , you can't do a report that show sales , customers that make that purchases by product and time .

This is a very basic feature that report builder can't do......

Plase give us a beter tool

sql