Avast WEBforum

Business Products => Archive (Legacy) => Avast Business => Avast Distributed Network Manager => Topic started by: userf on November 15, 2005, 10:22:51 AM

Title: reset password Unable to login as Administrator or connection error
Post by: userf on November 15, 2005, 10:22:51 AM

ok guys, i've found the way to reset admin password.
if you have Microsoft SQL Server installed, run Enterprise Manager, select 'avast' database, go  to 'Tables'. open table 'Users' and clear 'Password' field in the appropriate row

if you dont have Microsoft SQL Server client tools installed, you can use Access to reset password:
1) open Windows Control Panel,
2) select Administration
3) open ODBC Data sources
4) create File DSN 'avast.dsn' selecting appropriate SQL server and connection settings
5) run Access, File->Open, select 'ODBC' file type
6) select 'avast.dsn' in the opened dialog
7) select 'dbo.User' database table
8 open the table
9) clear 'Password' field
welcome to the Avast Admin Console!!!

please notify me if this info helped you: r0bust at yandex ddot ru

Title: Re: reset password Unable to login as Administrator or connection error
Post by: Vlk on November 15, 2005, 04:44:55 PM

Of course, but that assumes you have the sa password for the database... :)

Title: Re: reset password Unable to login as Administrator or connection error
Post by: userf on November 21, 2005, 11:14:01 AM

of course.
but if you can install adnm and deploy managed clients in the network of your enterprise, that assumes that you are administrator of the network and have enough rights to access all the servers and databases.

if not, who you are?  :)