I forgot my sa password today for our Microsoft sql server :( - I knew roughly what it was, but needed to just keep trying until I hit the right answer... now it took me ages to find this wid google so I thought I'd share it....
On a sql box there is a command line client, so in DOS you can test you connection (i.e. username + password)
C:\\Documents and Settings\\\>osql -U sa
Password:
Login failed for user 'sa'.
C:\\Documents and Settings\\\>osql -U sa
Password:
1\>
2\>
oh yeah, as a side note I've put the template in place for my security section ;)