Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.

When I try to open my report in reporting services I get an error:
a.. An error has occurred during report processing. (rsProcessingAborted)
Get Online Help
a.. Cannot create a connection to data source 'Flyers'.
(rsErrorOpeningConnection) Get Online Help
a.. Cannot open database requested in login 'CRMElements_RealEstate'.
Login fails. Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
----
My report is set to use NT Authentication and Works OK in VS.Net report
designer.
Reporting services is installed on a web server separate from SQL Server.
The SQL Server house both the reporting services databases and the database
I am trying to report against. Both server or Windows 2003. The SQL server
is also my AD controller.
I can get the report to work if I change the report to use SQL Server login
/ password, but then I have to supply it each time.
If I go into the report properties, data sources and try to change the way
the report authenticates I get an error:
Object reference not set to an instance of an object.
when I click apply.
The only way I can change the settings is to change them in report designer
and re-upload my report file. I am uploading the file through report
manager. I do not have any data sources configures on the report server. I
am embedding this information in the report (I think that is how it works).
IIS Security is set as Integrated Windows Authentication.
Any help as to where to look or how to troubleshoot is appreciated.I think it doesn't work because you need to activate delegation, which i am
not knowledgeable about.
As far as i know, windows credential are never retransmitted from one server
to another. Here is a little attempt at explaining what i mean
client(ie) -> reporting services(iis) -> SQL DB (sql server)
suppose these 3 elements are on distinct servers. ie will transmit your
windows authentication to IIS, but IIS will not push it to the sql server.
For this to work, i've read you need to activate delegation in active
directory, but i am not knowledgeable enough to help you on this topic. So
right now, we're just specifying sql server accounts in our report data
sources.
You can use shared data sources to make life easier.
Hope this helps
"Joe" wrote:
> When I try to open my report in reporting services I get an error:
> a.. An error has occurred during report processing. (rsProcessingAborted)
> Get Online Help
> a.. Cannot create a connection to data source 'Flyers'.
> (rsErrorOpeningConnection) Get Online Help
> a.. Cannot open database requested in login 'CRMElements_RealEstate'.
> Login fails. Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
> ----
> My report is set to use NT Authentication and Works OK in VS.Net report
> designer.
> Reporting services is installed on a web server separate from SQL Server.
> The SQL Server house both the reporting services databases and the database
> I am trying to report against. Both server or Windows 2003. The SQL server
> is also my AD controller.
> I can get the report to work if I change the report to use SQL Server login
> / password, but then I have to supply it each time.
> If I go into the report properties, data sources and try to change the way
> the report authenticates I get an error:
> Object reference not set to an instance of an object.
> when I click apply.
> The only way I can change the settings is to change them in report designer
> and re-upload my report file. I am uploading the file through report
> manager. I do not have any data sources configures on the report server. I
> am embedding this information in the report (I think that is how it works).
> IIS Security is set as Integrated Windows Authentication.
> Any help as to where to look or how to troubleshoot is appreciated.
>
>
>|||Do a google search for the "double hop problem."
You need to enable Server Principal Names (SPNs) which can be a daunting
task to setup properly.
-Joel
"Joe" <noemail@.noemail.com> wrote in message
news:OpPELIUaFHA.2664@.TK2MSFTNGP15.phx.gbl...
> When I try to open my report in reporting services I get an error:
> a.. An error has occurred during report processing. (rsProcessingAborted)
> Get Online Help
> a.. Cannot create a connection to data source 'Flyers'.
> (rsErrorOpeningConnection) Get Online Help
> a.. Cannot open database requested in login 'CRMElements_RealEstate'.
> Login fails. Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
> ----
> My report is set to use NT Authentication and Works OK in VS.Net report
> designer.
> Reporting services is installed on a web server separate from SQL Server.
> The SQL Server house both the reporting services databases and the
> database I am trying to report against. Both server or Windows 2003. The
> SQL server is also my AD controller.
> I can get the report to work if I change the report to use SQL Server
> login / password, but then I have to supply it each time.
> If I go into the report properties, data sources and try to change the way
> the report authenticates I get an error:
> Object reference not set to an instance of an object.
> when I click apply.
> The only way I can change the settings is to change them in report
> designer and re-upload my report file. I am uploading the file through
> report manager. I do not have any data sources configures on the report
> server. I am embedding this information in the report (I think that is
> how it works).
> IIS Security is set as Integrated Windows Authentication.
> Any help as to where to look or how to troubleshoot is appreciated.
>
>
>|||Please excuse my ignorance, but could you specify exactly how you do the
"specifying sql server accounts in our report data sources"
Is it on the "Credentials stored securely in the report server" on the report?
How and where would you setup the user? In Report Server?
or in SQL server. It's been a while since I setup users on a database
in SQL 6.5 or 7.0... can you just use sa '
I've got what you described in your post of 2 connections
between 3 computers and connot get it to work.
Big Thanks for the Help!
--
Robert Hansen
"/dev/null" wrote:
> I think it doesn't work because you need to activate delegation, which i am
> not knowledgeable about.
> As far as i know, windows credential are never retransmitted from one server
> to another. Here is a little attempt at explaining what i mean
> client(ie) -> reporting services(iis) -> SQL DB (sql server)
> suppose these 3 elements are on distinct servers. ie will transmit your
> windows authentication to IIS, but IIS will not push it to the sql server.
> For this to work, i've read you need to activate delegation in active
> directory, but i am not knowledgeable enough to help you on this topic. So
> right now, we're just specifying sql server accounts in our report data
> sources.
> You can use shared data sources to make life easier.
> Hope this helps
> "Joe" wrote:
> > When I try to open my report in reporting services I get an error:
> > a.. An error has occurred during report processing. (rsProcessingAborted)
> > Get Online Help
> > a.. Cannot create a connection to data source 'Flyers'.
> > (rsErrorOpeningConnection) Get Online Help
> > a.. Cannot open database requested in login 'CRMElements_RealEstate'.
> > Login fails. Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
> >
> > ----
> >
> > My report is set to use NT Authentication and Works OK in VS.Net report
> > designer.
> >
> > Reporting services is installed on a web server separate from SQL Server.
> > The SQL Server house both the reporting services databases and the database
> > I am trying to report against. Both server or Windows 2003. The SQL server
> > is also my AD controller.
> >
> > I can get the report to work if I change the report to use SQL Server login
> > / password, but then I have to supply it each time.
> >
> > If I go into the report properties, data sources and try to change the way
> > the report authenticates I get an error:
> > Object reference not set to an instance of an object.
> > when I click apply.
> >
> > The only way I can change the settings is to change them in report designer
> > and re-upload my report file. I am uploading the file through report
> > manager. I do not have any data sources configures on the report server. I
> > am embedding this information in the report (I think that is how it works).
> >
> > IIS Security is set as Integrated Windows Authentication.
> >
> > Any help as to where to look or how to troubleshoot is appreciated.
> >
> >
> >
> >
> >
> >|||Well with some resource digging... I've gotten my self up
out of the ignoreance hole I was in. I figured out how to
setup a SQL User Account, under Security/Logins "New Login"
and then in Reporting Services for each report under Properties-
Data Sources I checked "Credentials stored securely in the report server"
and entered <new> UserName and Password.
and it worked.!!!!! Yeah ME!!!!
I also changed it in Report Designer on on the Data Source Credentials Tab,
Saved and redeployed, but that didn't seem to do it. Looks like it has to
be done
in Report Server.
Thanks!!! Bob
To
--
Robert Hansen
"Bob Hansen" wrote:
> Please excuse my ignorance, but could you specify exactly how you do the
> "specifying sql server accounts in our report data sources"
> Is it on the "Credentials stored securely in the report server" on the report?
> How and where would you setup the user? In Report Server?
> or in SQL server. It's been a while since I setup users on a database
> in SQL 6.5 or 7.0... can you just use sa '
> I've got what you described in your post of 2 connections
> between 3 computers and connot get it to work.
> Big Thanks for the Help!
> --
> Robert Hansen
>
> "/dev/null" wrote:
> > I think it doesn't work because you need to activate delegation, which i am
> > not knowledgeable about.
> >
> > As far as i know, windows credential are never retransmitted from one server
> > to another. Here is a little attempt at explaining what i mean
> >
> > client(ie) -> reporting services(iis) -> SQL DB (sql server)
> >
> > suppose these 3 elements are on distinct servers. ie will transmit your
> > windows authentication to IIS, but IIS will not push it to the sql server.
> > For this to work, i've read you need to activate delegation in active
> > directory, but i am not knowledgeable enough to help you on this topic. So
> > right now, we're just specifying sql server accounts in our report data
> > sources.
> >
> > You can use shared data sources to make life easier.
> >
> > Hope this helps
> >
> > "Joe" wrote:
> >
> > > When I try to open my report in reporting services I get an error:
> > > a.. An error has occurred during report processing. (rsProcessingAborted)
> > > Get Online Help
> > > a.. Cannot create a connection to data source 'Flyers'.
> > > (rsErrorOpeningConnection) Get Online Help
> > > a.. Cannot open database requested in login 'CRMElements_RealEstate'.
> > > Login fails. Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
> > >
> > > ----
> > >
> > > My report is set to use NT Authentication and Works OK in VS.Net report
> > > designer.
> > >
> > > Reporting services is installed on a web server separate from SQL Server.
> > > The SQL Server house both the reporting services databases and the database
> > > I am trying to report against. Both server or Windows 2003. The SQL server
> > > is also my AD controller.
> > >
> > > I can get the report to work if I change the report to use SQL Server login
> > > / password, but then I have to supply it each time.
> > >
> > > If I go into the report properties, data sources and try to change the way
> > > the report authenticates I get an error:
> > > Object reference not set to an instance of an object.
> > > when I click apply.
> > >
> > > The only way I can change the settings is to change them in report designer
> > > and re-upload my report file. I am uploading the file through report
> > > manager. I do not have any data sources configures on the report server. I
> > > am embedding this information in the report (I think that is how it works).
> > >
> > > IIS Security is set as Integrated Windows Authentication.
> > >
> > > Any help as to where to look or how to troubleshoot is appreciated.
> > >
> > >
> > >
> > >
> > >
> > >

Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'

