Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'
in [Reports]
|
From: Marek G. on 25 Mar 2010 15:41 Hi all , sorry for my english . I have trouble with eport services in the SQL 2008 and Win 2008 .An error occurred during client rendering. An error has occurred during report processing. Cannot create a connection to data source 'Portal'.Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. I have server with SQL 2008 report servicies , SQL 2008 Standart edition in the cluster server . But if I open report from server , where is RS , this work . If I try it from client the RS do not work . I have in the data source checked Windows integrated security.Connection string is : Data Source=frusldb4\instance4;Initial Catalog=Portal;Persist Security Info=True ... I set delegation for kerberos on te SQL server , ReportServer ..... Why this not work ?thanx for answer
From: Uri Dimant on 28 Mar 2010 03:03 Marek Change SSRS to be run under a domain account with appropriate permissions instead of 'NT AUTHORITY\ANONYMOUS LOGON' "Marek G." <grolms(a)volny.cz> wrote in message news:OWkMrMFzKHA.2436(a)TK2MSFTNGP04.phx.gbl... > Hi all , sorry for my english . I have trouble with eport services in the > SQL 2008 and Win 2008 .An error occurred during client rendering. An error > has occurred during report processing. Cannot create a connection to data > source 'Portal'.Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. > I have server with SQL 2008 report servicies , SQL 2008 Standart edition > in the cluster server . But if I open report from server , where is RS , > this work . If I try it from client the RS do not work . I have in the > data source checked Windows integrated security.Connection string is : > Data Source=frusldb4\instance4;Initial Catalog=Portal;Persist Security > Info=True .. I set delegation for kerberos on te SQL server , ReportServer > ..... Why this not work ?thanx for answer > > >
From: Kwai-Chang-Caine via SQLMonster.com on 28 Mar 2010 10:26 Seeing 'NT AUTHORITY\ANONYMOUS LOGON' is a sure sign of kerberos failure (misconfiguration). Start with Delegconfig tool here: http://www.iis.net/community/default.aspx?tabid=34&g=6&i=1434 to pinpoint your SPN's and which haven't been set properly. Marek G. wrote: >Hi all , sorry for my english . I have trouble with eport services in the >SQL 2008 and Win 2008 .An error occurred during client rendering. An error >has occurred during report processing. Cannot create a connection to data >source 'Portal'.Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. >I have server with SQL 2008 report servicies , SQL 2008 Standart edition in >the cluster server . But if I open report from server , where is RS , this >work . If I try it from client the RS do not work . I have in the data >source checked Windows integrated security.Connection string is : Data >Source=frusldb4\instance4;Initial Catalog=Portal;Persist Security Info=True >.. I set delegation for kerberos on te SQL server , ReportServer ..... Why >this not work ?thanx for answer -- Message posted via http://www.sqlmonster.com
From: Kwai-Chang-Caine via SQLMonster.com on 28 Mar 2010 10:38 The link i sent you is good, but here's a newer version -> http://blogs.technet.com/askds/archive/2009/04/30/deleconfig-v2-released.aspx Kwai-Chang-Caine wrote: >Seeing 'NT AUTHORITY\ANONYMOUS LOGON' is a sure sign of kerberos failure >(misconfiguration). >Start with Delegconfig tool here: >http://www.iis.net/community/default.aspx?tabid=34&g=6&i=1434 > to pinpoint your SPN's and which haven't been set properly. > >>Hi all , sorry for my english . I have trouble with eport services in the >>SQL 2008 and Win 2008 .An error occurred during client rendering. An error >[quoted text clipped - 7 lines] >>.. I set delegation for kerberos on te SQL server , ReportServer ..... Why >>this not work ?thanx for answer -- Message posted via SQLMonster.com http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-reporting/201003/1
From: Marek G. on 29 Mar 2010 03:16 I look to this server , the server not have instaled iis ... "Kwai-Chang-Caine via SQLMonster.com" <u58958(a)uwe> píše v diskusním příspěvku news:a5afe87aa2bd9(a)uwe... > The link i sent you is good, but here's a newer version -> > http://blogs.technet.com/askds/archive/2009/04/30/deleconfig-v2-released.aspx > > > > Kwai-Chang-Caine wrote: >>Seeing 'NT AUTHORITY\ANONYMOUS LOGON' is a sure sign of kerberos failure >>(misconfiguration). >>Start with Delegconfig tool here: >>http://www.iis.net/community/default.aspx?tabid=34&g=6&i=1434 >> to pinpoint your SPN's and which haven't been set properly. >> >>>Hi all , sorry for my english . I have trouble with eport services in the >>>SQL 2008 and Win 2008 .An error occurred during client rendering. An >>>error >>[quoted text clipped - 7 lines] >>>.. I set delegation for kerberos on te SQL server , ReportServer ..... >>>Why >>>this not work ?thanx for answer > > -- > Message posted via SQLMonster.com > http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-reporting/201003/1 >
|
Next
|
Last
Pages: 1 2 Prev: Change data starting point in chart Next: Scale Out install with mixed authentication |