Results 1 to 5 of 5
  1. #1
    Join Date
    Dec 2008
    Posts
    3

    Unanswered: i locked myself out of SQL Server engine

    I went into the <username> with Management Studio
    it had Login on Disabled in Security, i put it on Enabled i remember, after a while i moved it back to Disabled as i didn't notice any improvement with my problem. But to my surprise it said account disabled. Furthermore i can't login with anything else or the users i make from SQL configuration management. How do i reset this so i can log in to management studio and databases again please?

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    If you logged in as an administrator on the machine, you should be able to log into SQL Server.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  3. #3
    Join Date
    Dec 2008
    Posts
    3
    In windows auth mode it sais cannot connect to user: ".
    exactly like that: ".
    Because is not related to any trusted connections.

    And in SQL Auth mode it sais login failed for user: <myuser> and <my password> that i set for it from sql configuration manager.

    I don't know any default logins. I tried u:sa p:sa it didn't work.

    Know any others? If i repair or uninstall/install SQL Server will it be fixed? Any other way to reset this?

  4. #4
    Join Date
    Aug 2008
    Location
    India
    Posts
    55
    1. Is that SQL server running under local system account or any other other ,

    - If its running under local system account , create an id and add it to administrator group then you will be able to connect

    2.If SQL server is running under any other account , check whether u know the password and its having logon locally privilege at Os level , Try connecting SQL using that id , since if its running SQL server it must be having privilege at SQL server

  5. #5
    Join Date
    Dec 2008
    Posts
    3
    I can't test anymroe i reinstalled. Anything i tried back then gave me user is disabled, cannot log in. My new problem is that my site won't access the database with SQL Server 2008, only with 2005 Express... and i can't make large inserts with 2005 Express that i know of so i'm stuck between a rock and a hard place.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •