question of database server,for one user can use impersonate with delegation of kerberos but the other server cannot.thank u very much

Question

User444096333 posted

Hi

    may i ask a question

    i have asp net project and the deployed server is srv-deploy.this srv-deploy should access 2 different database server,we say srv-db1 and srv-db2.

   then the same asp net project, for srv-db1  it works well,can use impersonate.but for srv-db2,the logined user is always 'NT AUTHORITY\ANONYMOUS LOGON'.

  could u pls help me ?thank u very much(by the way for "srv-deploy."i have given delegation to delegation of kerberos)

 the error of event view is "Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. Reason: Token-based server access validation failed with an infrastructure "

  and i 'd like to add another point is:

 when in srv-deploy,in localhost ,the program can access both srv-db1 and srv-db2,but in the other machine it can only access srv-db1

thank u very much in advance

martin

Answer 1

User-1454326058 posted

Hi martinwang,

Thanks for your post!

According to your description, I think you are using the Windows Authentication to connect the database. I suggest that you could consider the SQL Authentication.

There are some related thread that may help you:

http://social.msdn.microsoft.com/Forums/sqlserver/en-US/0c999501-5394-4f24-986b-ba18293425b3/login-failed-for-user-nt-authorityanonymous-logon?forum=sqlreportingservices

http://forums.asp.net/t/1012271.aspx

Thanks

Best Regards

Answer 2

User444096333 posted

hi starain:

  thank u very much for ur kindness reply

  in fact my problem is there was problem with SPN.they are fixed now