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

Windows logins cannot connect to sql instance Expand / Collapse
Author
Message
Posted Tuesday, April 2, 2013 3:04 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: Tuesday, October 14, 2014 8:26 AM
Points: 537, Visits: 1,923
hello, i have a sql 2005 instance in a two node cluster. the instance has mixed authentication, suddenly i started having erros with windows accounts trying to connect to server and i couldn't connect to server myself using my windows account. Seems like sql logins can connect; however i don't have a sql login with sa rights. I attempted to reboot my server and now my instance cannot get online, sql browser is up however my sql service and sql agent keeps failing with the below error:
Login failed for user "windows account"

can someone please tell me what should i check for?
Post #1437759
Posted Tuesday, April 2, 2013 6:25 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, May 30, 2014 8:15 AM
Points: 1,056, Visits: 2,687
Hello,

Is your windows account locked or password expired?




Regards
Durai Nagarajan
Post #1437860
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse