Error processing a report connecting to an external SQL db

I created a report that uses data from an external SQL Server database. I
specified Windows Authentication. My NT account has full rights on the
external SQL server. When I run a report with ''localhost'' in the URL, it
works fine. However, when I use the actual server name, it first prompts me
for NT login/password (which is fine), but then I get the following:
An error has occurred during report processing. (rsProcessingAborted)
Cannot create a connection do data source 'MyDataSource'.
(rsErrorOpeningConnection)
Login failed for user '(null)'. Reason: Not associated with a trusted SQL
Server connection.
My assumption after reading MS docs was that the Reporting Server would use
the current user's credentials to connect to the external data source, but
it's not happening.
Any ideas on how to fix this would be highly appreciated.
Thanks,
LeoHi Leo,
Did you find a solution to this? I have the same problem. Are running
Reporting Services/SQL Server 2005 and can not run reports which get data
from an external SQL Server 2000.
Thanks,
Soren
"LeoW" wrote:
> I created a report that uses data from an external SQL Server database. I
> specified Windows Authentication. My NT account has full rights on the
> external SQL server. When I run a report with ''localhost'' in the URL, it
> works fine. However, when I use the actual server name, it first prompts me
> for NT login/password (which is fine), but then I get the following:
> An error has occurred during report processing. (rsProcessingAborted)
> Cannot create a connection do data source 'MyDataSource'.
> (rsErrorOpeningConnection)
> Login failed for user '(null)'. Reason: Not associated with a trusted SQL
> Server connection.
> My assumption after reading MS docs was that the Reporting Server would use
> the current user's credentials to connect to the external data source, but
> it's not happening.
> Any ideas on how to fix this would be highly appreciated.
> Thanks,
> Leo|||Any answer on this? I am having this problem as well. I am still just
running 2000 though. I am able to open and connect with several other
reports. But I have one that is not connecting and getting this error when I
click on the data tab. When I create the data source and test the
connection, it says it connects successfully.
Please someone answer this questions!!!!!!!!!!!!! :)
"LeoW" wrote:
> I created a report that uses data from an external SQL Server database. I
> specified Windows Authentication. My NT account has full rights on the
> external SQL server. When I run a report with ''localhost'' in the URL, it
> works fine. However, when I use the actual server name, it first prompts me
> for NT login/password (which is fine), but then I get the following:
> An error has occurred during report processing. (rsProcessingAborted)
> Cannot create a connection do data source 'MyDataSource'.
> (rsErrorOpeningConnection)
> Login failed for user '(null)'. Reason: Not associated with a trusted SQL
> Server connection.
> My assumption after reading MS docs was that the Reporting Server would use
> the current user's credentials to connect to the external data source, but
> it's not happening.
> Any ideas on how to fix this would be highly appreciated.
> Thanks,
> Leo|||+1. I am hitting the same issue as well. Does any one have a solution for this?
Thanks
Sushmitha
"SharinDenver" wrote:
> Any answer on this? I am having this problem as well. I am still just
> running 2000 though. I am able to open and connect with several other
> reports. But I have one that is not connecting and getting this error when I
> click on the data tab. When I create the data source and test the
> connection, it says it connects successfully.
> Please someone answer this questions!!!!!!!!!!!!! :)
> "LeoW" wrote:
> > I created a report that uses data from an external SQL Server database. I
> > specified Windows Authentication. My NT account has full rights on the
> > external SQL server. When I run a report with ''localhost'' in the URL, it
> > works fine. However, when I use the actual server name, it first prompts me
> > for NT login/password (which is fine), but then I get the following:
> > An error has occurred during report processing. (rsProcessingAborted)
> > Cannot create a connection do data source 'MyDataSource'.
> > (rsErrorOpeningConnection)
> > Login failed for user '(null)'. Reason: Not associated with a trusted SQL
> > Server connection.
> >
> > My assumption after reading MS docs was that the Reporting Server would use
> > the current user's credentials to connect to the external data source, but
> > it's not happening.
> >
> > Any ideas on how to fix this would be highly appreciated.
> >
> > Thanks,
> > Leo|||Was this ever resolved? I see that the last post was posted a few months ago.
I am looking for a soltuion to the following:
Server A is the Web, SQL, and RS Server (2k all around). No issues with
reports.
Server B is a 2nd SQL box (2k as well.)
I create a report in VS 2k03 and can preview it no problem using a shared
data source with stored credentials.
When i deploy the report and try to generate it via Report Mgr, I get
"Cannot create a connection to data source..."
Any hints?
Much appreciated.
"Sushmitha Kini" wrote:
> +1. I am hitting the same issue as well. Does any one have a solution for this?
> Thanks
> Sushmitha
> "SharinDenver" wrote:
> > Any answer on this? I am having this problem as well. I am still just
> > running 2000 though. I am able to open and connect with several other
> > reports. But I have one that is not connecting and getting this error when I
> > click on the data tab. When I create the data source and test the
> > connection, it says it connects successfully.
> >
> > Please someone answer this questions!!!!!!!!!!!!! :)
> >
> > "LeoW" wrote:
> >
> > > I created a report that uses data from an external SQL Server database. I
> > > specified Windows Authentication. My NT account has full rights on the
> > > external SQL server. When I run a report with ''localhost'' in the URL, it
> > > works fine. However, when I use the actual server name, it first prompts me
> > > for NT login/password (which is fine), but then I get the following:
> > > An error has occurred during report processing. (rsProcessingAborted)
> > > Cannot create a connection do data source 'MyDataSource'.
> > > (rsErrorOpeningConnection)
> > > Login failed for user '(null)'. Reason: Not associated with a trusted SQL
> > > Server connection.
> > >
> > > My assumption after reading MS docs was that the Reporting Server would use
> > > the current user's credentials to connect to the external data source, but
> > > it's not happening.
> > >
> > > Any ideas on how to fix this would be highly appreciated.
> > >
> > > Thanks,
> > > Leo