Last post Dec 04, 2013 03:31 AM by martinwang1985
Dec 03, 2013 04:18 AM|martinwang1985|LINK
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
Dec 04, 2013 12:54 AM|Starain chen - MSFT|LINK
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:
Dec 04, 2013 03:31 AM|martinwang1985|LINK
thank u very much for ur kindness reply
in fact my problem is there was problem with SPN.they are fixed now