harriga.rabie-1008938 (11/3/2009)
this way is not good, because yoiu dont have the permission to connect just with sqlcmd -E, this way is not excat.You must add your login to local group created by installation sql
That is correct.
Also, using sqlcmd -E uses the trusted account you are logged into as your sql login. Well, if you are completely locked out, how would this work? If you could get in this way and had permissions to create logins, why couldn't you just login to sql management studio and just change the sa password?