Solved

SQL SERVER 2005 CANNOT GENERATE SSPI CONTEXT

Posted on 2010-08-23
2
387 Views
Last Modified: 2012-05-10
I am getting the following error when I try to register SQL Server from SSMS.
Background:
I changed the service account for the DB Engine and for the Agent from local to a domain account and restarted the services

Since then I am receiving: SQL SERVER 2005 CANNOT GENERATE SSPI CONTEXT when trying to reg the server form my desktop.

I am able to RDP to the server and use SSMS and register it okay.

Your help is appreciated.

Thanks,
Dan
0
Comment
Question by:dteshome
2 Comments
 
LVL 12

Accepted Solution

by:
mcv22 earned 250 total points
Comment Utility
It has to do with the SPN. Please follow steps outlined here : http://support.microsoft.com/kb/811889
0
 

Author Comment

by:dteshome
Comment Utility
Thank u for the reply.  What I did was to make the DB engine run under local system account and leave SQL Server agent to run under a domain service account; this enabled me to operate as before.

Thanks,
Dan
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Recently, when I was asked to create a new SQL 2005 cluster, Microsoft released a new service pack for MS SQL 2005 what is Service Pack 3. When I finished the installation of MS SQL 2005 I found myself troubled why the installation of SP3 failed …
by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, Just open a new email message.  In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now