Post reply

Forgotten password

  • March 16, 2006 at 5:48 am

    #168169

    Hi there,

    This may sound like a little stupid but I have forgotten the password that I entered when installing the ms sql 2005 server. Is there a way of finding the password/ username or overwriting it?

    Thanks in advance

  • March 16, 2006 at 6:58 am

    #626995

    SQL server has a builtin\administrators account. When connect to SQL server by windows authentication, all administartors of local computer will map to this sql account.

    So you can logon your computer (windows) with an account of local administrator, then connect to sql server by windows authentication, 

    In SSMS, run :

    ALTER

    LOGIN sa WITH PASSWORD = 'emtemt',CHECK_POLICY=OFF

    THis changes your password of sa to 'emtemt'

  • March 17, 2006 at 4:17 am

    #627234

    Thanks Old Hand,

    That worked out great.

Viewing 3 posts - 1 through 2 (of 2 total)

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