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