Blog |Follow Nick on Twitter| About
 

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 ;)

rgds,

Nick

 
Nick Bettison ©