Issue: Got the error cannot generate SSPI context in 2008 sql, when I access
(machine1) Destination machine’s SQL instance from (machine2)Source Machine SQL instance.
(machine1) Destination machine’s SQL instance from (machine2)Source Machine SQL instance.
Solution: Checked the error machine<machine1> is remote accessible using machine name and got the below error.
Remote Desktop Connection fails - outdated entry in the DNS cache.
Took RDP using IP, Works fine and checked the time, the time was off by an hour.
Run the below comments in cmd
· net stop w32time
· net start w32time
The both the problem has been solved.
No comments:
Post a Comment