We are using:
Reporting Server 2005 (Seperate Server)
Reporting Database - 2000
Reporting Data Database - 2000 (This is where the report data will be
pulled from)
My account is a domain admin and all system belong to this same domain. I
can execute the query the report uses w/in Query Analyzer and can run the
report from VS. When I logon locally to the report server, I can run the
report as well.
However, when I run the report from the same sysetm I dev the report using
VS, I cannot view the report data in IE, however the report is displayed w/o
data. The report runs when I enter my credentials and select use Integrated
Security in Report Manager/Properties/Data Sources.
the problem is that I didnt think this should be the case. why isnt my
security information persisting to the report data.
[quoted text, click to view] "Kaisa M. Lindahl" <kaisaml@hotmail.com> wrote in message
news:emdy%2325BGHA.1092@TK2MSFTNGP09.phx.gbl...
> Are you trying to connect to SQL Server 2000 database, and are you in an
> Active Directory domain?
> You should be able to
> - Create a AD usergroup with all the users that are supposed to view the
> reports
> - Add this group as a login to SQL Server, and give it Read access to the
> datasource
> - Set up your datasource in Report Manager as Windows NT Integrated
> Security
> This way it should pick up the user name of the user logged in on the
> machine, check the AD properties of this user, and use them against the
> SQL Server, which will give the users the data they are entitled to see in
> the database.
>
> Alternatively, set up your datasource using "Credentials stored
> securely..." and use a SQL Server login that have the right access rights
> in your SQL Server database.
>
> Kaisa
>
>
> "Steve Wofford" <IntraRELY@yahoo.com> wrote in message
> news:%23zjMHQpBGHA.3936@TK2MSFTNGP12.phx.gbl...
>>I get this error message when connecting through IE to a report. We have a
>>sepererate Report Server and the database to which we are reporting from.
>>
>> When I go to the report server logged on using the same account as my
>> workstation I can access the report. I have tried making it a shared data
>> source with the same problem.
>>
>> The report does work if I enter my credentials and select use Integrated
>> Security in Report Manager/Properties/Data Sources. Is this required and
>> the only way to make it work??? This would seem to be a pain cause every
>> time a user changes thier password you would need to change it there as
>> well.
>>
>> TIA,
>>
>> Steve
>>
>
>