I get the following error message when I select a report:

An error has occurred during report processing.

Cannot create a connection to data source 'PSS5'.

Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.

My Data source is set to Windows Integrated Security when I get this error message. If I change my data source to be "Credential supplied by the user running the report", the report generates fine. I am running SQL 2005 SP2. I have SQL reporting services installed on different server than my database services. Both servers are W2K3 R2 x64.

My IIS website and virtual directories are set up for Integrated Windows Authentication. My IIS application pool is set up to use an AD service account. I have followed the step/procedures outlined at: http://www.microsoft.com/technet/prodtechnol/windowsserver2003/technologies/security/tkerbdel.mspx

http://blogs.msdn.com/sql_protocols/archive/2005/10/12/479871.aspx
http://blogs.msdn.com/sql_protocols/archive/2006/08/10/694657.aspx

but to no avail. I am sure that I am missing something, but I can't figure out what. I would like to use Integrated Authentication, any ideas?

You are using allow anonymous in IIS. This means that your ReportViewer control is not passing the users credentials to the report server. If you want to use "allow anonymous" you will need to pass valid credentials to the report server. This can be done in your code that calls the Report Viewer control/Report Server.|||

Hi,

see more information about passing credentials programmatically here:

http://blogs.msdn.com/bimusings/archive/2005/11/05/489423.aspx

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||

