Saturday 15 March 2014

Error: Cannot generate SSPI context in SQL server

                         

 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.
 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