Post reply

MSSQLSERVER Service is killing my Domain Account

  • December 18, 2006 at 10:01 am

    #171640

    FOr the past 5 Days I've been fighting with my PC which is XP on a domain and SQL2K. I recently changed my password (required by domain policy) and without noticing the correlation I was getting locked out of my account everytime I started the computer or tried going on a web site. Finally at the point where I've identified the culprit to be SQL Server with the assistance of the network guys. If I start the box with SQL SERVER disabled I have no problems, the moment I turn on the service, network guy see the invalid password attempt number fly to 5 and wham, lock out. Yes, I have the service running under Local System Account, doesn't have the "Allow service to interact with the desktop" checked though.  For the life in my I can't figure out what this has to do with my domain account and why it's locking me out. Even better, on the recovery tab I have all options set to take no action, so it shouldn't be incrementing the bad password attempts.

    Any ideas, ??? I'm desperate here, my boss is starting to question is decision on bringing me on board.

    Thanks,

    Santiago

  • December 18, 2006 at 1:49 pm

    #678803

    what happens if you start sqlserver with minimal config from the commandprompt ?

    sqlservr.exe -f

    look for startup procs and disable them

    Johan

    Learn to play, play to learn !

    Dont drive faster than your guardian angel can fly ...
    but keeping both feet on the ground wont get you anywhere :w00t:

    - How to post Performance Problems
    - How to post data/code to get the best help[/url]

    - How to prevent a sore throat after hours of presenting ppt

    press F1 for solution, press shift+F1 for urgent solution 😀

    Need a bit of Powershell? How about this

    Who am I ? Sometimes this is me but most of the time this is me

  • December 18, 2006 at 5:03 pm

    #678835

    Look for a job that is running as you. Check both the Owner on the General tab and Run As on the Steps>Advanced tab.

    If you find any, change them to (owner SA) and (Run As DBO).

    See if that resolves the issue.

    -SQLBill

  • December 19, 2006 at 12:24 pm

    #678973

    You say yjr SQL Server service is LocalSystem, how about the SQL Agent Service ?

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • December 19, 2006 at 12:59 pm

    #678985

    Another thing.....did you create any applications? If so, might they be running using your login/password?

    Again, stop the SQL Server Agent service. See if the problem continues. If it stops, then the problem is with a job. If it continues, then it's with an application or a user. Look at the Processes via Enterprise Manager (or do a sp_who2 in Query Analyzer). What is running and specifically, what is running as you? Then look at what other informatin is given, such as machine name. Track it down.

    -SQLBill

  • December 19, 2006 at 2:53 pm

    #678998

    Found the issue, it had nothing to do with SQL but SQL was the trigger that started the domino effect. It was a setting in Documentum Eroom (Portal similar to Sharepoint) that has a file share setting your provide a UserID and Password for. Apparently it had my old ID and Password for the domain. But since it relies on SQL to go read this setting it would happen only as a consequence of me enabling the SQL Server Service and then it would go and try to access the share repeatedly and wham, I'm locked out.

    THanks for all your help and I aplogize it was not SQL.

    Best Regards,

    Santiago

  • December 20, 2006 at 8:50 am

    #679140

    Congrats on resolving the issue and posting the solution. In the future it may help someone else who uses Documentum and SQL Server.

    -SQLBill

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply