Token-based server access validation failed with an infrastructure

[ganesh_borase2]

Hello everybody,

we are planning to implement DR.

we are on ECC 6.0 with EHP 5 with windows 2008 + SQL 2008 environment.

I have implement the DR for  test purpose. for this following steps performed:

1. Activate the log shipping on the primary server and start the log shipping with a separarte monitor system.

2. SQL server service is running under the LocalSystem for both primary and secondary server.

But after some time it generate the alert. the error message is as:

  13-04-26 08:15:07.75 Logon       Login failed for user 'SAPDNS\TEST$'. Reason: Token-based server access validation failed with an infrastructure

I have then grant acceess to machine name to remote SQL server by

exec sp_grantlogin [SAPDNS\TEST$]

but still I am facing same problem.

I have solved the problem using the SQL server service account run under the domain account, but I dont want to run the service account under the domain account.

please suggest How to correct?

Thanks

Ganesh

[former_member184473]

Hello Ganesh,

Add the SAPDNS\TEST$ account directly to the SQL Server login (or a group that contains this account).

This should prevent the login error.

Check the following website for further information on Windows Managed and Virtual accounts:

http://weblogs.asp.net/owscott/archive/2010/04/21/managed-service-accounts-msa-and-virtual-accounts.aspx

Regards,

Eduardo Rezende

[ganesh_borase2]

Hi!

I solve problem by keeping the same password for the login user.

e.g if we use the Administrator account to login on the both server then you should have same password then you can connect both the SQL server .

Thanks for support.

[former_member184473]

Hi Ganesh,

If my answer helped you, please rate it as per .

Regards,

Eduardo