On a Windows 7 system I have a copy of Sql Server 2008 R2 Express loaded. I want to access it via the sqlcmd and build some adhoc reports. The pass word is not avilable --
So I used Google and found a number of How To processes but none will work for me --
After I stop a, add the -m flag and restart the server I start a CMD box as administrator -
sqlcmd -S .\servername (Confirmed with osql -L)
And various combinations of these last three all get me errors messages but none of them let me enter sql commands to create a new user / grant authority..
Any tips from those here with more Windows / SQL server experience than I have..
One of the many similar guides to accomplish this..