Home > IT Answers > SQL Server > SQL 2005 and Security Account Delegation
alessandro.panzetta
9,695 pts.
 SQL 2005 and Security Account Delegation
Security Account Delegation, SQL 2000, SQL 2005
I read this feature for SQL2000 SP3 but I wonder if this is still valid for SQL2005 or, if it has changed which is the new feature that enables to retain the authentication credentials of the original client.

Software/Hardware used:
ASKED: October 3, 2008  4:04 PM
UPDATED: October 7, 2008  8:06 PM
RELATED QUESTIONS
Answer Wiki:
It sounds like you are asking about Windows Authentication, but I'm sure that I'm just misreading the question. About all that was introduced in SQL 2000 SP3 was Cross Database Chaining. Is that what you are referring to? This feature exists in SQL 2005 much as is did in SQL 2000.
Last Wiki Answer Submitted:  October 3, 2008  6:44 pm  by  Denny Cherry   64,520 pts.
All Answer Wiki Contributors:  Denny Cherry   64,520 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Hi MrDenny,
I have a problem when if a report is run directly on the ReportServer eveything works fine but if the same report is run from a client that is authenticated at domain level the same report fails by giving a rsProcessingAborted error so i thought it may be related to authentication in some way.

alessandro.panzetta
 9,695 pts.
 

Can you check the ERRORLOG of the SQL Server and tell me if you are seeing any errors about failed logins?

Denny Cherry
 64,520 pts.