SSRS Kerberos Authentication issue
As per the below post I have done all the settings But getting below error. http://social.technet.microsoft.com/Forums/en-US/sqlreportingservices/thread/d9299ae1-32ce-4b0f-ac01-81c44b43fd78 We have SSRS running as domain account "mydomain\ssrs_svc" and SQL2008 R2 running as domain account "mydomain\sql_svc". SQL2008 R@ is running AppName Instance name. SQL server name - > Host name - SqlServerBox - > Fully Qualified Name - SqlServerbox.win.org SSRS is intalled - Native mode On AD side for both the accounts Delegation tab -> Trust this user for delegation to any service is checked. SPN are set like below. setspn -a HTTP/ SqlServerBox:443 mydomain\ssrs_svc setspn -a MSSQLSvc/SqlServerBox:1433 RB\B1S01QE02 setspn -a HTTP/SqlServerbox.win.org :443 "mydomain\ssrs_svc setspn -a MSSQLSvc/SqlServerbox.win.org :1433 RB\B1S01QE02 On SSRS config file we have set the Reporting Services\ReportServer\rsreportserver.config file we have set the authentication <AuthenticationTypes> <RSWindowsNegotiate/> </AuthenticationTypes> It is kept on asking to type user name and password. After three times it just taking me to blank screen. On SSRS server event log I see below error. A Kerberos Error Message was received: on logon session Client Time: Server Time: 13:27:1.0000 5/16/2011 Z Error Code: 0xd KDC_ERR_BADOPTION Extended Error: 0xc00000bb KLIN(0) Client Realm: Client Name: Server Realm: Server Name: SqlServerbox.win.org Target Name: Error Text: File: 9 Line: d86 Error Data is in record data. Please let me know if you have any suggestions.Anekm
May 16th, 2011 10:06am

Hi Anekm, The same thread http://social.technet.microsoft.com/Forums/en-US/sqlreportingservices/thread/fe5f376d-fbf5-495e-9390-4cc5803ef141 Besides, you could click this link to get some reference about this same issue, http://blogs.msdn.com/b/lukaszp/archive/2008/03/26/solving-the-reporting-services-login-issue-in-the-february-ctp-of-sql-server-2008.aspx Thanks, Challen FuPlease remember to mark the replies as answers if they help and unmark them if they provide no help.
Free Windows Admin Tool Kit Click here and download it now
May 16th, 2011 9:55pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics