Cannot Generate SSPI Context - When changed Service Account - SQL Server 2008

1

I changed the service account used for MSSQLSERVER from Local System to a domain user account (domain\sql server)

When connecting to SSMS from my workstation, it came up with an error:

Cannot Generate SSPI Context - SQL Server 2008

If i connected using the SA account, I could get in, however, if I tried to save changes to my Maintenance Plan, it came up with the same error. (I'm sure there would be other operations that cause this error, I just used this as an example)

I also noticed I couldn't start SQL Server browser - Pops up error message:

the service cannote be started, either because it is disabled or because it has no enabled devices associated with it. [0x80070422]

I am using SQL Server 2008 Standard and Windows 2008, in case that is important....

sql-server
asked on Server Fault Jan 12, 2010 by alex

1 Answer

0

Does your domain user have access to the folder where the physical files are stored?

answered on Server Fault Jan 12, 2010 by baldy

User contributions licensed under CC BY-SA 3.0