August 18, 2004 at 7:00 am
Hi,
I want to start a delegation of authentication between the SQL Servers since I get an error trough an application that is running on Citrix, connecting to a SQL Server and from this one calling a stored procedures to the second one.
I get the error : Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
I made a delegations of the SQL Servers but stil not working. I cannot change the code, so I cannot use SQL user authentication (and I do not want too, security issues).
Can somebody who did the delegation explain me, step by step, how to do it?
I read some article how to do it but I'm a little confus and I have to give to my network administrator (who will do the delegation in our WIN 2003 domain)a very detailed and well explained liste with this steps.
Your help will be very appreciated.
Respectfully your,
Daniel Tipser
August 18, 2004 at 9:49 pm
The server in question has to be configured to be allowed to delegate (that would be the first SQL Server you're connecting to). In addition, the accounts would all have to be configured to allow delegation. Depending on the number of accounts, this could be a fair bit of work.
K. Brian Kelley
@kbriankelley
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply