Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.</Message>

HI all ,
i am getting the following error message. <Message>Login failed for user
'NT AUTHORITY\ANONYMOUS LOGON'.</Message>
my database is on server1 and report database on server2. I am getting this
error when rendering. I am using default credentials
Please Help me.
<detail>
<ErrorCode
xmlns="http://www.microsoft.com/sql/reportingservices">rsProc
essingAborted</ErrorCode>
<HttpStatus
xmlns="http://www.microsoft.com/sql/reportingservices">400</
HttpStatus>
<Message xmlns="http://www.microsoft.com/sql/reportingservices">An
error
has occurred during report processing.</Message>
<HelpLink
xmlns="http://www.microsoft.com/sql/reportingservices">http://
go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Dia
gnostics.Utilities.ErrorStrings.resources.Strings&EvtID=rsProcessingAborted&
amp;ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=8.00</H
elpLink>
<ProductName
xmlns="http://www.microsoft.com/sql/reportingservices">Micr
osoft SQL Server Reporting Services</ProductName>
<ProductVersion
xmlns="http://www.microsoft.com/sql/reportingservices">8
.00.743.00</ProductVersion>
<ProductLocaleId
xmlns="http://www.microsoft.com/sql/reportingservices">
1033</ProductLocaleId>
<OperatingSystem
xmlns="http://www.microsoft.com/sql/reportingservices">
OsIndependent</OperatingSystem>
<CountryLocaleId
xmlns="http://www.microsoft.com/sql/reportingservices">
1033</CountryLocaleId>
<MoreInformation
xmlns="http://www.microsoft.com/sql/reportingservices">
<Source>Microsoft.ReportingServices.Processing</Source>
<Message msrs:ErrorCode="rsProcessingAborted"
msrs:HelpLink="http://go
.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagn
ostics.Utilities.ErrorStrings.resources.Strings&EvtID=rsProcessingAborted&am
p;ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=8.00" xml
ns:msrs="http://www.microsoft.com/sql/reportingservices">An error has
occurred d
uring report processing.</Message>
<MoreInformation>
<Source>Microsoft.ReportingServices.Processing</Source>
<Message msrs:ErrorCode="rsErrorOpeningConnection"
msrs:HelpLink="ht
tp://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingService
s.Diagnostics.Utilities.ErrorStrings.resources.Strings&EvtID=rsErrorOpeningC
onnection&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdV
er=8.00" xmlns:msrs="http://www.microsoft.com/sql/reportingservices">Cannot
crea
te a connection to data source 'HMIS_Interface'.</Message>
<MoreInformation>
<Source>.Net SqlClient Data Provider</Source>
<Message>Login failed for user 'NT AUTHORITY\ANONYMOUS
LOGON'.</Me
ssage>
</MoreInformation>
</MoreInformation>
</MoreInformation>
<Warnings xmlns="http://www.microsoft.com/sql/reportingservices" />
</detail>It looks like you are using Anoymous Authentication on your IIS Virtual
Directory. You can change the authentication to Basic or NTLM to pass in
user credentials.
--
| Thread-Topic: Login failed for user 'NT AUTHORITY\ANONYMOUS
LOGON'.</Message>
| thread-index: AcS8DqlvxtkWDhbwR8+PqdeSKelavg==| X-WBNR-Posting-Host: 202.56.199.242
| From: "=?Utf-8?B?bW9oYW4=?=" <mohan@.discussions.microsoft.com>
| Subject: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.</Message>
| Date: Wed, 27 Oct 2004 03:21:03 -0700
| Lines: 134
| Message-ID: <CBEB19F8-B211-468C-B282-BD1ECC6087E9@.microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
| Path: cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.reportingsvcs:33264
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| HI all ,
| i am getting the following error message. <Message>Login failed for user
| 'NT AUTHORITY\ANONYMOUS LOGON'.</Message>
|
| my database is on server1 and report database on server2. I am getting
this
| error when rendering. I am using default credentials
| Please Help me.
|
|
|
| <detail>
| <ErrorCode
| xmlns="rsProc">http://www.microsoft.com/sql/reportingservices">rsProc
| essingAborted</ErrorCode>
| <HttpStatus
| xmlns="400</">http://www.microsoft.com/sql/reportingservices">400</
| HttpStatus>
| <Message
xmlns="An">http://www.microsoft.com/sql/reportingservices">An
| error
| has occurred during report processing.</Message>
| <HelpLink
| xmlns="http://">http://www.microsoft.com/sql/reportingservices">http://
|
go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Dia
|
gnostics.Utilities.ErrorStrings.resources.Strings&EvtID=rsProcessingAborted&
|
amp;ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=8.00</H
| elpLink>
| <ProductName
| xmlns="Micr">http://www.microsoft.com/sql/reportingservices">Micr
| osoft SQL Server Reporting Services</ProductName>
| <ProductVersion
| xmlns="8">http://www.microsoft.com/sql/reportingservices">8
| .00.743.00</ProductVersion>
| <ProductLocaleId
| xmlns="">http://www.microsoft.com/sql/reportingservices">
| 1033</ProductLocaleId>
| <OperatingSystem
| xmlns="">http://www.microsoft.com/sql/reportingservices">
| OsIndependent</OperatingSystem>
| <CountryLocaleId
| xmlns="">http://www.microsoft.com/sql/reportingservices">
| 1033</CountryLocaleId>
| <MoreInformation
| xmlns="">http://www.microsoft.com/sql/reportingservices">
|
| <Source>Microsoft.ReportingServices.Processing</Source>
| <Message msrs:ErrorCode="rsProcessingAborted"
| msrs:HelpLink="http://go
|
microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagn
|
ostics.Utilities.ErrorStrings.resources.Strings&EvtID=rsProcessingAborted&am
| p;ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=8.00"
xml
| ns:msrs="An">http://www.microsoft.com/sql/reportingservices">An error has
| occurred d
| uring report processing.</Message>
| <MoreInformation>
| <Source>Microsoft.ReportingServices.Processing</Source>
| <Message msrs:ErrorCode="rsErrorOpeningConnection"
| msrs:HelpLink="ht
|
tp://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingService
|
s.Diagnostics.Utilities.ErrorStrings.resources.Strings&EvtID=rsErrorOpeningC
| onnection&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdV
| er=8.00"
xmlns:msrs="Cannot">http://www.microsoft.com/sql/reportingservices">Cannot
| crea
| te a connection to data source 'HMIS_Interface'.</Message>
| <MoreInformation>
| <Source>.Net SqlClient Data Provider</Source>
| <Message>Login failed for user 'NT AUTHORITY\ANONYMOUS
| LOGON'.</Me
| ssage>
| </MoreInformation>
| </MoreInformation>
| </MoreInformation>
| <Warnings xmlns="http://www.microsoft.com/sql/reportingservices"
/>
| </detail>
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
||||I am having the same problem as mohan.
I do not have Anonymous Authentication on the IIS Virtual Directory enabled.
Both the Reports and ReportServer folders are using windows integrated
security.
I have done a fresh install of Windows 2000 Server along with SQL Server
2000 Standard Editon and SQL Reporting Services Standard Edition. I have
also updated these to the relevant service packs.
From what I can gather the report server has no problems recognising
different domain users (with my folders enabled - a new folder is created for
the user that just navigated to the report server). Where it is having the
problem is then sending on those credentials to a SQL database on a different
server always get the 'NT AUTHORITY\ANONYMOUS LOGON' error message.
""Brad Syputa - MS"" wrote:
> It looks like you are using Anoymous Authentication on your IIS Virtual
> Directory. You can change the authentication to Basic or NTLM to pass in
> user credentials.
> --
> | Thread-Topic: Login failed for user 'NT AUTHORITY\ANONYMOUS
> LOGON'.</Message>
> | thread-index: AcS8DqlvxtkWDhbwR8+PqdeSKelavg==> | X-WBNR-Posting-Host: 202.56.199.242
> | From: "=?Utf-8?B?bW9oYW4=?=" <mohan@.discussions.microsoft.com>
> | Subject: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.</Message>
> | Date: Wed, 27 Oct 2004 03:21:03 -0700
> | Lines: 134
> | Message-ID: <CBEB19F8-B211-468C-B282-BD1ECC6087E9@.microsoft.com>
> | MIME-Version: 1.0
> | Content-Type: text/plain;
> | charset="Utf-8"
> | Content-Transfer-Encoding: 7bit
> | X-Newsreader: Microsoft CDO for Windows 2000
> | Content-Class: urn:content-classes:message
> | Importance: normal
> | Priority: normal
> | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
> | Newsgroups: microsoft.public.sqlserver.reportingsvcs
> | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
> | Path: cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl
> | Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.reportingsvcs:33264
> | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
> |
> | HI all ,
> | i am getting the following error message. <Message>Login failed for user
> | 'NT AUTHORITY\ANONYMOUS LOGON'.</Message>
> |
> | my database is on server1 and report database on server2. I am getting
> this
> | error when rendering. I am using default credentials
> | Please Help me.
> |
> |
> |
> | <detail>
> | <ErrorCode
> | xmlns="rsProc">http://www.microsoft.com/sql/reportingservices">rsProc
> | essingAborted</ErrorCode>
> | <HttpStatus
> | xmlns="400</">http://www.microsoft.com/sql/reportingservices">400</
> | HttpStatus>
> | <Message
> xmlns="An">http://www.microsoft.com/sql/reportingservices">An
> | error
> | has occurred during report processing.</Message>
> | <HelpLink
> | xmlns="http://">http://www.microsoft.com/sql/reportingservices">http://
> |
> go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Dia
> |
> gnostics.Utilities.ErrorStrings.resources.Strings&EvtID=rsProcessingAborted&
> |
> amp;ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=8.00</H
> | elpLink>
> | <ProductName
> | xmlns="Micr">http://www.microsoft.com/sql/reportingservices">Micr
> | osoft SQL Server Reporting Services</ProductName>
> | <ProductVersion
> | xmlns="8">http://www.microsoft.com/sql/reportingservices">8
> | .00.743.00</ProductVersion>
> | <ProductLocaleId
> | xmlns="">http://www.microsoft.com/sql/reportingservices">
> | 1033</ProductLocaleId>
> | <OperatingSystem
> | xmlns="">http://www.microsoft.com/sql/reportingservices">
> | OsIndependent</OperatingSystem>
> | <CountryLocaleId
> | xmlns="">http://www.microsoft.com/sql/reportingservices">
> | 1033</CountryLocaleId>
> | <MoreInformation
> | xmlns="">http://www.microsoft.com/sql/reportingservices">
> |
> | <Source>Microsoft.ReportingServices.Processing</Source>
> | <Message msrs:ErrorCode="rsProcessingAborted"
> | msrs:HelpLink="http://go
> |
> .microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagn
> |
> ostics.Utilities.ErrorStrings.resources.Strings&EvtID=rsProcessingAborted&am
> | p;ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=8.00"
> xml
> | ns:msrs="An">http://www.microsoft.com/sql/reportingservices">An error has
> | occurred d
> | uring report processing.</Message>
> | <MoreInformation>
> | <Source>Microsoft.ReportingServices.Processing</Source>
> | <Message msrs:ErrorCode="rsErrorOpeningConnection"
> | msrs:HelpLink="ht
> |
> tp://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingService
> |
> s.Diagnostics.Utilities.ErrorStrings.resources.Strings&EvtID=rsErrorOpeningC
> | onnection&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdV
> | er=8.00"
> xmlns:msrs="Cannot">http://www.microsoft.com/sql/reportingservices">Cannot
> | crea
> | te a connection to data source 'HMIS_Interface'.</Message>
> | <MoreInformation>
> | <Source>.Net SqlClient Data Provider</Source>
> | <Message>Login failed for user 'NT AUTHORITY\ANONYMOUS
> | LOGON'.</Me
> | ssage>
> | </MoreInformation>
> | </MoreInformation>
> | </MoreInformation>
> | <Warnings xmlns="http://www.microsoft.com/sql/reportingservices"
> />
> | </detail>
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
>