<div>
I was trying to use Windows authentication. &nbsp;It sounds like your suggestion was the way to go. &nbsp;I tried that and it worked so I'm rewarding you the points. &nbsp;Thanks for your quick reponse!
</div>


I was trying to use Windows authentication.  It sounds like your suggestion was the way to go.  I tried that and it worked so I'm rewarding you the points.  Thanks for your quick reponse!

<div>
<div class="content wysiwyg-content">
Hello,<br />
I just got done building some reports on my report server (local workstation, windows xp) that runs a report from a database hosted on a server 2003 box with SQL 2000 running on it. &nbsp;<br />
<br />
When my users go to the link I've provided them they get the following error:<br />
<br />
An error has occurred during report processing. (rsProcessingAborted) Get Online Help<br />
Cannot create a connection to data source 'HRSOURCE'. (rsErrorOpeningConnection)<wbr /> Get Online Help<br />
Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection. <br />
<br />
--------------------------<wbr />----------<wbr />----------<wbr />----------<wbr />----------<wbr />----------<wbr />----<br />
<br />
I added them to the security level for the report as a browser (through the web interface), and I gave them select permissions on the table in the database itself. &nbsp;Any thoughts?<br />
<br />
Thanks in advance!<br />
<br />
<br />
<br />

</div>
</div>


Hello,
I just got done building some reports on my report server (local workstation, windows xp) that runs a report from a database hosted on a server 2003 box with SQL 2000 running on it.  

When my users go to the link I've provided them they get the following error:

An error has occurred during report processing. (rsProcessingAborted) Get Online Help
Cannot create a connection to data source 'HRSOURCE'. (rsErrorOpeningConnection) Get Online Help
Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection. 

--------------------------------------------------------------------------------

I added them to the security level for the report as a browser (through the web interface), and I gave them select permissions on the table in the database itself.  Any thoughts?

Thanks in advance!





SQL Reporting Services, Cannot create a connection to data source login failed for user 'null'

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.