Home > SQL Server basics > “Cannot generate SSPI context” error, when connecting to SQL Server from other machine using SSMS

“Cannot generate SSPI context” error, when connecting to SQL Server from other machine using SSMS

Friends, Some days back when I tried to connect to a SQL server instance using SSMS form one of the machine in same domain I got error ”Cannot generate SSPI context” , after struggling a lot and going through this support article not found a solution to make it work.

Finally solution found, the issue is because of different time set on both server and the machine where I was running SSMS. After setting same time on both the issue get resolved.

Happy coding.

Advertisements
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: