SQL 2005 and Security Account Delegation
Home > IT Answers > SQL Server > SQL 2005 and Security Account Delegation
Alessandro.panzetta
9615 pts.
0
Q:
SQL 2005 and Security Account Delegation
SQL 2005, SQL 2000, Security Account Delegation
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.
ASKED: Oct 3 2008  4:04 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
Mrdenny
46795 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
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 Answered: Oct 3 2008  6:44 PM GMT by Mrdenny   46795 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

Alessandro.panzetta   9615 pts.  |   Oct 7 2008  8:08AM GMT

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.

 

Mrdenny   46795 pts.  |   Oct 7 2008  8:06PM GMT

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

 
0