Integrated Security to RS and SSAS not working

Hi,
Here's my setup:
1. ReportServer website is setup to use Integrated Authentication
2. I added a new user group (in computer management) called ReportAdmins
3. I used Management Studio to connect to my Reposting Services, at the top
level, I added the user group I just created, and gave it Content Manager
permissions.
4. I added an NT user to the group - ReportAdmins.
5. My datasources is an Analysis Services database, and is setup to use
Integrated Security. So I added the NT User to the OLAP Administrators group
as well. (Analysis Services and Reporting Services are all on the same
machine, running under the same service account that is an admin on the box)
Now I go to another machine, login with the NT User I specified above,
launch IE and the when I request the report I get an rsErrorExecutingCommand
- Query execution failed for data set 'abc'
What am I missing? I'ev searched other posts and I seem to have setup all
suggested access relevant to my situation, but somehow the reports aren't
working. If I make this NT USer the machine admin on the box hosting
ReportingServices, ANalysis Services etc, everything works fine (so at least
I know the reports work OK).
Any help is greatly appreciated.
Thanks.does the report works fine if you use the basic authentication instead-of
NTLM?
have you created a role in AS associated to the user group?
"Raghu" <Raghu@.discussions.microsoft.com> wrote in message
news:200FCBCA-570B-4AA1-AEB3-6321729D345D@.microsoft.com...
> Hi,
> Here's my setup:
> 1. ReportServer website is setup to use Integrated Authentication
> 2. I added a new user group (in computer management) called ReportAdmins
> 3. I used Management Studio to connect to my Reposting Services, at the
> top
> level, I added the user group I just created, and gave it Content Manager
> permissions.
> 4. I added an NT user to the group - ReportAdmins.
> 5. My datasources is an Analysis Services database, and is setup to use
> Integrated Security. So I added the NT User to the OLAP Administrators
> group
> as well. (Analysis Services and Reporting Services are all on the same
> machine, running under the same service account that is an admin on the
> box)
> Now I go to another machine, login with the NT User I specified above,
> launch IE and the when I request the report I get an
> rsErrorExecutingCommand
> - Query execution failed for data set 'abc'
> What am I missing? I'ev searched other posts and I seem to have setup all
> suggested access relevant to my situation, but somehow the reports aren't
> working. If I make this NT USer the machine admin on the box hosting
> ReportingServices, ANalysis Services etc, everything works fine (so at
> least
> I know the reports work OK).
> Any help is greatly appreciated.
> Thanks.|||Thank you for your response.
1. Basic Authentication cannot be used for the data source because AS
requires integrated authentication and if I specify basic authentication,
then I cannot use an NT account to connect to AS.
2. The role in AS for the user group is not necessary as the NTUsers in
that group are OLAP admins (in my test case below. I have only one NTUser and
he is an OLAP admin).
BTW, sorry for not mentioning this earlier - I am using RS2005 and SSAS2005.
"Jéjé" wrote:
> does the report works fine if you use the basic authentication instead-of
> NTLM?
> have you created a role in AS associated to the user group?
> "Raghu" <Raghu@.discussions.microsoft.com> wrote in message
> news:200FCBCA-570B-4AA1-AEB3-6321729D345D@.microsoft.com...
> > Hi,
> >
> > Here's my setup:
> > 1. ReportServer website is setup to use Integrated Authentication
> > 2. I added a new user group (in computer management) called ReportAdmins
> > 3. I used Management Studio to connect to my Reposting Services, at the
> > top
> > level, I added the user group I just created, and gave it Content Manager
> > permissions.
> > 4. I added an NT user to the group - ReportAdmins.
> > 5. My datasources is an Analysis Services database, and is setup to use
> > Integrated Security. So I added the NT User to the OLAP Administrators
> > group
> > as well. (Analysis Services and Reporting Services are all on the same
> > machine, running under the same service account that is an admin on the
> > box)
> >
> > Now I go to another machine, login with the NT User I specified above,
> > launch IE and the when I request the report I get an
> > rsErrorExecutingCommand
> > - Query execution failed for data set 'abc'
> >
> > What am I missing? I'ev searched other posts and I seem to have setup all
> > suggested access relevant to my situation, but somehow the reports aren't
> > working. If I make this NT USer the machine admin on the box hosting
> > ReportingServices, ANalysis Services etc, everything works fine (so at
> > least
> > I know the reports work OK).
> >
> > Any help is greatly appreciated.
> >
> > Thanks.
>
>|||Sorry, I misread the 'Basic Authentication' test to mean simple userid
password in RS data source setup. I was playing with IIS setup again and
found that there is a 'Basic Authentication' checkbox for security as well.
I tried the Basic Authentication and it prompts for userid and password. If
I provide the NT UserID and password that is the admin on the ReportServer
and AServer box, everything works fine, but if I use the regular user that I
added to the 'ReportUser' group, it doesn't work.
"Raghu" wrote:
> Thank you for your response.
> 1. Basic Authentication cannot be used for the data source because AS
> requires integrated authentication and if I specify basic authentication,
> then I cannot use an NT account to connect to AS.
> 2. The role in AS for the user group is not necessary as the NTUsers in
> that group are OLAP admins (in my test case below. I have only one NTUser and
> he is an OLAP admin).
> BTW, sorry for not mentioning this earlier - I am using RS2005 and SSAS2005.
> "Jéjé" wrote:
> > does the report works fine if you use the basic authentication instead-of
> > NTLM?
> > have you created a role in AS associated to the user group?
> >
> > "Raghu" <Raghu@.discussions.microsoft.com> wrote in message
> > news:200FCBCA-570B-4AA1-AEB3-6321729D345D@.microsoft.com...
> > > Hi,
> > >
> > > Here's my setup:
> > > 1. ReportServer website is setup to use Integrated Authentication
> > > 2. I added a new user group (in computer management) called ReportAdmins
> > > 3. I used Management Studio to connect to my Reposting Services, at the
> > > top
> > > level, I added the user group I just created, and gave it Content Manager
> > > permissions.
> > > 4. I added an NT user to the group - ReportAdmins.
> > > 5. My datasources is an Analysis Services database, and is setup to use
> > > Integrated Security. So I added the NT User to the OLAP Administrators
> > > group
> > > as well. (Analysis Services and Reporting Services are all on the same
> > > machine, running under the same service account that is an admin on the
> > > box)
> > >
> > > Now I go to another machine, login with the NT User I specified above,
> > > launch IE and the when I request the report I get an
> > > rsErrorExecutingCommand
> > > - Query execution failed for data set 'abc'
> > >
> > > What am I missing? I'ev searched other posts and I seem to have setup all
> > > suggested access relevant to my situation, but somehow the reports aren't
> > > working. If I make this NT USer the machine admin on the box hosting
> > > ReportingServices, ANalysis Services etc, everything works fine (so at
> > > least
> > > I know the reports work OK).
> > >
> > > Any help is greatly appreciated.
> > >
> > > Thanks.
> >
> >
> >|||I think the security is not correctly setup on the server
the reportuser group has not enough authorization on the server.
the error message will display where.
remember that AS2005 is more secure then AS2000, so you must authorize this
group to access the cubes through a role.
"Raghu" <Raghu@.discussions.microsoft.com> wrote in message
news:2DD1B7A0-764E-405B-A247-DDC5C26A4532@.microsoft.com...
> Sorry, I misread the 'Basic Authentication' test to mean simple userid
> password in RS data source setup. I was playing with IIS setup again and
> found that there is a 'Basic Authentication' checkbox for security as
> well.
> I tried the Basic Authentication and it prompts for userid and password.
> If
> I provide the NT UserID and password that is the admin on the ReportServer
> and AServer box, everything works fine, but if I use the regular user
> that I
> added to the 'ReportUser' group, it doesn't work.
> "Raghu" wrote:
>> Thank you for your response.
>> 1. Basic Authentication cannot be used for the data source because AS
>> requires integrated authentication and if I specify basic authentication,
>> then I cannot use an NT account to connect to AS.
>> 2. The role in AS for the user group is not necessary as the NTUsers in
>> that group are OLAP admins (in my test case below. I have only one NTUser
>> and
>> he is an OLAP admin).
>> BTW, sorry for not mentioning this earlier - I am using RS2005 and
>> SSAS2005.
>> "Jéjé" wrote:
>> > does the report works fine if you use the basic authentication
>> > instead-of
>> > NTLM?
>> > have you created a role in AS associated to the user group?
>> >
>> > "Raghu" <Raghu@.discussions.microsoft.com> wrote in message
>> > news:200FCBCA-570B-4AA1-AEB3-6321729D345D@.microsoft.com...
>> > > Hi,
>> > >
>> > > Here's my setup:
>> > > 1. ReportServer website is setup to use Integrated Authentication
>> > > 2. I added a new user group (in computer management) called
>> > > ReportAdmins
>> > > 3. I used Management Studio to connect to my Reposting Services, at
>> > > the
>> > > top
>> > > level, I added the user group I just created, and gave it Content
>> > > Manager
>> > > permissions.
>> > > 4. I added an NT user to the group - ReportAdmins.
>> > > 5. My datasources is an Analysis Services database, and is setup to
>> > > use
>> > > Integrated Security. So I added the NT User to the OLAP
>> > > Administrators
>> > > group
>> > > as well. (Analysis Services and Reporting Services are all on the
>> > > same
>> > > machine, running under the same service account that is an admin on
>> > > the
>> > > box)
>> > >
>> > > Now I go to another machine, login with the NT User I specified
>> > > above,
>> > > launch IE and the when I request the report I get an
>> > > rsErrorExecutingCommand
>> > > - Query execution failed for data set 'abc'
>> > >
>> > > What am I missing? I'ev searched other posts and I seem to have setup
>> > > all
>> > > suggested access relevant to my situation, but somehow the reports
>> > > aren't
>> > > working. If I make this NT USer the machine admin on the box hosting
>> > > ReportingServices, ANalysis Services etc, everything works fine (so
>> > > at
>> > > least
>> > > I know the reports work OK).
>> > >
>> > > Any help is greatly appreciated.
>> > >
>> > > Thanks.
>> >
>> >
>> >

