Testing my MS-SQL username and password
Tags: Blog, Security
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 
