Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Change SQL 2012 Service Account not fully function Expand / Collapse
Author
Message
Posted Tuesday, December 17, 2013 2:08 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, November 7, 2014 6:33 AM
Points: 6, Visits: 222
I have just installed SQL Server 2012 with default service account on Windows Server 2012 R2 Standard.

After i change the Service account to normal domain user from SQL Configuration Manager, i unable to connect to the DB server from my PC using my domain account.
it shows the error "Cannot generate SSPI context"

However, i can connect to DB via SSMS when i remote into the Server.

Anyone has resolution?
Post #1523569
Posted Tuesday, December 17, 2013 2:46 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Today @ 8:54 AM
Points: 3,085, Visits: 3,196
Hi
What is the status of the protocols: TCP/IP, Named pipes and Shared memory?




Igor Micev,
SQL Server developer at Seavus
www.seavus.com
Post #1523576
Posted Tuesday, December 17, 2013 2:49 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, November 7, 2014 6:33 AM
Points: 6, Visits: 222
Hi,
The status for TCP/IP, Named Pipes and Shared Memory are Enabled.
Post #1523577
Posted Tuesday, December 17, 2013 9:46 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: 2 days ago @ 3:23 PM
Points: 557, Visits: 1,637
When I receive the "Cannot generate SSPI context" it is when my domain account is locked out for some reason (another story) and cannot be authenticated. Was the change of Service Account part of other changes in the Active Directory archetecture? Is the service account and your account in the same domain, and if not, is there a properly configured trust? Did you recently reset your password and might there be a service or email app somewhere that tries to login with your old password and locks up your account?
Post #1523781
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse