Cannot generate SSPI context

  • Hi,

    We have SQL server 2008 Development edition installed on one of our server. When I connect it with IP address using SSMS it gets connected but when I connect it using server name it gives below error:

    Cannot generate SSPI context.

    Kindly help.

  • What account is the SQL Server service running as, a domain account or local account? Sounds like it could be an SPN registration issue perhaps if the server and service are on the domain.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply