Cannot create a connection to data source - SSRS 2005

I cannot get this error resolve either for myself or any users, and I'm
actually part of the Admin group! Furthermore, a user with whom I'm
tring allow to view this report keeps getting prompted for their
windows username and password. I thought that since this datasource
was set to Windows Authentification that it would just pass it through?
I'm pulling my hair out at this point:
Screen Shots:
http://www.webfound.net/datasource_connection.jpg
http://www.webfound.net/datasource_connection2.jpg
http://www.webfound.net/datasource_connection3.jpg
Also As far as I know, I've given proper permissions to the right
logins and right users on my SQL Databases and related stored procs
that the datasets (not datasource) run
An error has occurred during report processing.
Cannot create a connection to data source 'datasourcename'.
For more information about this error navigate to the report server on
the local server machine, or enable remote errorsWith windows authentication issue, there is a parameter in Internet
Explorer which can cause this. Goto Tools|Internet options|Security
then I think the problem is likely to be the Intranet Zone, but
depending on your setup it could be one of the others too. Anyway,
select the Intranet Zone then custom, scroll to the bottom and you
should see User Authentication, you've probably got it set to Prompt on
this particular PC. This seems to be the default on Windows 2000
machines.
You may also find Active Directory policies can override this setting,
when they reboot.
On the data source issue:
A bit of a long shot this, but try removing the hyphens '-' from the
datasource names. It's never a good idea to put these sorts of
characters in SQL related stuff (this is the voice of experience!).
Also, can you run it from BIDS? If you can, then it would suggest the
server you are deploying to cannot see the server containing the actual
datasource.
Also, it may be worth checking the datasource "file" on the report
server. Remember, when you deploy a report it won't overwrite a
datasource if it already exists, and if it's been changed on the server
in any way the report will use that instead. Having said that, viewing
your screenshots it doesn't look like this is the case.
My hunch is your report server can't gain access to the server with the
data. Maybe describing the server setup a bit more may shed some more
light on the issue.
Hope some of this helps.
Cheers
Chris
dba123 wrote:
> I cannot get this error resolve either for myself or any users, and
> I'm actually part of the Admin group! Furthermore, a user with whom
> I'm tring allow to view this report keeps getting prompted for their
> windows username and password. I thought that since this datasource
> was set to Windows Authentification that it would just pass it
> through?
> I'm pulling my hair out at this point:
> Screen Shots:
> http://www.webfound.net/datasource_connection.jpg
> http://www.webfound.net/datasource_connection2.jpg
> http://www.webfound.net/datasource_connection3.jpg
>
> Also As far as I know, I've given proper permissions to the right
> logins and right users on my SQL Databases and related stored procs
> that the datasets (not datasource) run
> An error has occurred during report processing.
> Cannot create a connection to data source 'datasourcename'.
> For more information about this error navigate to the report server on
> the local server machine, or enable remote errors