locked
connection error RRS feed

  • Question

  • i have change password of windows server, I can't access sql server 
    Thursday, April 21, 2011 12:58 PM

Answers

  • Hi,

    I am assuming that, you have changed password for your windows login and then you are not able to connect to sql server.

    If this the case, Kindly check if sql server service is running or not. To do this go to

    Start Menu->SQL SERVER 2008(R2)->Sql server Configuration Manager->Configuration Tools->SQL Server Configuration Manager

    If service is not running, open service property and change account password. Then start the service.

    Kindly revert if this is not the case.


    - Chintak (My Blog)

    • Proposed as answer by Stephanie Lv Sunday, May 1, 2011 11:21 AM
    • Marked as answer by Stephanie Lv Tuesday, May 3, 2011 12:59 AM
    Thursday, April 21, 2011 1:12 PM

All replies

  • Hello,

    Logon to Sql Server with Windows Authentification works even after changing the password (you are using Windows Authentification, or?).

     Which excat error message including error & state number?


    Olaf Helper
    * cogito ergo sum * errare humanum est * quote erat demonstrandum *
    Wenn ich denke, ist das ein Fehler und das beweise ich täglich
    Blog Xing
    Thursday, April 21, 2011 1:08 PM
  • after restarting windows server can't logon  with Windows Authentification

    Thursday, April 21, 2011 1:12 PM
  • Hi,

    I am assuming that, you have changed password for your windows login and then you are not able to connect to sql server.

    If this the case, Kindly check if sql server service is running or not. To do this go to

    Start Menu->SQL SERVER 2008(R2)->Sql server Configuration Manager->Configuration Tools->SQL Server Configuration Manager

    If service is not running, open service property and change account password. Then start the service.

    Kindly revert if this is not the case.


    - Chintak (My Blog)

    • Proposed as answer by Stephanie Lv Sunday, May 1, 2011 11:21 AM
    • Marked as answer by Stephanie Lv Tuesday, May 3, 2011 12:59 AM
    Thursday, April 21, 2011 1:12 PM
  • Thanks

    Monday, May 23, 2011 12:40 PM