I don't think that the problem is related to ReportViewer or IIS configuration (Since the credantial information is passed to the datasource and denied). When u select Windows Intedrated Security for report options, the credantials of the user that initiates the Reporting Services at every start up (by default this user is: 'NT AUTHORITY\ANONYMOUS LOGON') are sent to the datasource (And if this user is not authorized in the target database you get the following error).

You can authorize the Reporting Services user in the target database ('NT AUTHORITY\ANONYMOUS LOGON' exists within your SQL Server Machines Users.

or

You can change the Reporting Services' user to a domain user that both computers can authanticate.

Administrative Tools -> Services. (Find 'SQL Server Reporting Services (MSSQLSERVER)' change user from LOG ON tab.)

I hope this helps.

|||Thanks for the replies, but they didn't seem to help. To clear up a few questions, this report was developed in Visual Studio 2005 and it works fine in it. The report renders ok if I launch in on the server, but not anywhere else. My Reporting Services' user is an AD account that both my servers can authenicate against, and this user does have access to the DB. My Website and virtual directories have "allow anonymous access" unchecked.|||I decided to try one more thing. I went into the web.config file and changed the <identity impersonate="false"/> and that fixed it for me. Thanks for all the replies.|||

Note:

The above fix will force IIS to use the Application pool account to connect to SQL on the remote server.

This is still not the permanent solution that I am looking for, I believe my problem is a kerberos issue at this point. Any tips/hints/suggestions on troubleshooting this problem would be helpful.

sql

Login failed for user '(null)'

I'm getting the following error:
An error has occurred during report processing.
Cannot create a connection to data source 'MyReports-ReportServer-PHX'.
Login failed for user '(null)'. Reason: Not associated with a trusted SQL
Server connection.
This is only for data sources that use integrated authenticaiton. This is
on a fresh install of SQL Server 2005 and Reporting Services 2005 using
Visual Studio 2005. Per several articles/disuccsions, I've configured IIS
directory secruity to NOT allow anonymous access and to allow the Integrated
Windows Authentication exactly as I have on my other database server. This
is Windows Server 2003 IIS 6.0 and my other server is Windows 2000, IIS 5.0.
Any help would be GREATLY appreciated. Does this have something to do with
the IIS_WPG group not having correct permissions? The users do have the
correct permissions in my environment.Here's the stack trace as well from the reporting services error log...lots
of errors about the connection pool?
-- End of inner exception stack trace --
w3wp!webserver!1!01/24/2006-15:04:38:: e ERROR: Reporting Services error
Microsoft.ReportingServices.Diagnostics.Utilities.RSException: An error has
occurred during report processing. -->
Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An
error has occurred during report processing. -->
Microsoft.ReportingServices.ReportProcessing.ReportProcessingException:
Cannot create a connection to data source 'MyReports-ReportServer-PHX'. -->
System.Data.SqlClient.SqlException: Login failed for user '(null)'. Reason:
Not associated with a trusted SQL Server connection.
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
exception, Boolean breakConnection)
at
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject
stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior,
SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet
bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean
enlistOK)
at
System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection
owningObject, SqlConnectionString connectionOptions, String newPassword,
Boolean redirectedUserInstance)
at
System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity
identity, SqlConnectionString connectionOptions, Object providerInfo, String
newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
at
System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions
options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection
owningConnection)
at
System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection
owningObject)
at
System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection
owningObject)
at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection
owningObject)
at
System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection
owningConnection)
at
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection
outerConnection, DbConnectionFactory connectionFactory)
at System.Data.SqlClient.SqlConnection.Open()
at Microsoft.ReportingServices.DataExtensions.SqlConnectionWrapper.Open()
at
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.ReportRuntimeDataSourceNode.OpenConnection(DataSource
dataSourceObj, ReportProcessingContext pc)
-- End of inner exception stack trace --
at
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.ReportRuntimeDataSourceNode.Process()
at
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSourceNode.ProcessConcurrent(Object threadSet)
-- End of inner exception stack trace --
at
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.ProcessingContext.AbortHelper.ThrowAbortException(Int32 reportUniqueName)
at
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.ProcessingContext.CheckAndThrowIfAborted()
at
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.Merge.Process(ParameterInfoCollection parameters, Boolean mergeTran)
at
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.ProcessReport(Report report, ProcessingContext pc, ProcessingContext context)
at
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.ProcessReport(Report
report, ProcessingContext pc, Boolean snapshotProcessing, Boolean
processWithCachedData, GetReportChunk getChunkCallback, ErrorContext
errorContext, DateTime executionTime, CreateReportChunk cacheDataCallback,
ProcessingContext& context)
at
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderReport(IRenderingExtension
renderer, DateTime executionTimeStamp, GetReportChunk
getCompiledDefinitionCallback, ProcessingContext pc, RenderingContext rc,
CreateReportChunk cacheDataCallback, Boolean& dataCached)
at
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderReport(DateTime
executionTimeStamp, GetReportChunk getCompiledDefinitionCallback,
ProcessingContext pc, RenderingContext rc)
at
Microsoft.ReportingServices.Library.RSService.RenderAsLive(CatalogItemContext
reportContext, ItemProperties properties, ParameterInfoCollection
effectiveParameters, Guid reportId, ClientRequest session, String
description, ReportSnapshot intermediateSnapshot, DataSourceInfoCollection
thisReportDataSources, Boolean cachingRequested, Warning[]& warnings,
ReportSnapshot& resultSnapshotData, DateTime& executionDateTime,
RuntimeDataSourceInfoCollection& alldataSources, UserProfileState&
usedUserProfile)
at
Microsoft.ReportingServices.Library.RSService.RenderAsLiveOrSnapshot(CatalogItemContext
reportContext, ClientRequest session, Warning[]& warnings,
ParameterInfoCollection& effectiveParameters)
at
Microsoft.ReportingServices.Library.RSService.RenderFirst(CatalogItemContext
reportContext, ClientRequest session, Warning[]& warnings,
ParameterInfoCollection& effectiveParameters, String[]& secondaryStreamNames)
at Microsoft.ReportingServices.Library.RenderFirstCancelableStep.Execute()
at
Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
-- End of inner exception stack trace --
at
Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
at
Microsoft.ReportingServices.Library.RenderFirstCancelableStep.RenderFirst(RSService
rs, CatalogItemContext reportContext, ClientRequest session, JobType type,
Warning[]& warnings, ParameterInfoCollection& effectiveParameters, String[]&
secondaryStreamNames)
at
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport(HttpResponseStreamFactory streamFactory)
at
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.DoStreamedOperation(StreamedOperation operation)
at
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderItem(ItemType itemType)
at
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageContent()
at
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()

