Friday, March 23, 2012

Login failed for user '(null)'

Using RS2005 and SS2005. I am able to connect through a browser to
server/reports and run a report. However, another person is not able to run
the report. She gets the error: Cannot create a connection to data source
'dataSource1'. Login failed for user '(null)'. Reason: Not associated with a
trusted SQL Server connection.
She is an administrator both of the network and of the database where the
data is. I also made her a sysadmin of the database where reporting services
is located but that didn't make any difference.
I originally was getting the same error until I made the server a trusted
computer for delegation. That solved the problem for me but not for her.
Any ideas? Thanks,
--
Dan D.I figured it out. I was taking off the 'anonymous access' from the reports
and reportserver web sites but I needed to remove it from the 'default web
site'. Doing that made everything work.
--
Dan D.
"Dan D." wrote:
> Using RS2005 and SS2005. I am able to connect through a browser to
> server/reports and run a report. However, another person is not able to run
> the report. She gets the error: Cannot create a connection to data source
> 'dataSource1'. Login failed for user '(null)'. Reason: Not associated with a
> trusted SQL Server connection.
> She is an administrator both of the network and of the database where the
> data is. I also made her a sysadmin of the database where reporting services
> is located but that didn't make any difference.
> I originally was getting the same error until I made the server a trusted
> computer for delegation. That solved the problem for me but not for her.
> Any ideas? Thanks,
>
> --
> Dan D.sql

No comments:

Post a Comment