Remote access with Windows Autentication from SSMS 2012 failed

• ico-601891

  Hall of Fame

  Points: 3992

  More actions

  April 8, 2013 at 5:46 am

  #270681

  Hi.

  I'm receiving the next error message when i try connect from my computer with SSMS 2012 with windows authentication to my SQL Server 2012 SP1 database:

  "Cannot generate SSPI context. (Microsoft SQL Server, Error: 0)".

  The database services is running with a domain account. I can connect with windows authentication locally from the server.

  If i change the sql services account to 'local system' account i can connect ok from my computer remotely with SSMS 2012 with windows authentication.

  How i can configure my sql server service account with a domain account? What is the problem?

  Thanks.

• ico-601891

  Hall of Fame

  Points: 3992

  More actions

  April 8, 2013 at 8:00 am

  #1604417

  Hi.

  I solve the problem following the next explanation:

  http://social.msdn.microsoft.com/Forums/en-US/sqlsetupandupgrade/thread/e81c48cf-f3e1-4d8a-bbfd-051a2fb6a656.

  Thanks.