Cannot Generate SSPI Context Error

If you are getting "Cannot generate SSPI context." error while trying to connect to an SQL server in your local area network, you should check your dns settings first. You can set or reset your dns settings using the batch commands in the following link:

http://redmilonga.blogspot.com/2008/03/batch-file-to-change-dns-servers.html