SSPI error and Incorrect timing.


Recently, quite out of the blue I started seeing this error when I tried to log into my SQL instance using SQL SERVER Management Studio (SSMS)

Now, I could RDP to the server and connect to the local instance using SSMS, however any attempt to connect to the server from a remote client failed with the above error.

Now, the server was a VM, which had migrated to a new host fairly recently and as it turns out had picked up an incorrect time from that host.

After resetting the time and updating the time syncronization the error dissappeared.

As this was a non-production server, I had the luxuury of being able to re-start the sql instance and even machine pretty easily, but in case you see this issue in production it can be fixed with a reboot of any kind simply by making sure the time is correct.






About Martin Catherall

Martin Catherall is Senior SQL consultant at SQL Down Under, based in Melbourne, Australia. Martin is also a Microsoft Data Platform MVP and Regional Mentor (RM) for the Professional Association for SQL Server. Prior to relocating to Australia he was extremely active in the Christchurch, New Zealand data community - founding the local SQL Server user group and organizing SQL Saturday Christchurch - which later became SQL Saturday South Island. He likes learning interesting stuff about processing and storing data and passing on his knowledge. In his spare time he likes to learn guitar and hang out with his two young sons Callum Glen and Robert Michael.