Integrate PowerPoint and Reporting Services?

I am trying to move many of our group's monthly report functions from
Excel workbooks to a common Reporting Services environment, so data
will be visible to everyone at the end of the reporting period.
However, some of these slides have found their way into committee
meetings, which are driven entirely out of PowerPoint presentations.
I am being hit with a request to merge RS Reports with the existing
PowerPoint presentations. Unfortunately, while RS does render to the
screen, there is no easy way to copy the output to a file at a quality
level equivalent to what we had.
Right now, I can save my reports to Excel, then copy-paste the Range
into PowerPoint, but many times the built-in export fails to render
like the Report shows the data on the screen, often including cell
borders in Excel that were not specified in the HTML as well as other
spacing weirdness.
* Is there way I can include an embedded object in PowerPoint that
references a ReportViewer that pulls from the Reporting Server? The
Include Object menu in PP does not list this as an option.
* Is there a way to build a custom Render function to output the whole
page to a WMF (Windows MetaFile) format?
-- ScottOn Nov 9, 4:44 pm, Orne <polysilly...@.yahoo.com> wrote:
> I am trying to move many of our group's monthly report functions from
> Excel workbooks to a common Reporting Services environment, so data
> will be visible to everyone at the end of the reporting period.
> However, some of these slides have found their way into committee
> meetings, which are driven entirely out of PowerPoint presentations.
> I am being hit with a request to merge RS Reports with the existing
> PowerPoint presentations. Unfortunately, while RS does render to the
> screen, there is no easy way to copy the output to a file at a quality
> level equivalent to what we had.
> Right now, I can save my reports to Excel, then copy-paste the Range
> into PowerPoint, but many times the built-in export fails to render
> like the Report shows the data on the screen, often including cell
> borders in Excel that were not specified in the HTML as well as other
> spacing weirdness.
> * Is there way I can include an embedded object in PowerPoint that
> references a ReportViewer that pulls from the Reporting Server? The
> Include Object menu in PP does not list this as an option.
> * Is there a way to build a custom Render function to output the whole
> page to a WMF (Windows MetaFile) format?
> -- Scott
I can't speak directly to your scenario; however, you could either try
creating a custom renderer to render in Power Point from SSRS/
Reporting Services (http://msdn.microsoft.com/msdnmag/issues/05/02/
CustomRenderers/default.aspx ) -or- you could purchase a third party
tool (http://www.downloadjunction.com/product/software/135002/
index.html ). Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||On Nov 9, 7:01 pm, EMartinez <emartinez...@.gmail.com> wrote:
> I can't speak directly to your scenario; however, you could either try
> creating a custom renderer to render in Power Point from SSRS/
> Reporting Services (http://msdn.microsoft.com/msdnmag/issues/05/02/
> CustomRenderers/default.aspx ) -or- you could purchase a third party
> tool (http://www.downloadjunction.com/product/software/135002/
> index.html ). Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
Thanks, this is very promising!
-- Scott|||On Nov 12, 8:01 am, Orne <polysilly...@.yahoo.com> wrote:
> On Nov 9, 7:01 pm, EMartinez <emartinez...@.gmail.com> wrote:
> > I can't speak directly to your scenario; however, you could either try
> > creating a custom renderer to render in Power Point from SSRS/
> > Reporting Services (http://msdn.microsoft.com/msdnmag/issues/05/02/
> > CustomRenderers/default.aspx ) -or- you could purchase a third party
> > tool (http://www.downloadjunction.com/product/software/135002/
> > index.html ). Hope this helps.
> > Regards,
> > Enrique Martinez
> > Sr. Software Consultant
> Thanks, this is very promising!
> -- Scott
You're welcome. Let me know if I can be of further assistance.
Regards,
Enrique Martinez
Sr. Software Consultant

