Friday, March 30, 2012
Report Engine
can for instance say; I want user 'A' to get report 'B' in a format of
'C' at 17:05 every day.
Many thanks
DavidYes, it is called Subscriptions. You can specify all of that. It is
available both Standard and Enterprise. However, Enterprise adds data driven
subscriptions.
Here is from books online about data driven subscriptions:
>>>
A data-driven subscription provides a way to deliver reports to a list of
subscribers that is determined at run time. You can use data-driven
subscriptions as follows:
a.. Customize report output at run time for each recipient of a delivery.
b.. Support the wide distribution of a report with a fluctuating list of
subscribers. For example, you can use data-driven subscriptions to
distribute a report throughout a large organization where subscribers vary
from one month to the next, or use other criteria that determines group
membership from an existing set of users.
A data-driven subscription differs from a standard subscription in the way
it gets subscription information. A data-driven subscription gets some
settings from a data source at run time, and other settings from the
subscription definition. Fixed aspects of a data-driven subscription include
the report that is delivered, the delivery extension, connection information
to an external data source that contains subscriber data, and a query that
retrieves subscription information. Dynamic settings of the subscription are
obtained from the query, including a subscriber list and user-specific
delivery extension preferences or parameter values. This data is retrieved
from a data source each time the subscription is processed.
>>>>>
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<davidswain2005@.yahoo.co.uk> wrote in message
news:1141318397.513927.57680@.i39g2000cwa.googlegroups.com...
> Does Report Services 2005 have a Report Distribution engine. So that I
> can for instance say; I want user 'A' to get report 'B' in a format of
> 'C' at 17:05 every day.
>
> Many thanks
> David
>|||Yes, it's called creating a subscription
"davidswain2005@.yahoo.co.uk" wrote:
> Does Report Services 2005 have a Report Distribution engine. So that I
> can for instance say; I want user 'A' to get report 'B' in a format of
> 'C' at 17:05 every day.
>
> Many thanks
> David
>
Report effective permissions for all users?
I've been asked to prepare a report quarterly showing, for each user in
Active directory, what his effective permissions are for every table in
every database that he has permission for on our SQL Server 2000 server. I
searched a bit for a tool to do this, but all I found was the PERMISSIONS()
function for showing effective permissions of the current user. Is there
any way to do it for an arbitrary user, without logging in as them?Ross Presser (rpresser@.imtek.com) writes:
> As our customers demand that we tighten our IT security in the company,
> I've been asked to prepare a report quarterly showing, for each user in
> Active directory, what his effective permissions are for every table in
> every database that he has permission for on our SQL Server 2000 server.
> I searched a bit for a tool to do this, but all I found was the
> PERMISSIONS() function for showing effective permissions of the current
> user. Is there any way to do it for an arbitrary user, without logging
> in as them?
You would have to trawl system tables like syspermissions for this. I
decline to provide any samples, because you need account for roles,
including fixed server roles.
This you would do per database. You could set up views for all system
tables that are of interest like:
CREATE VIEW serverpermissions AS
SELECT dbname = 'master', * FROM master.dbo.syspermissions
UNION ALL
SELECT 'model', * FROM model.dbo.syspermissions
UNION ALL
...
Preferably such views would be built dynamically.
I would estimate that the devlopment time for a correct report would be
at least 40 hours. And it might produces over 100 pages of output that
I doubt that no one will ever get through.
--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||On Wed, 15 Sep 2004 22:19:42 +0000 (UTC), Erland Sommarskog wrote:
> Ross Presser (rpresser@.imtek.com) writes:
>> As our customers demand that we tighten our IT security in the company,
>> I've been asked to prepare a report quarterly showing, for each user in
>> Active directory, what his effective permissions are for every table in
>> every database that he has permission for on our SQL Server 2000 server.
>> I searched a bit for a tool to do this, but all I found was the
>> PERMISSIONS() function for showing effective permissions of the current
>> user. Is there any way to do it for an arbitrary user, without logging
>> in as them?
> You would have to trawl system tables like syspermissions for this. I
> decline to provide any samples, because you need account for roles,
> including fixed server roles.
> This you would do per database. You could set up views for all system
> tables that are of interest like:
> CREATE VIEW serverpermissions AS
> SELECT dbname = 'master', * FROM master.dbo.syspermissions
> UNION ALL
> SELECT 'model', * FROM model.dbo.syspermissions
> UNION ALL
> ...
> Preferably such views would be built dynamically.
> I would estimate that the devlopment time for a correct report would be
> at least 40 hours. And it might produces over 100 pages of output that
> I doubt that no one will ever get through.
Well, I may have talked them down somewhat. Here's what I offered them:
http://www.sql-server-performance.com/rd_auditing2.asp has a stored
procedure that will list all roles that each database user belongs to.
The system stored procedure sp_helprotect lists all explicitly granted
permissions in the database, whether to a role or a database user, but not
including the system defined server roles or database roles like db_reader.
The system stored procedure sp_helplogins shows all the logins defined on
the server, and which database user and roles they map to in each database.
Between these three, I can picture a script that enumerates effective
permissions on each database object. for each sql login. Such a chart would
probably be 10-30 pages long at our site.
The last piece would be a script that takes each Active Directory user and
determines which sql login would apply. Determining a user's permissions
would then require looking up their AD user to find the sql login, then
looking up the sql login to find the permissions.
Looking forward, we plan to revise our security so that:
(a) all permissions are set at the user-defined role level
(b) no logins (except sa) are assigned to any system-defined server or
database roles
(c) sa is the dbo of all databases
What do you think?|||Ross Presser (rpresser@.imtek.com) writes:
> Looking forward, we plan to revise our security so that:
> (a) all permissions are set at the user-defined role level
> (b) no logins (except sa) are assigned to any system-defined server or
> database roles
> (c) sa is the dbo of all databases
> What do you think?
This does not sound right to me. It sounds almost right, but if I understand
this alright, all administration will be performed thruogh the "sa" account.
If you have exactly one DBA who knows this password, that is OK.
If you have more than one DBA, each one who is entitled to do admin
work on the server should be granted admin rights, either explicitly
or through BUILTIN/Administrators.
Anonymous high-power accounts like "sa" is not a good thing, since this
makes impossible to hold anyone accountable.
But plain users should be granted access through roles, and not by user.
And having only plain users and sysadmin users makes things a little easier.
But for security it's only good if you can afford to give anyone who needs
to something beyond simple access admin rights.
--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||>> What do you think?
> This does not sound right to me. It sounds almost right, but if I understand
> this alright, all administration will be performed thruogh the "sa" account.
> If you have exactly one DBA who knows this password, that is OK.
> If you have more than one DBA, each one who is entitled to do admin
> work on the server should be granted admin rights, either explicitly
> or through BUILTIN/Administrators.
> Anonymous high-power accounts like "sa" is not a good thing, since this
> makes impossible to hold anyone accountable.
> But plain users should be granted access through roles, and not by user.
> And having only plain users and sysadmin users makes things a little easier.
> But for security it's only good if you can afford to give anyone who needs
> to something beyond simple access admin rights.
Very good point, but not quite what I intended. Although sa would be the
dbo, administration would be done through non-sa accounts that belonged to
user-defined roles that had been granted the needed admin rights, at
whatever granularity was needed.
I just didn't want any users getting rights that were not from roles, by
virtue of them being the dbo of a database (or owner of a table, etc.)
But now that I type these words, I realize that to prevent users from
owning databases or other objects, I will have to do all admin as sa, just
like you said! That's not very good...
Can the owner of an object be reassigned by some stored proc? Then I could
create the table as rpresser then immediately reassign it to sa (still as
rpresser).|||Ross Presser (rpresser@.imtek.com) writes:
> Can the owner of an object be reassigned by some stored proc? Then I could
> create the table as rpresser then immediately reassign it to sa (still as
> rpresser).
sp_changeobjectowner. rpresser would then have to have dbo permissions to
do this.
And in such case you should just as well say CREATE TABLE dbo.ladida the
first time round.
But I would suggest that it is better that you are logged in as
DOMAIN\rpresser and this account is a member of BUILTIN\Administrator.
You may want to pursue the topic in microsoft.sqlserver.public.security.
I might not be able to contribute more on the thread, since I'm going away
on holiday tomorrow.
--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp
Report dynamic fields
I need to let my report user to select the columes in the report:
I want to make a report with all the relevant fileds .
the user will have window that read the rdl file and display all the reports
fields.
The user can select only the columes he need from the colume list.
How can I doit ?
Can I change the rdl file before the user use the report ?
10x,
Shachar.My suggestion if you decide to do this is to use RS 2005 (out in November).
RS 2005 along with the new controls shipping with Visual Studio 2005 will
make this much much easier than trying to do this with RS 2000. RS 2000 is
totally server based. You would have to deploy your new RDL (uniquely names,
remember you are server based) and then get your client to execute that
report (using either URL integration or web services). Then you would need
to remove it when done. With the new control with VS 2005 you can operate in
local mode where you give it a dataset and the rdl. No deployment necessary.
If all your reports are done this way then you don't even need the server
product, just the new controls.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Shachar" <me@.use.com> wrote in message
news:OXJyiTlpFHA.3040@.TK2MSFTNGP10.phx.gbl...
> Hi all,
> I need to let my report user to select the columes in the report:
> I want to make a report with all the relevant fileds .
> the user will have window that read the rdl file and display all the
> reports fields.
> The user can select only the columes he need from the colume list.
> How can I doit ?
> Can I change the rdl file before the user use the report ?
> 10x,
> Shachar.
>|||What if the application is a web base apllication ?
What is the right colume filter solutuin ?
10x,
Liz.
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:OlEEZcmpFHA.272@.TK2MSFTNGP15.phx.gbl...
> My suggestion if you decide to do this is to use RS 2005 (out in
November).
> RS 2005 along with the new controls shipping with Visual Studio 2005 will
> make this much much easier than trying to do this with RS 2000. RS 2000 is
> totally server based. You would have to deploy your new RDL (uniquely
names,
> remember you are server based) and then get your client to execute that
> report (using either URL integration or web services). Then you would need
> to remove it when done. With the new control with VS 2005 you can operate
in
> local mode where you give it a dataset and the rdl. No deployment
necessary.
> If all your reports are done this way then you don't even need the server
> product, just the new controls.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Shachar" <me@.use.com> wrote in message
> news:OXJyiTlpFHA.3040@.TK2MSFTNGP10.phx.gbl...
> > Hi all,
> >
> > I need to let my report user to select the columes in the report:
> > I want to make a report with all the relevant fileds .
> > the user will have window that read the rdl file and display all the
> > reports fields.
> > The user can select only the columes he need from the colume list.
> >
> > How can I doit ?
> > Can I change the rdl file before the user use the report ?
> >
> > 10x,
> >
> > Shachar.
> >
>|||I use RS 2005 .
"Liz Matyas" <lizmts@.mail.com> wrote in message
news:Ozf7%23yopFHA.3064@.TK2MSFTNGP15.phx.gbl...
> What if the application is a web base apllication ?
> What is the right colume filter solutuin ?
> 10x,
> Liz.
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:OlEEZcmpFHA.272@.TK2MSFTNGP15.phx.gbl...
> > My suggestion if you decide to do this is to use RS 2005 (out in
> November).
> > RS 2005 along with the new controls shipping with Visual Studio 2005
will
> > make this much much easier than trying to do this with RS 2000. RS 2000
is
> > totally server based. You would have to deploy your new RDL (uniquely
> names,
> > remember you are server based) and then get your client to execute that
> > report (using either URL integration or web services). Then you would
need
> > to remove it when done. With the new control with VS 2005 you can
operate
> in
> > local mode where you give it a dataset and the rdl. No deployment
> necessary.
> > If all your reports are done this way then you don't even need the
server
> > product, just the new controls.
> >
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> > "Shachar" <me@.use.com> wrote in message
> > news:OXJyiTlpFHA.3040@.TK2MSFTNGP10.phx.gbl...
> > > Hi all,
> > >
> > > I need to let my report user to select the columes in the report:
> > > I want to make a report with all the relevant fileds .
> > > the user will have window that read the rdl file and display all the
> > > reports fields.
> > > The user can select only the columes he need from the colume list.
> > >
> > > How can I doit ?
> > > Can I change the rdl file before the user use the report ?
> > >
> > > 10x,
> > >
> > > Shachar.
> > >
> >
> >
>
Report Distribution based on SQL Query in RDL
I need to create multiple reports with each report being sent to the specified user. For example, 3 Managers should each get their own report. A Stored Procedure receives a ManagerID parameter, so I need 3 instances of the report. I also need each report to be sent to its associated Manager:
I set up a rss file to run the report and can run it multiple times, passing in a different ID value each time, but it will not be data driven because I must hard-code the parameters in the ReportParmaters object of the report for each execution.
Is there a way, either by designing the report in VS2005 or on the Reporting Services server, to accomplish what I'm intending to do?
Did you already have a look on the datadriven subscription option in Reporting Services ? That would exactly fit your needs.Jens K. Suessmeyer
http://www.sqlserver2005.de
Report Detail Sections will not expand
the '+' sign to expand it and see the details. This has worked in the
past and works in design view for this report, however when deployed to
report manager and brought up in IE it will not expand. I have tried
deleting the report from the report manager and then re-deploying but
this doesnt work. Does anyone have a similar experience or know how to
fix this?I have just found out that it is doing this for all reports that have
the '+' sign that lets the user choose to see detail. Only thing that
has changed is that we changed our report server to the full license
when our trial expired. If anyone can help I would greatly appreciate
it.|||I have the same problem. If you have solved the problem, please post the
resolution. Thanks.
<barhoc11@.gmail.com> wrote in message
news:1129901639.084816.251550@.f14g2000cwb.googlegroups.com...
>I have just found out that it is doing this for all reports that have
> the '+' sign that lets the user choose to see detail. Only thing that
> has changed is that we changed our report server to the full license
> when our trial expired. If anyone can help I would greatly appreciate
> it.
>
Wednesday, March 28, 2012
Report designer
In a RD, i have 2 dataset, one of them consist of two field (id and name) by which the name will be shown as a parameter. When a user select from the combo box, how do I enable the id of the this dataset to be link up as a 'parameter' to another dataset which is a query to retrieve the result?
In another words instead of using the parameter 'name' i would like to implicitly link up the id instead of the name which is shown to the user.
Thanks.
Regards
Alu
In Report Parameters, you set the
Value Field to be ID
and the
Label Field to be Name
A bit like this
<Prompt>Select Hierarchy Group</Prompt>
<ValidValues>
<DataSetReference>
<DataSetName>H_Groups</DataSetName>
<ValueField>id</ValueField>
<LabelField>List</LabelField>
</DataSetReference>
</ValidValues>
Where id is the parameter passed to the query & List is the values displayed for the user to choose from in the Listbox
|||thanks!
Regards
Alu
sqlMonday, March 26, 2012
Report Deployment Problem
After dealing with and solving some problems with the local ASPNET user and
it's rights to the report server config file and the database server I ran
into a report deployment problem:
I can preview the report in Developer Studio, but when I try to deploy it,
the operation ends with an error. The error indicates that the deployment
process is trying to use the guest IIS account to perform the operation...
Error 1 The permissions granted to user 'EDN-SCOTTT\IUSR_EDN-SCOTTT' are
insufficient for performing this operation. 0 0
1. Why is it trying to do a deployment using this account?
2. Where do I correct this problem by supplying the correct account
information?
Thank you,
ScottOn the report server, make sure that your Reportserver web site Anonymous
Access disabled, and Authentication Access set to Integrated WIndows
Authentication.
In Internet Explorer on your computer, put the Report server web site in
Trusted Sites, and turn on "Always prompt for username and password" under
the security settings.
Then make sure that your account is allowed to view and add reports to the
server, by going to the report server URL and try to log in and generally do
stuff. (If you get the Upload file-button, you should be allowed to add
reports.)
Try deploying the report again.
Kaisa M. Lindahl
"ScottT" <ScottT@.discussions.microsoft.com> wrote in message
news:C4B0237D-79CB-4585-9B2C-DA7ED256AF50@.microsoft.com...
>* Running SQL Server 2005 Enterprise on XP Pro *
> After dealing with and solving some problems with the local ASPNET user
> and
> it's rights to the report server config file and the database server I ran
> into a report deployment problem:
> I can preview the report in Developer Studio, but when I try to deploy it,
> the operation ends with an error. The error indicates that the deployment
> process is trying to use the guest IIS account to perform the operation...
> Error 1 The permissions granted to user 'EDN-SCOTTT\IUSR_EDN-SCOTTT' are
> insufficient for performing this operation. 0 0
> 1. Why is it trying to do a deployment using this account?
> 2. Where do I correct this problem by supplying the correct account
> information?
> Thank you,
> Scott
>
Friday, March 23, 2012
Report Columns
I have a detailed report with 60 columns. How can user hide some columns in
reportviewer?
For example if he is interested in 5 columns, is it possible for him to hide
rest 45 col. automaticly?
ThanksHi,
if you are using a table control on your report you can use the Visibility
property. Using this property you can either specify an expression or specify
another control in the report to toggle the visibility of the column. If you
want the user to decide about visibility I'd go for the control, if you wish
to do it I'd suggest an expression evaluating the current Windows
user(WindowsIdentity)
"Kenan Kilictepe" wrote:
> Hi,
> I have a detailed report with 60 columns. How can user hide some columns in
> reportviewer?
> For example if he is interested in 5 columns, is it possible for him to hide
> rest 45 col. automaticly?
> Thanks
>
>
Report Builder: Custom Aggregate
I have used Report Builder to enable user to do Ad-Hoc Report that has
been great so far, but I have unique requirement for below table/view:
Month Headcount
================== January-06 45
February-06 41
March-06 43
April-06 42
May-06 38
June-06 30
July-06 50
(etc...)
Dec-06 42
Above table represents how many employees, one company/department has
during Month column. In January-06, there is 45 employees,
February-06, there is 44 employees, and so on.
If user choose to show Headcount attribute, Report Builder should
display each month headcount. The current problem is on the aggregate.
for example, report should show Headcount for Quarter 1 as 43, which
is headcount for March-06 (how many employees I have at the end of
Quarter 1), Quarter 2 should display 30, which is headcount for
June-06, and for Year of 2006 should be 42 (at Dec-06). There will be
more complexity: if now is still in the month of November 06 and no
data for December yet, report should show headcount of November 06 as
headcount for Year of 2006.
I don't think default available aggregates which are: Total, Average,
Max, Min, able to do this.
Q1, correct value should be 40 (March-06)
If I use Total Aggregate, it will be 99.
If I use Average, it will be 24.75
If I use Max, it will be 45.
If I use Min, it will be 41.
I need an aggregate that show number from last record in the dataset.
Is there any possible way how to do this? Any input is appreciated.
Thank you.On Jun 19, 4:59 pm, Gunady <Gun...@.gmail.com> wrote:
> Hi All,
> I have used Report Builder to enable user to do Ad-Hoc Report that has
> been great so far, but I have unique requirement for below table/view:
> Month Headcount
> ==================> January-06 45
> February-06 41
> March-06 43
> April-06 42
> May-06 38
> June-06 30
> July-06 50
> (etc...)
> Dec-06 42
> Above table represents how many employees, one company/department has
> during Month column. In January-06, there is 45 employees,
> February-06, there is 44 employees, and so on.
> If user choose to show Headcount attribute, Report Builder should
> display each month headcount. The current problem is on the aggregate.
> for example, report should show Headcount for Quarter 1 as 43, which
> is headcount for March-06 (how many employees I have at the end of
> Quarter 1), Quarter 2 should display 30, which is headcount for
> June-06, and for Year of 2006 should be 42 (at Dec-06). There will be
> more complexity: if now is still in the month of November 06 and no
> data for December yet, report should show headcount of November 06 as
> headcount for Year of 2006.
> I don't think default available aggregates which are: Total, Average,
> Max, Min, able to do this.
> Q1, correct value should be 40 (March-06)
> If I use Total Aggregate, it will be 99.
> If I use Average, it will be 24.75
> If I use Max, it will be 45.
> If I use Min, it will be 41.
> I need an aggregate that show number from last record in the dataset.
> Is there any possible way how to do this? Any input is appreciated.
> Thank you.
Reporting Services actually supports "Last" Aggregate (using regular
RDL file, e.g. developed using Visual Studio), which I think can solve
the problem. I notice that we can use
Count,CountDistinct,StDev,StDevP,Var, or VarP, in the Report Builder
editor itself, but there is no First or Last available. Does anyone
knows how to use this "Last" aggregate in report builder?
Report Builder, Stored Procedures and Views
tables from the database. I need to limit the amount of data a user can
access but the only entities showing up in the Explorer are tables.Hi,
You can access from tables and views, what ever filter criteria you can give
it in views. Go to "Data Source Views" in the Report model project and click
on add existing items from your datasource you should see tables and views.
Amarnath
"SYoung" wrote:
> How can I access recordsets from Stored Procedures and/or views instead of
> tables from the database. I need to limit the amount of data a user can
> access but the only entities showing up in the Explorer are tables.|||You're talking about a Report Project in VS. What I'm talking about is an
add on client development tool accessible via the
http://YourReportServer/Reports page called "Report Builder". This tool
allowes the user to create adhoc reports without having to write 1 line of
SQL.
"Amarnath" wrote:
> Hi,
> You can access from tables and views, what ever filter criteria you can give
> it in views. Go to "Data Source Views" in the Report model project and click
> on add existing items from your datasource you should see tables and views.
> Amarnath
>
> "SYoung" wrote:
> > How can I access recordsets from Stored Procedures and/or views instead of
> > tables from the database. I need to limit the amount of data a user can
> > access but the only entities showing up in the Explorer are tables.
Wednesday, March 21, 2012
Report Builder Security Filter Examples
report builder models. Do you setup a standard filter. How do you pass
the user back to the server in the query?
ThanksI have the same type of question...I need to be able to pass parameters
(userid) back to my model due to security setup in our system...we have
several 'user-access' tables for varying levels of security. For
example, any given user has access to specific accounts, but only
certain members within that account and only specific coverages within
those members. I don't see how I can set this up using roles but
perhaps I'm just missing it.|||the getuserid() function can be used... but... reportbuilder keep in cache
the first user which access a filter object where the getuserid() function
is used!!!
so if an "administrator" try the model, then every other users use the same
access!!!
but using the getuserid() into reportbuilder himself (the user create a
report and explicitly setup a filter) then the ID used is the right one, but
its not a good solution.
I'll do some other tests and keep you informed.
"tim" <tbush@.ccmsi.com> wrote in message
news:1141664357.097038.87240@.i40g2000cwc.googlegroups.com...
>I have the same type of question...I need to be able to pass parameters
> (userid) back to my model due to security setup in our system...we have
> several 'user-access' tables for varying levels of security. For
> example, any given user has access to specific accounts, but only
> certain members within that account and only specific coverages within
> those members. I don't see how I can set this up using roles but
> perhaps I'm just missing it.
>|||I will be posting an entry on my blog (http://blogs.msdn.com/bobmeyers)
shortly explaining how to use security filters.
FYI, the incorrect behavior of the GETUSERID() function is a known issue
that is fixed in SP1, which will be available shortly.
"Jéjé" wrote:
> the getuserid() function can be used... but... reportbuilder keep in cache
> the first user which access a filter object where the getuserid() function
> is used!!!
> so if an "administrator" try the model, then every other users use the same
> access!!!
> but using the getuserid() into reportbuilder himself (the user create a
> report and explicitly setup a filter) then the ID used is the right one, but
> its not a good solution.
> I'll do some other tests and keep you informed.
>
> "tim" <tbush@.ccmsi.com> wrote in message
> news:1141664357.097038.87240@.i40g2000cwc.googlegroups.com...
> >I have the same type of question...I need to be able to pass parameters
> > (userid) back to my model due to security setup in our system...we have
> > several 'user-access' tables for varying levels of security. For
> > example, any given user has access to specific accounts, but only
> > certain members within that account and only specific coverages within
> > those members. I don't see how I can set this up using roles but
> > perhaps I'm just missing it.
> >
>
>|||thanks!
your blog appear to be great and usefull.
favorites favorites... ;-)
"Bob Meyers - MSFT" <BobMeyersMSFT@.discussions.microsoft.com> wrote in
message news:D083E8EC-F89C-4E6A-AE99-0BEFDE4F877B@.microsoft.com...
>I will be posting an entry on my blog (http://blogs.msdn.com/bobmeyers)
> shortly explaining how to use security filters.
> FYI, the incorrect behavior of the GETUSERID() function is a known issue
> that is fixed in SP1, which will be available shortly.
> "Jéjé" wrote:
>> the getuserid() function can be used... but... reportbuilder keep in
>> cache
>> the first user which access a filter object where the getuserid()
>> function
>> is used!!!
>> so if an "administrator" try the model, then every other users use the
>> same
>> access!!!
>> but using the getuserid() into reportbuilder himself (the user create a
>> report and explicitly setup a filter) then the ID used is the right one,
>> but
>> its not a good solution.
>> I'll do some other tests and keep you informed.
>>
>> "tim" <tbush@.ccmsi.com> wrote in message
>> news:1141664357.097038.87240@.i40g2000cwc.googlegroups.com...
>> >I have the same type of question...I need to be able to pass parameters
>> > (userid) back to my model due to security setup in our system...we have
>> > several 'user-access' tables for varying levels of security. For
>> > example, any given user has access to specific accounts, but only
>> > certain members within that account and only specific coverages within
>> > those members. I don't see how I can set this up using roles but
>> > perhaps I'm just missing it.
>> >
>>|||Thanks Bob...I look forward to it...I am stumped.
J=E9j=E9 wrote:
> thanks!
> your blog appear to be great and usefull.
> favorites favorites... ;-)
> "Bob Meyers - MSFT" <BobMeyersMSFT@.discussions.microsoft.com> wrote in
> message news:D083E8EC-F89C-4E6A-AE99-0BEFDE4F877B@.microsoft.com...
> >I will be posting an entry on my blog (http://blogs.msdn.com/bobmeyers)
> > shortly explaining how to use security filters.
> >
> > FYI, the incorrect behavior of the GETUSERID() function is a known issue
> > that is fixed in SP1, which will be available shortly.
> >
> > "J=E9j=E9" wrote:
> >
> >> the getuserid() function can be used... but... reportbuilder keep in
> >> cache
> >> the first user which access a filter object where the getuserid()
> >> function
> >> is used!!!
> >>
> >> so if an "administrator" try the model, then every other users use the
> >> same
> >> access!!!
> >> but using the getuserid() into reportbuilder himself (the user create a
> >> report and explicitly setup a filter) then the ID used is the right on=e,
> >> but
> >> its not a good solution.
> >>
> >> I'll do some other tests and keep you informed.
> >>
> >>
> >> "tim" <tbush@.ccmsi.com> wrote in message
> >> news:1141664357.097038.87240@.i40g2000cwc.googlegroups.com...
> >> >I have the same type of question...I need to be able to pass paramete=rs
> >> > (userid) back to my model due to security setup in our system...we h=ave
> >> > several 'user-access' tables for varying levels of security. For
> >> > example, any given user has access to specific accounts, but only
> >> > certain members within that account and only specific coverages with=in
> >> > those members. I don't see how I can set this up using roles but
> >> > perhaps I'm just missing it.
> >> >
> >>
> >>
> >>|||how can I get SQL userid into the model rather than the Windows ID?|||to use the SQL Server user id , use SQL servers syntaxes (suser_sname or
user_name and other user_id functions)
"tim" <bush.timothy@.gmail.com> wrote in message
news:1144296426.518067.71590@.i40g2000cwc.googlegroups.com...
> how can I get SQL userid into the model rather than the Windows ID?
>|||thanks...was finally able to use SUSER_SNAME(SUSER_SID()) to get what I
needed. Now I'm trying to get the filters to work with it.|||Note that with the SP1 version of BOL (which will be available for download
when SP1 is released), there is a tutorial that walks you through how to set
up security filters using the GetUserID().
"tim" wrote:
> Thanks Bob...I look forward to it...I am stumped.
> Jéjé wrote:
> > thanks!
> >
> > your blog appear to be great and usefull.
> > favorites favorites... ;-)
> >
> > "Bob Meyers - MSFT" <BobMeyersMSFT@.discussions.microsoft.com> wrote in
> > message news:D083E8EC-F89C-4E6A-AE99-0BEFDE4F877B@.microsoft.com...
> > >I will be posting an entry on my blog (http://blogs.msdn.com/bobmeyers)
> > > shortly explaining how to use security filters.
> > >
> > > FYI, the incorrect behavior of the GETUSERID() function is a known issue
> > > that is fixed in SP1, which will be available shortly.
> > >
> > > "Jéjé" wrote:
> > >
> > >> the getuserid() function can be used... but... reportbuilder keep in
> > >> cache
> > >> the first user which access a filter object where the getuserid()
> > >> function
> > >> is used!!!
> > >>
> > >> so if an "administrator" try the model, then every other users use the
> > >> same
> > >> access!!!
> > >> but using the getuserid() into reportbuilder himself (the user create a
> > >> report and explicitly setup a filter) then the ID used is the right one,
> > >> but
> > >> its not a good solution.
> > >>
> > >> I'll do some other tests and keep you informed.
> > >>
> > >>
> > >> "tim" <tbush@.ccmsi.com> wrote in message
> > >> news:1141664357.097038.87240@.i40g2000cwc.googlegroups.com...
> > >> >I have the same type of question...I need to be able to pass parameters
> > >> > (userid) back to my model due to security setup in our system...we have
> > >> > several 'user-access' tables for varying levels of security. For
> > >> > example, any given user has access to specific accounts, but only
> > >> > certain members within that account and only specific coverages within
> > >> > those members. I don't see how I can set this up using roles but
> > >> > perhaps I'm just missing it.
> > >> >
> > >>
> > >>
> > >>
>
Report Builder Question
Please help!!!!
We have recently implemented an SQL Server 2005 and when i click on the report builder button (reporting services) for the user i am getting the message "Application Download did not succeed. Check your network connection or contact your system administrator or Network Service Provider"
This is actually performed while the user has administrator privledges.
If someone has this problem or a solution, could you please post.
Thanks
This sounds like at authentication problem. If the logged-in user's default Windows credentials are not appropriate or sufficient for authenticating to the report server, then ClickOnce cannot download the application. In these cases (i.e. when you are not using Windows Auth), you need to go into IIS and allow anonymous access to the ReportBuilder virtual folder.
Hope that helps.
sqlReport Builder Permissions
Hi there,
I created a System Role: Report Builder User (checked "Execute Report Definitions")
Created a folder Home/FolderName/ReportModels
Created a Report Model, deployed it to the above folder.
The are a few users we would like them to run the report model, they belong to a windows group.
I assigned The "Report Builder User" to this Group.
The issue I have that when they run the Report Builder they get a login window (which then doesn't let them to continue).
I managed to overcome this by assiging to this group a "Browser" role at the Home level.
If I remove this assignment and set it in one level underneath the Home folder they can't run the Report Builder.
We don't want them to be able to view the folders at this level, Is there any other option besides setting the Browser role at the Home folder?
Thank you,
Itzhak
I believe users need to have at least Browser permission on all the parent folders of a given folder in addition to the folder itself. So yes, they will need to have permission to the Home folder. However, this will not (by itself) allow them to see subfolders of the Home folder to which they do not have permission. So you should still be able to hide the folders you don't want them to see.
Hope this helps!
|||That's what I thought.
Yes, it did help.
Thank you,
Itzhak
sqlReport Builder Parameter List empty
After building a report in report builder, I've set on of the filters to prompt for user input "in this list". When I run the report I get a drop down list with nothing in it. I can manually type in a value an run the report but I'd like to be able to select the parameter from the list.
I've also tried clicking on (no values selected) and selected all the available values...however this gives me the same results.
I also have the same problem...and have been searching for an answer...I know we fixed this or had a solution for this last year...and it may have something to do with the existing cardinalities in the Roles in the model...
But I'm still looking and trying to find a definite answer....
Tuesday, March 20, 2012
Report Builder not appearing in Report Server 2005 Web page
I have provided required permissions, still user not able to view report builder option in his console.
what could be wrong? what needs to be done to provide report builder to users.
Deleep P
Please review the link below and let us know if this fixes your issue.
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1697246&SiteID=1
|||
Thanks for that hint. I have an issue now regarding rights of system users. Now they have delete rights from Root directory. What needs to be done to avert this. I want system user be able to only modify his folders and contents.
Deleep P
|||Double-click on My Computer, right-click on the root-drive in question and select properties and then select the security tab. Highlight the Users group [ ex: Users(Servername\Users) ] ensure that only the Special Permission box has a checkmark in it. Then click on the Advanced button and this will bring you to the permission tab where you can specify the rights you wish your users to have on the root drive.
|||I think i misled you, after opening the webpage as follows "http://<report_server _ip>/reports " I get "HOME' page. Here i am creating folders. My intention is to create separate directories in the name of different teams first. Then provide complete access to the team within their folder. One team should not delete the folder created for another team from the home page. currently for all report server users i have given "System user" access through site SITE SETTING IN THE HOME PAGE. After clicking on the SITE SETTINGS I selected configure site wide security and provided "system user" rights to all report server users. Plus all users will have "folder view" rights on the HOME folder. this is provided through HOME PAGE, PROPERTIES, SECURITY, NEW ROLE ASSIGNMENT.
Report Builder not appearing in Report Server 2005 Web page
I have provided required permissions, still user not able to view report builder option in his console.
what could be wrong? what needs to be done to provide report builder to users.
Deleep P
Please review the link below and let us know if this fixes your issue.
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1697246&SiteID=1
|||
Thanks for that hint. I have an issue now regarding rights of system users. Now they have delete rights from Root directory. What needs to be done to avert this. I want system user be able to only modify his folders and contents.
Deleep P
|||Double-click on My Computer, right-click on the root-drive in question and select properties and then select the security tab. Highlight the Users group [ ex: Users(Servername\Users) ] ensure that only the Special Permission box has a checkmark in it. Then click on the Advanced button and this will bring you to the permission tab where you can specify the rights you wish your users to have on the root drive.
|||I think i misled you, after opening the webpage as follows "http://<report_server _ip>/reports " I get "HOME' page. Here i am creating folders. My intention is to create separate directories in the name of different teams first. Then provide complete access to the team within their folder. One team should not delete the folder created for another team from the home page. currently for all report server users i have given "System user" access through site SITE SETTING IN THE HOME PAGE. After clicking on the SITE SETTINGS I selected configure site wide security and provided "system user" rights to all report server users. Plus all users will have "folder view" rights on the HOME folder. this is provided through HOME PAGE, PROPERTIES, SECURITY, NEW ROLE ASSIGNMENT.
Monday, March 12, 2012
Report builder cannot be shown on other user login
Dear all specialists,
I am encountering a situation that the report buider feature cannot be shown on other user login. Would you guide me to solve this issue ?
Thanks for your help
Gary Ho
Gary,
For your user login, you will have to make sure that they have "Report Builder" under the "Edit Role Assignment". You will find this in your folder/properties area.
Ham
|||Hi Ham,
Thanks for your feedback and comments. The user profile under "Edit Role Assignment" already ticked the "Report Builder". Would you have any idea ?
Cheers,
Gary
Report builder and report models
Hi,
the database my app is using contains information from multiple user organisations, a sort of multi organisation database. I intend using the reprot builder to provide access to a user ine ach organisation. However the issue of who sees what info has popped up and i'm trying to think of a way to restict the user of report builder to only be able to see their own organisations information. This is a social services type application which is used by mutlitple service providers so organisations get twitchy about other organisations being able to see detailed client info. on the application the security stops this but at am a t a loss as to how to best restirct access to an organisation won client data.
any thoughts? is this somehting that can be configured through the reprt model and the report builder user account?
few ideas or advise would eb v helpful,
trhanks
Are you using SQL Server as the back end?
R
|||test. sorry to intrude.|||Repot Models can have security rights assigned to different piece within the model. You can set up Perspectives and assigned users or roles to those perspectives. Or you can assign rights to individual folders. This can be done not through the report model (or the report server), but by opening the Report Model's Properties in SQL Server Management Studio.
Hope this helps.
|||hi,
prev q answer - yes this is sql server 2005.
havn't come across perspectives but sounds v interesting. is that in SSRS or is it in SSAS?
i will check it out
many thanks
Report Builder and Custom Value in TextBox
a footer with a page number, date and the name of the user who's running the
report.Right click on the textbox and choose Expression. Everything you need is
under Globals. Well basic VB script knowledge is needed to put all together
though.
"SYoung" wrote:
> How can I add a custom value in a textbox. For example, I would like to add
> a footer with a page number, date and the name of the user who's running the
> report.|||When I right click on the textbox all I get is Format... option.
"Bing Bing Yu" wrote:
> Right click on the textbox and choose Expression. Everything you need is
> under Globals. Well basic VB script knowledge is needed to put all together
> though.
>
> "SYoung" wrote:
> > How can I add a custom value in a textbox. For example, I would like to add
> > a footer with a page number, date and the name of the user who's running the
> > report.|||Are you actually building your report in SQL Server BI Dev Studio?
"SYoung" wrote:
> When I right click on the textbox all I get is Format... option.
> "Bing Bing Yu" wrote:
> > Right click on the textbox and choose Expression. Everything you need is
> > under Globals. Well basic VB script knowledge is needed to put all together
> > though.
> >
> >
> > "SYoung" wrote:
> >
> > > How can I add a custom value in a textbox. For example, I would like to add
> > > a footer with a page number, date and the name of the user who's running the
> > > report.|||I'm actually using Report Builder. If you go to
"http://YourReportServer/Reports/", you'll be able to see "New Folder", "New
Data Source", "Upload File", And "Report Builder" below the two tabs
"Contents" & "Properties".
You may want to go to the links below to get more info about Report Builder.
http://www.microsoft.com/sql/technologies/reporting/default.mspx
http://www.developer.com/db/article.php/3520116
"Bing Bing Yu" wrote:
> Are you actually building your report in SQL Server BI Dev Studio?
> "SYoung" wrote:
> > When I right click on the textbox all I get is Format... option.
> >
> > "Bing Bing Yu" wrote:
> >
> > > Right click on the textbox and choose Expression. Everything you need is
> > > under Globals. Well basic VB script knowledge is needed to put all together
> > > though.
> > >
> > >
> > > "SYoung" wrote:
> > >
> > > > How can I add a custom value in a textbox. For example, I would like to add
> > > > a footer with a page number, date and the name of the user who's running the
> > > > report.|||You can actually enter RDL expressions in a Report Builder textbox -- just
start the text with "=". However, you are basically working blind, because
there is no direct visibility into report field names, textbox names, etc.
Also, page headers/footers are not supported in this release. Best bet is to
put the page count, report date, username, etc. at the top and bottom of the
report, so it will be on the first and last pages.
"SYoung" wrote:
> How can I add a custom value in a textbox. For example, I would like to add
> a footer with a page number, date and the name of the user who's running the
> report.
Friday, March 9, 2012
Report builder and custom security
model. We use application level authentication, in which a user ID and
password is verified against a record in the sql server database. So, we
don't use Windows Authentication. The problem is that we need to implement
the reporting builder as our ad-hoc reporting tool, but we need each user to
have his own private folder on the server. I've found only four articles on
http://msdn2.microsoft.com which talks about custom security extension, but
none of those is even close to what I'm looking for. I'm sure that there're
folks out there who've done this before.
Any suggestion or lead will be greatly appreciated.
Thanks,
Gilgameshhave you activated the "My Reports" option in reporting services?
this create a /My Reports folder and each user will have a private folder.
"Gilgamesh" <gilgamesh4ever@.aol.com> wrote in message
news:ONYLrGK0HHA.5644@.TK2MSFTNGP05.phx.gbl...
> We need to implement SQL Server 2005 Report Builder using our own security
> model. We use application level authentication, in which a user ID and
> password is verified against a record in the sql server database. So, we
> don't use Windows Authentication. The problem is that we need to implement
> the reporting builder as our ad-hoc reporting tool, but we need each user
> to have his own private folder on the server. I've found only four
> articles on http://msdn2.microsoft.com which talks about custom security
> extension, but none of those is even close to what I'm looking for. I'm
> sure that there're folks out there who've done this before.
> Any suggestion or lead will be greatly appreciated.
> Thanks,
> Gilgamesh
>|||Yes, I have. The problem is that My Reports works only if you use Windows
Autehtication. As I explained in the posting, we use database authetication.
-G
"Jeje" <willgart@.hotmail.com> wrote in message
news:Oz1e7LM0HHA.1164@.TK2MSFTNGP02.phx.gbl...
> have you activated the "My Reports" option in reporting services?
> this create a /My Reports folder and each user will have a private folder.
>
> "Gilgamesh" <gilgamesh4ever@.aol.com> wrote in message
> news:ONYLrGK0HHA.5644@.TK2MSFTNGP05.phx.gbl...
>> We need to implement SQL Server 2005 Report Builder using our own
>> security model. We use application level authentication, in which a user
>> ID and password is verified against a record in the sql server database.
>> So, we don't use Windows Authentication. The problem is that we need to
>> implement the reporting builder as our ad-hoc reporting tool, but we need
>> each user to have his own private folder on the server. I've found only
>> four articles on http://msdn2.microsoft.com which talks about custom
>> security extension, but none of those is even close to what I'm looking
>> for. I'm sure that there're folks out there who've done this before.
>> Any suggestion or lead will be greatly appreciated.
>> Thanks,
>> Gilgamesh
>>|||Have you implemented custom security in Reporting Services? I don't use
Report Builder but in the end you end up with a RDL just like if it had been
designed in Report Designer.
So, my question is, do you have your custom security implemented in any way
with RS? That is the first thing you will need to do.
http://msdn2.microsoft.com/en-us/library/ms152825.aspx
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Gilgamesh" <gilgamesh4ever@.aol.com> wrote in message
news:ercOBrW0HHA.4236@.TK2MSFTNGP06.phx.gbl...
> Yes, I have. The problem is that My Reports works only if you use Windows
> Autehtication. As I explained in the posting, we use database
> authetication.
> -G
> "Jeje" <willgart@.hotmail.com> wrote in message
> news:Oz1e7LM0HHA.1164@.TK2MSFTNGP02.phx.gbl...
>> have you activated the "My Reports" option in reporting services?
>> this create a /My Reports folder and each user will have a private
>> folder.
>>
>> "Gilgamesh" <gilgamesh4ever@.aol.com> wrote in message
>> news:ONYLrGK0HHA.5644@.TK2MSFTNGP05.phx.gbl...
>> We need to implement SQL Server 2005 Report Builder using our own
>> security model. We use application level authentication, in which a user
>> ID and password is verified against a record in the sql server database.
>> So, we don't use Windows Authentication. The problem is that we need to
>> implement the reporting builder as our ad-hoc reporting tool, but we
>> need each user to have his own private folder on the server. I've found
>> only four articles on http://msdn2.microsoft.com which talks about
>> custom security extension, but none of those is even close to what I'm
>> looking for. I'm sure that there're folks out there who've done this
>> before.
>> Any suggestion or lead will be greatly appreciated.
>> Thanks,
>> Gilgamesh
>>
>|||Bruce
ok, i need to do the same thing. But i am having some trouble with
configuring the secruity extension (Forms Authenication). i have an
question on the User Accounts database part.
The instructions say to replace the "LocalMachine" towards the end of
the createuserstore.sql. But i don't see any mention of that in the
script at all. Any ideas?
INSTRUCTIONS:
Locate "LocalMachine" towards the end of the script and replace it
with your own computer name. For Windows 2003 users, replace
LocalMachine\ASPNET with NT AUTHORITY\NETWORK SERVICE (except when in
IIS 5 compatibility mode).
createuserstore SCRIPT:
exec ('sp_grantlogin [' + @.ASPUserName + ']');
-- Add a database login for the UserAccounts database for the ASPNET
account
exec ('sp_grantdbaccess [' + @.ASPUserName + ']');
-- Grant execute permissions to the LookupUser and RegisterUser stored
procs
exec ('grant execute on LookupUser to [' + @.ASPUserName + ']');
exec ('grant execute on RegisterUser to [' + @.ASPUserName + ']');
------
Have you implemented custom security in Reporting Services? I don't
use
Report Builder but in the end you end up with a RDL just like if it
had been
designed in Report Designer.
So, my question is, do you have your custom security implemented in
any way
with RS? That is the first thing you will need to do.
http://msdn2.microsoft.com/en-us/library/ms152825.aspx
On Jul 29, 3:15 pm, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
wrote:
> Have you implemented custom security in Reporting Services? I don't use
> Report Builder but in the end you end up with a RDL just like if it had been
> designed in Report Designer.
> So, my question is, do you have your custom security implemented in any way
> with RS? That is the first thing you will need to do.http://msdn2.microsoft.com/en-us/library/ms152825.aspx
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Gilgamesh" <gilgamesh4e...@.aol.com> wrote in message
> news:ercOBrW0HHA.4236@.TK2MSFTNGP06.phx.gbl...
>
> > Yes, I have. The problem is that My Reports works only if you use Windows
> > Autehtication. As I explained in the posting, we use database
> > authetication.
> > -G
> > "Jeje" <willg...@.hotmail.com> wrote in message
> >news:Oz1e7LM0HHA.1164@.TK2MSFTNGP02.phx.gbl...
> >> have you activated the "My Reports" option in reporting services?
> >> this create a /My Reports folder and each user will have a private
> >> folder.
> >> "Gilgamesh" <gilgamesh4e...@.aol.com> wrote in message
> >>news:ONYLrGK0HHA.5644@.TK2MSFTNGP05.phx.gbl...
> >> We need to implement SQL Server 2005 Report Builder using our own
> >> security model. We use application level authentication, in which a user
> >> ID and password is verified against a record in the sql server database.
> >> So, we don't use Windows Authentication. The problem is that we need to
> >> implement the reporting builder as our ad-hoc reporting tool, but we
> >> need each user to have his own private folder on the server. I've found
> >> only four articles onhttp://msdn2.microsoft.comwhich talks about
> >> custom security extension, but none of those is even close to what I'm
> >> looking for. I'm sure that there're folks out there who've done this
> >> before.
> >> Any suggestion or lead will be greatly appreciated.
> >> Thanks,
> >> Gilgamesh- Hide quoted text -
> - Show quoted text -|||Sorry, I have not implemented this. I suggest a separate post specifically
about that. Also, you might want to post it at the web based forums as well.
http://forums.microsoft.com/msdn/showforum.aspx?forumid=82&siteid=1
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Ryan Swann" <swannryan@.gmail.com> wrote in message
news:1185807504.059515.124770@.57g2000hsv.googlegroups.com...
> Bruce
> ok, i need to do the same thing. But i am having some trouble with
> configuring the secruity extension (Forms Authenication). i have an
> question on the User Accounts database part.
> The instructions say to replace the "LocalMachine" towards the end of
> the createuserstore.sql. But i don't see any mention of that in the
> script at all. Any ideas?
>
> INSTRUCTIONS:
> Locate "LocalMachine" towards the end of the script and replace it
> with your own computer name. For Windows 2003 users, replace
> LocalMachine\ASPNET with NT AUTHORITY\NETWORK SERVICE (except when in
> IIS 5 compatibility mode).
> createuserstore SCRIPT:
>
> exec ('sp_grantlogin [' + @.ASPUserName + ']');
> -- Add a database login for the UserAccounts database for the ASPNET
> account
> exec ('sp_grantdbaccess [' + @.ASPUserName + ']');
> -- Grant execute permissions to the LookupUser and RegisterUser stored
> procs
> exec ('grant execute on LookupUser to [' + @.ASPUserName + ']');
> exec ('grant execute on RegisterUser to [' + @.ASPUserName + ']');
> ------
> Have you implemented custom security in Reporting Services? I don't
> use
> Report Builder but in the end you end up with a RDL just like if it
> had been
> designed in Report Designer.
> So, my question is, do you have your custom security implemented in
> any way
> with RS? That is the first thing you will need to do.
> http://msdn2.microsoft.com/en-us/library/ms152825.aspx
>
>
>
>
> On Jul 29, 3:15 pm, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
> wrote:
>> Have you implemented custom security in Reporting Services? I don't use
>> Report Builder but in the end you end up with a RDL just like if it had
>> been
>> designed in Report Designer.
>> So, my question is, do you have your custom security implemented in any
>> way
>> with RS? That is the first thing you will need to
>> do.http://msdn2.microsoft.com/en-us/library/ms152825.aspx
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Gilgamesh" <gilgamesh4e...@.aol.com> wrote in message
>> news:ercOBrW0HHA.4236@.TK2MSFTNGP06.phx.gbl...
>>
>> > Yes, I have. The problem is that My Reports works only if you use
>> > Windows
>> > Autehtication. As I explained in the posting, we use database
>> > authetication.
>> > -G
>> > "Jeje" <willg...@.hotmail.com> wrote in message
>> >news:Oz1e7LM0HHA.1164@.TK2MSFTNGP02.phx.gbl...
>> >> have you activated the "My Reports" option in reporting services?
>> >> this create a /My Reports folder and each user will have a private
>> >> folder.
>> >> "Gilgamesh" <gilgamesh4e...@.aol.com> wrote in message
>> >>news:ONYLrGK0HHA.5644@.TK2MSFTNGP05.phx.gbl...
>> >> We need to implement SQL Server 2005 Report Builder using our own
>> >> security model. We use application level authentication, in which a
>> >> user
>> >> ID and password is verified against a record in the sql server
>> >> database.
>> >> So, we don't use Windows Authentication. The problem is that we need
>> >> to
>> >> implement the reporting builder as our ad-hoc reporting tool, but we
>> >> need each user to have his own private folder on the server. I've
>> >> found
>> >> only four articles onhttp://msdn2.microsoft.comwhich talks about
>> >> custom security extension, but none of those is even close to what
>> >> I'm
>> >> looking for. I'm sure that there're folks out there who've done this
>> >> before.
>> >> Any suggestion or lead will be greatly appreciated.
>> >> Thanks,
>> >> Gilgamesh- Hide quoted text -
>> - Show quoted text -
>|||I got evreything working, let me know if someone needs some help with it
"Bruce L-C [MVP]" wrote:
> Sorry, I have not implemented this. I suggest a separate post specifically
> about that. Also, you might want to post it at the web based forums as well.
> http://forums.microsoft.com/msdn/showforum.aspx?forumid=82&siteid=1
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Ryan Swann" <swannryan@.gmail.com> wrote in message
> news:1185807504.059515.124770@.57g2000hsv.googlegroups.com...
> > Bruce
> >
> > ok, i need to do the same thing. But i am having some trouble with
> > configuring the secruity extension (Forms Authenication). i have an
> > question on the User Accounts database part.
> >
> > The instructions say to replace the "LocalMachine" towards the end of
> > the createuserstore.sql. But i don't see any mention of that in the
> > script at all. Any ideas?
> >
> >
> > INSTRUCTIONS:
> >
> > Locate "LocalMachine" towards the end of the script and replace it
> > with your own computer name. For Windows 2003 users, replace
> > LocalMachine\ASPNET with NT AUTHORITY\NETWORK SERVICE (except when in
> > IIS 5 compatibility mode).
> >
> > createuserstore SCRIPT:
> >
> >
> > exec ('sp_grantlogin [' + @.ASPUserName + ']');
> >
> > -- Add a database login for the UserAccounts database for the ASPNET
> > account
> > exec ('sp_grantdbaccess [' + @.ASPUserName + ']');
> >
> > -- Grant execute permissions to the LookupUser and RegisterUser stored
> > procs
> > exec ('grant execute on LookupUser to [' + @.ASPUserName + ']');
> > exec ('grant execute on RegisterUser to [' + @.ASPUserName + ']');
> >
> > ------
> > Have you implemented custom security in Reporting Services? I don't
> > use
> > Report Builder but in the end you end up with a RDL just like if it
> > had been
> > designed in Report Designer.
> >
> > So, my question is, do you have your custom security implemented in
> > any way
> > with RS? That is the first thing you will need to do.
> > http://msdn2.microsoft.com/en-us/library/ms152825.aspx
> >
> >
> >
> >
> >
> >
> >
> >
> > On Jul 29, 3:15 pm, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
> > wrote:
> >> Have you implemented custom security in Reporting Services? I don't use
> >> Report Builder but in the end you end up with a RDL just like if it had
> >> been
> >> designed in Report Designer.
> >>
> >> So, my question is, do you have your custom security implemented in any
> >> way
> >> with RS? That is the first thing you will need to
> >> do.http://msdn2.microsoft.com/en-us/library/ms152825.aspx
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "Gilgamesh" <gilgamesh4e...@.aol.com> wrote in message
> >>
> >> news:ercOBrW0HHA.4236@.TK2MSFTNGP06.phx.gbl...
> >>
> >>
> >>
> >> > Yes, I have. The problem is that My Reports works only if you use
> >> > Windows
> >> > Autehtication. As I explained in the posting, we use database
> >> > authetication.
> >> > -G
> >>
> >> > "Jeje" <willg...@.hotmail.com> wrote in message
> >> >news:Oz1e7LM0HHA.1164@.TK2MSFTNGP02.phx.gbl...
> >> >> have you activated the "My Reports" option in reporting services?
> >> >> this create a /My Reports folder and each user will have a private
> >> >> folder.
> >>
> >> >> "Gilgamesh" <gilgamesh4e...@.aol.com> wrote in message
> >> >>news:ONYLrGK0HHA.5644@.TK2MSFTNGP05.phx.gbl...
> >> >> We need to implement SQL Server 2005 Report Builder using our own
> >> >> security model. We use application level authentication, in which a
> >> >> user
> >> >> ID and password is verified against a record in the sql server
> >> >> database.
> >> >> So, we don't use Windows Authentication. The problem is that we need
> >> >> to
> >> >> implement the reporting builder as our ad-hoc reporting tool, but we
> >> >> need each user to have his own private folder on the server. I've
> >> >> found
> >> >> only four articles onhttp://msdn2.microsoft.comwhich talks about
> >> >> custom security extension, but none of those is even close to what
> >> >> I'm
> >> >> looking for. I'm sure that there're folks out there who've done this
> >> >> before.
> >>
> >> >> Any suggestion or lead will be greatly appreciated.
> >>
> >> >> Thanks,
> >> >> Gilgamesh- Hide quoted text -
> >>
> >> - Show quoted text -
> >
> >
>
>