My Scenario:
I Got error "Cannot generate SSPI context" in SQL, when I access
(machine1) Destination machine’s SQL instance from (machine2)Source Machine SQL instance.
I Got error "Cannot generate SSPI context" in SQL, when I access
(machine1) Destination machine’s SQL instance from (machine2)Source Machine SQL instance.
It works fine when I access using "sa" account but it happened only in Domain account.
Solution:
Check the below details,
1. The Domain Controller is On and accessible by the both SQL computers.
2. Time and TimeZone is synched with Domain Controller.
if not, run the below comments in cmd prompt to reset the time in both computers
net stop w32time
net start w32time
No comments:
Post a Comment