Integers & dynamic allocation

Here is what I am trying to do...
I want to goup "members" togethers in a "group."

A table for members and a table for groups.

each containing coluns...

but inside Groups I would like a column that contains ID numbers for the members that be long to that group.

Being that members can belong to multiple groups - I can not use a GroupID in Members - if so I also need a way of it modular.

Obvisiously I am not a very good DB programmer - but I want the least amount of empty/unused space in my tables.

Hope this makes senseyou need a third table (tblMemberGroups) that contains two columns

MemberID and GroupID

this table allow any member to belong to any number of groups and give you a normalized database structure (no wasted space).

you would need to create joins between all 3 tables to determine group membership

members -> tblMemberGroups -> groups

installing sql 7 from backoffice server 2000

Hi group.
I have on my computer installed sql server 6.5.
my computer runs windows nt 4.0.
Now am having backoffice server 2000 CDs.
I want to upgrade my sql server 6.5 to 7 only.
Pls tell me how.
I went to upgrade in the setup option of 6.5 it asked for
service park3. When i go through the readme file it says i
run service pack5.
Non of them works either way.
Pliz assist.
Thank you.Leno,
>> Pls tell me how.
See if these articles helps:
INF: Frequently Asked Questions - SQL Server 7.0 - Conversion
http://support.microsoft.com/default.aspx?scid=kb;en-us;195444
INF: Microsoft SQL Server 7.0 Preparedness Review (White Paper)
http://support.microsoft.com/default.aspx?scid=kb;en-us;323136
Dinesh.
SQL Server FAQ at
http://www.tkdinesh.com
"Leno" <leboy@.nationalbank.co.ke> wrote in message
news:0a0201c35db4$0e1b6a40$a401280a@.phx.gbl...
> Hi group.
> I have on my computer installed sql server 6.5.
> my computer runs windows nt 4.0.
> Now am having backoffice server 2000 CDs.
> I want to upgrade my sql server 6.5 to 7 only.
> Pls tell me how.
> I went to upgrade in the setup option of 6.5 it asked for
> service park3. When i go through the readme file it says i
> run service pack5.
> Non of them works either way.
> Pliz assist.
> Thank you.