Login failed for user

Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.

Description:An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details:System.Data.SqlClient.SqlException: Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.

Source Error:

Line 15: Dim cmd As New SqlCommand
Line 16: con6 = New SqlConnection("Server=localhost;UID=sa;PWD=XXXX;Database=knowledge;integrated security=sspi")
Line 17: con6.Open()
Line 18: cmd.CommandText = "select Status from usr where Uid='" & txtUsername.Text & "' and Pass='" & txtPassword.Text & "'"
Line 19: cmd.Connection = con6

Source File:D:\Visual Studio 2005\Projects\WebApplication11\WebApplication11\login.aspx.vb Line:17

When I try the same code at my home computer it gives the same error as

Login failed for user 'BLACK-HULK\ASPNET'.

I am using XP at home and Server 2003 at the other computer, while debugging the application seems to be working fine dunno wat goes wrong while running it directly

I am not 100% sure, but when you use Integrated Security, the connection looks into windows and see who is logged on (basically). Thats why it says: LOGIN FAILED FOR USER 'BLACK-HULK\ASPNET.

As I see it, it gives no meaning of adding UID and PWD when you use Integrated Security.

Can you try removing Integratied security from you connectionstring.

|||

I would highly recommend against accessing your database with sa as a login. Also, as suggested before, using integrated security, kind of defeats the purpose of putting in a username and password ;)

HTH.

Peter

Login failed

I get this message using windows authentification. Any Ideas?
Reporting Services Error
----
An error has occurred during report processing. (rsProcessingAborted) Get
Online Help
Cannot create a connection to data source 'NKRIM105_DB'.
(rsErrorOpeningConnection) Get Online Help
Login failed for user '(null)'. Reason: Not associated with a trusted SQL
Server connection.
----
--
If you wait for an opportunity the opportunity will pass u by!Hi,
1) Please give your user approperiate access to database by add user to
database you are attempting to connect.
2) Your user must have appropriate access to reports deployed at report
server. Goto Report manager and add above user
Regards,
Ayaz Ahmad|||Hi,
1) Please give your user approperiate access to database by add user to
database you are attempting to connect.
2) Your user must have appropriate access to reports deployed at report
server. Goto Report manager and add above user
Regards,
Ayaz Ahmad