system
1
How can I control/modify the sa password for Avast service?
When I attemp to login in ADNM Console I receive this messagge “No connection could be made becouse the target machine actively refused it” and the service Avast Management service go down
Any help??
Thanks
system
2
Event Type: Error
Event Source: Service Control Manager
Event Category: None
Event ID: 7023
Date: 27/08/2004
Time: 12.50.59
User: N/A
Computer: SBS2003
Description:
The avast! Management Server service terminated with the following error:
%%42000
Vlk
3
Is there a correct license file entered?
system
4
Yes, the last for rc1a is valid up to 15 Sep 2004
system
5
I think there’s a problem with sa password…
What is the default sa password when I install ADNM Console with MSDE?
Vlk
6
The password is random generated. Why? Do you think it has changed?
Vlk
7
system
8
Please try using the version with enhanced logging, as described here: http://forum.avast.com/index.php?board=10;action=display;threadid=6521;start=msg50869#msg50869
Sorry, I don’t understand what I must do.
I think the sa password is empty, but in avast4.ini under Management Tools, there’s a voice with a long random Password.
Can you help me
Vlk
9
Try replacing the aswNeser.dll library and running the DebugView tool as described in that thread. It will show what went wrong…
Did this behavior start suddenly? Or does it behave like this from the beginning? (I.e. was it e.g. working properly yesterday?)
system
10
Ok, wait a minute. Thanks
system
11
Here is the result of debug:
00000001 0.00005596 [3424] before basCoInitialize()…
00000002 0.02717750 [3424] Initialize failed…
00000003 1.02592907 [3424] Initialize failed…
00000004 2.02596759 [3424] Initialize failed…
00000005 3.02595301 [3424] Initialize failed…
00000006 4.02591317 [3424] Initialize failed…
00000007 5.02677542 [3424] Initialize failed…
00000008 6.02603172 [3424] Initialize failed…
00000009 7.02611176 [3424] Initialize failed…
00000010 8.02615212 [3424] Initialize failed…
00000011 9.02623919 [3424] Initialize failed…
00000012 10.10425936 [3424] Initialize failed…
00000013 11.02523736 [3424] cleaning up sqlInit()…
00000014 11.02745486 [3424] quiting sqlInit()…
00000015 11.02830373 [3424] Setting quit event…
00000016 11.02835268 [3424] Destroying server object…
00000017 11.02840658 [3424] Freeing low level scheduler…
00000018 11.02885709 [3424] Closing quit event…
system
12
Did this behavior start suddenly? Or does it behave like this from the beginning? (I.e. was it e.g. working properly yesterday?)
Yestarday ADNM works fine.
This morning we installed another program with a db that works under MSDE, without modify any setting in MSDE.
In the last login in ADNM, I think I accidentaly remove sa password under File/Settings/SQL … but I’not sure.
Now the sa password is empty.
Vlk
13
Hmmm, I see…
BTW what happpens if you start the AMS Maintentance Tool, and check Test DB? Does that work???
system
14
AMS Database is not compatible! (0x0000A410)
system
15
Here is my avast4.ini configuration under SQL part:
[SQL]
DBCreated=1
DataSource=SBS2003\avast
Catalog=avast
User=sa
Password=b?TlRZNU5kcXo=
ObjectsCreated=1
UserId=sa
Vlk
16
There’s clearly a DB connection problem. 
There’s no solution for this at the moment. The AMS Tool will be soon updated to be able to change the DB connection details, but unfortunately, this is not possible with the current version… Sorry…
Anyway, I’m quite not sure how you managed to clear the password from the avast MSDE install… 
system
17
If I reinstall ADNM and the restore the db from backup?
Vlk
18
That should work I guess, provided you do have a backup.