Cannot create a connection to data source 'dsInvent'

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,
SteveAre 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
>|||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.
"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
>