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

Login failed for user '(null)'

Hi.

Im trying to make a couple of reports online for other people. My current setup is:

Machine A: SQL05 server.
Machine B: ReportingServer05 and IIS 5.0 (XP machine).
Machine C: Client trying to connect to Machine B and view a report. (Windows 2003)

On Machine B everything is working just fine, i can view my reports without any problems.
But if i try viewing a report on Machine C, I get the following error:

An error has occurred during report processing. (rsProcessingAborted) Get Online Help

Cannot create a connection to data source 'IntegrationDB'.

(rsErrorOpeningConnection) Get Online Help

Login failed for user '(null)'. Reason: Not associated with a trusted SQL

Server connection.
But machine C kan browse http://machine-b/ReportServer and se the list of reports hosted, its when trying to generate the reports there is a problem. Im logged in on machine C with the same user as on Machine B.

My Shared Data Source in this VS05 project is setup to be using Integrated Security, so the "user '(null)'" part looks like Machine C dosnt supply the username, but why?

What is it that im missing in my configuration?
And any addional information needed?

Best Regards.
Lasse Stig Thomsen

---

You are running into a double-hop issue. Make sure Kerberos is enabled and configured correctly (the "real" solution").

Another thing you might try (not really a fix, but avoiding the problem) is to hard-code the credentials in your data source versus using Windows Integration.

|||Hi thanks for the answer. It worked like a charm with both solutions.

thanks gain.

Login failed for user '(null)'

I have several reports using the same database with the same credentials
(using a specific Username and Password). All display fine, except for one
that gives me the following Reporting Services Error:
An error has occurred during report processing. (rsProcessingAborted) Get
Online Help
Cannot create a connection to data source 'BCSpotBonus'.
(rsErrorOpeningConnection) Get Online Help
Login failed for user '(null)'. Reason: Not associated with a trusted SQL
Server connection.
I've configured the data in the same way as the other reports and I've tried
using the "Shared database option" and not using the "Shared database
option." Nothing works. How can this be happening?That shouldnt be happening , but even i had the same
problem.
In the Report Designer try to delete the datasource and
then add it again and re deploy the report. Then try to
view the report.
Hope this helps!
>--Original Message--
>I have several reports using the same database with the
same credentials
>(using a specific Username and Password). All display
fine, except for one
>that gives me the following Reporting Services Error:
>An error has occurred during report processing.
(rsProcessingAborted) Get
>Online Help
>Cannot create a connection to data source 'BCSpotBonus'.
>(rsErrorOpeningConnection) Get Online Help
>Login failed for user '(null)'. Reason: Not associated
with a trusted SQL
>Server connection.
>I've configured the data in the same way as the other
reports and I've tried
>using the "Shared database option" and not using
the "Shared database
>option." Nothing works. How can this be happening?
>.
>

Login failed for user '(null)'

Hi.

Im trying to make a couple of reports online for other people. My current setup is:

Machine A: SQL05 server.
Machine B: ReportingServer05 and IIS 5.0 (XP machine).
Machine C: Client trying to connect to Machine B and view a report. (Windows 2003)

On Machine B everything is working just fine, i can view my reports without any problems.
But if i try viewing a report on Machine C, I get the following error:

An error has occurred during report processing. (rsProcessingAborted) Get Online Help Cannot create a connection to data source 'IntegrationDB'. (rsErrorOpeningConnection) Get Online Help Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
But machine C kan browse http://machine-b/ReportServer and se the list of reports hosted, its when trying to generate the reports there is a problem. Im logged in on machine C with the same user as on Machine B.

My Shared Data Source in this VS05 project is setup to be using Integrated Security, so the "user '(null)'" part looks like Machine C dosnt supply the username, but why?

What is it that im missing in my configuration?
And any addional information needed?

Best Regards.
Lasse Stig Thomsen

---

You are running into a double-hop issue. Make sure Kerberos is enabled and configured correctly (the "real" solution").

Another thing you might try (not really a fix, but avoiding the problem) is to hard-code the credentials in your data source versus using Windows Integration.

|||Hi thanks for the answer. It worked like a charm with both solutions.

thanks gain.

Login box displayed when browsing to ReportServer

Hi,
I have RS and SQL Server on the same development box. When I browse to
http://localhost/ I can see my reports on my box. However, when other
users browse to my machine with http://mymachinename/ they get a Windows
Login box pop up. When they type in their Windows Credentials, the box
pops up again. If they click cancel, they get "You are not authorized to
view this page."
How should I configure IIS to get this working? I've never used IIS or
Reporting Services before.
Thanks.
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.htmlIt sounds like a permissions issue. Try enabling anonymous access for the
website, and make sure that the virtual directories that IIS is using have
the proper permissions (at least read perms for the IIS account).
"Mark Allison" wrote:
> Hi,
> I have RS and SQL Server on the same development box. When I browse to
> http://localhost/ I can see my reports on my box. However, when other
> users browse to my machine with http://mymachinename/ they get a Windows
> Login box pop up. When they type in their Windows Credentials, the box
> pops up again. If they click cancel, they get "You are not authorized to
> view this page."
> How should I configure IIS to get this working? I've never used IIS or
> Reporting Services before.
> Thanks.
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602m.html
>|||Thanks Aaron, yes definitely a perms issue. This is how things are set up:
The error the user sees (different now from my earlier post):
http://tinyurl.com/58mty
IIS
===Authentication methods
http://tinyurl.com/46btf
Default web site properties
http://tinyurl.com/6l9ch
Reporting Services
==================RS Data sources
http://tinyurl.com/5wd78
RS Execution
http://tinyurl.com/3lqlq
RS Security
http://tinyurl.com/4p98j
Reporting Services, IIS and the SQL Server where the Reports database is
located are all on the box.
Thanks for looking into this.
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
Aaron Z wrote:
> It sounds like a permissions issue. Try enabling anonymous access for the
> website, and make sure that the virtual directories that IIS is using have
> the proper permissions (at least read perms for the IIS account).
> "Mark Allison" wrote:
>
>>Hi,
>>I have RS and SQL Server on the same development box. When I browse to
>>http://localhost/ I can see my reports on my box. However, when other
>>users browse to my machine with http://mymachinename/ they get a Windows
>>Login box pop up. When they type in their Windows Credentials, the box
>>pops up again. If they click cancel, they get "You are not authorized to
>>view this page."
>>How should I configure IIS to get this working? I've never used IIS or
>>Reporting Services before.
>>Thanks.
>>--
>>Mark Allison, SQL Server MVP
>>http://www.markallison.co.uk
>>Looking for a SQL Server replication book?
>>http://www.nwsu.com/0974973602m.html|||I've resolved this myself by using a standard SQL Login.
Thanks for your time.
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
Mark Allison wrote:
> Thanks Aaron, yes definitely a perms issue. This is how things are set up:
> The error the user sees (different now from my earlier post):
> http://tinyurl.com/58mty
> IIS
> ===> Authentication methods
> http://tinyurl.com/46btf
> Default web site properties
> http://tinyurl.com/6l9ch
>
> Reporting Services
> ==================> RS Data sources
> http://tinyurl.com/5wd78
> RS Execution
> http://tinyurl.com/3lqlq
> RS Security
> http://tinyurl.com/4p98j
>
> Reporting Services, IIS and the SQL Server where the Reports database is
> located are all on the box.
> Thanks for looking into this.
>