Login Failed for user '(null)' - Multiple Servers

Greets,
I realize that this is a common issue--however, the situation seems a bit
different. Or maybe I'm naive :) Anyway, I have two servers, one hosting
the data. The other only has what it takes to run SRS.
I loaded visual studio on the SRS server for ease of use. From there, I can
create, preview, and deploy any report I like. However, even from the local
IE, I can seem to pass through the authentication. I have removed anonymous
access to the reporting website--hoping to force authentication. I have
looked at all the Web.config files, all are set for impersonation = 'true'.
What am I missing here?
Thanks!Hi Joseph,
Thank you for your posting!
My understanding of this issue is: You can not view the Report via URL and
you get the Login Failed for user '(null)' error. If I misunderstood your
concern, please feel free to let me know.
It seems that the datasource credential does not set correctly. Please try
to do the following:
1. Open Report Manager via URL.
2. Find the report and click it.
3. Click Properties, and then click Data Sources.
4. If you are using custom data source, please click the Credentials
supplied by the user running the report.
5. If you are using shared data source, then go to the datasource, and
click it. Also click the Credentials supplied by the user running the
report.
6. If the login is a Windows Credential, please check the Use as Windows
credentials when connecting to the data source.
Please let me know the result so that I can provide further assistance.
Thank you!
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Thanks for the response,
However, I do not believe that this is the issue. I am using Windows
authentication only--so as far as I can determine, no creditials can be
specified. Also, the datasource works FINE inside visual studio.
This is an IIS issue, probably having to do with one of two things:
1. The SRS Servers's computer account needs to be Trusted for Delegation
2. I need to be running the SQL services as a Domain User account...this
second one is a little suspect, because I am using the database with an
Access 2003 frontend, and all the Windows authentication works well.
Any other thoughts?
"Wei Lu" <weilu@.online.microsoft.com> wrote in message
news:JOeiC7PlGHA.2260@.TK2MSFTNGXA01.phx.gbl...
> Hi Joseph,
> Thank you for your posting!
> My understanding of this issue is: You can not view the Report via URL and
> you get the Login Failed for user '(null)' error. If I misunderstood your
> concern, please feel free to let me know.
> It seems that the datasource credential does not set correctly. Please try
> to do the following:
> 1. Open Report Manager via URL.
> 2. Find the report and click it.
> 3. Click Properties, and then click Data Sources.
> 4. If you are using custom data source, please click the Credentials
> supplied by the user running the report.
> 5. If you are using shared data source, then go to the datasource, and
> click it. Also click the Credentials supplied by the user running the
> report.
> 6. If the login is a Windows Credential, please check the Use as Windows
> credentials when connecting to the data source.
> Please let me know the result so that I can provide further assistance.
> Thank you!
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ==================================================> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
>|||Hi Joseph,
Thank you for the information and clarification.
Let me know some information.
1. Could you access the Report Manager correctly?
2. Could you access the Report Server correctly?
3. If you could access the above site correctly, I don't think you need to
change the SQL Reporting Services start up account. Please try the method I
provided in the previous post and you could supply the Windows Credential
you use to connect to your database. ( I think it will be your domain
account or you windows login account. )
4. If you could not access the above site correctly, please let me know the
error message and so that I can provide further assistance. Thank you!
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi Joseph,
Have you get any chance to collect the information? Please feel free to let
me know if you have any question. Thank you!
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||I've had the same problem with my reports, and my solution seems to have
been the simplest:
When you deploy a report from VS, the data source sometimes gets messed up.
I created a new data source in Report Manager and changed my report to use
this one instead. Both are using Windows Integrated Authentication. My
report didn't work with the data source generated by VS, but it worked
without any problems with the new data source.
You can still upload reports to the server, and they will use the new data
source, so you only have to do this once (at least once with every new
report).
I don't know why the data sources gets messed up. But it seems to fix my
problem. I found the clue in a news group post, so it has probably solved
the problem for someone else as well.
Kaisa M. Lindahl Lervik
"Joseph Baxter" <tanstaafl32@.newsgroups.nospam> wrote in message
news:uDTfE9IlGHA.1320@.TK2MSFTNGP04.phx.gbl...
> Greets,
> I realize that this is a common issue--however, the situation seems a bit
> different. Or maybe I'm naive :) Anyway, I have two servers, one hosting
> the data. The other only has what it takes to run SRS.
> I loaded visual studio on the SRS server for ease of use. From there, I
> can create, preview, and deploy any report I like. However, even from the
> local IE, I can seem to pass through the authentication. I have removed
> anonymous access to the reporting website--hoping to force authentication.
> I have looked at all the Web.config files, all are set for impersonation => 'true'.
> What am I missing here?
> Thanks!
>