How to reset admin password for Sophos NAC Advanced
September 17, 2008 by John Tran · 2 Comments
If you have forgotten the password to log onto your Sophos NAC Advanced console the run the following command in DOS Prompt.
osql -E -S \ -d SecurityStore -Q “update EF_Account set setPassword =’1′ where name =’Admin’”
This will also work for the Sophos NAC that is bundled with Endpoint Security and Control
There is however an error in the command you have posted, if you have installed the NAC databases to the default instance on the local machine the command should be:
osql -E -S .\ -d SecurityStore -Q “update EF_Account set setPassword =’1? where name =’Admin’”
If you have used a named instance, like when you install the integrated NAC databases, you generally have a sophos instance, the command should look like this:
osql -E -S .\SOPHOS -d SecurityStore -Q “update EF_Account set setPassword =’1? where name =’Admin’”
If you are not running the command locally on the machine where the NAC databases are hosted, you will need to replace the . for the server name, e.g.
osql -E -S server\SOPHOS -d SecurityStore -Q “update EF_Account set setPassword =’1? where name =’Admin’”
Oddly copy and paste went a bit wrong there, the ? in that command should be a ‘