Avast WEBforum

Business Products => Archive (Legacy) => Avast Business => Avast Distributed Network Manager => Topic started by: Gia78 on June 30, 2006, 09:26:11 AM

Title: Login and DB problem
Post by: Gia78 on June 30, 2006, 09:26:11 AM

I can't login in ADNM.
I have check the db with AMS maintenance tool and i can't connect.
I suppose there is a problem in service "avast! Management Server" because is not started , when i try to start i receive the error 42000 : 0xa410. Do you know why ?
Thanks in advance
Gianluca

Title: Re: Login and DB problem
Post by: Vlk on June 30, 2006, 10:49:44 AM

Please post the contents of the file <ADNM>\data\log\error.log. Generally, if there's a problem with the service (not starting, crashing etc), this is the place to look first.

Title: Re: Login and DB problem
Post by: Gia78 on June 30, 2006, 11:03:08 AM

Error.log is attached, thanks

Title: Re: Login and DB problem
Post by: Vlk on June 30, 2006, 11:20:02 AM

Seems like a problem with the DB.
Please start the AMS Maintenance Tools, and trye the "DB Conn" and "Check DB" buttons...

Grazie
Vlk

Title: Re: Login and DB problem
Post by: Gia78 on June 30, 2006, 12:32:40 PM

This is the error when i perform "Check DB".
Grazie mille.
Ciao

Title: Re: Login and DB problem
Post by: Vlk on June 30, 2006, 01:11:39 PM

Try also "SQL Conn" -> "Test Connection".

BTW is this a MSDE or full SQL server install?

Ciao
Vlk

Title: Re: Login and DB problem
Post by: Gia78 on June 30, 2006, 01:21:50 PM

Is MSDE. The OS win 2003 SBS standard edition.
Ciao
Gianluca

Title: Re: Login and DB problem
Post by: Vlk on June 30, 2006, 01:27:07 PM

Is this a new install?

If so (i.e. it doesn't hold any data you don't want to lose), try reiniting the DB.

Use "Delete DB" and then "Create DB".


Thanks
Vlk

Title: Re: Login and DB problem
Post by: Gia78 on June 30, 2006, 01:32:46 PM

Other errors...
Thanks
Gia

Title: Re: Login and DB problem
Post by: Vlk on June 30, 2006, 01:35:58 PM

Strange indeed. And this is a fresh install of MSDE, installed together with ADNM, right?

Have a look in the

Program Files\Microsoft SQL Server\MSSQL$AVAST\Log folder.

Does it contain any files? If so, please post the contents...


Thanks
Vlk

Title: Re: Login and DB problem
Post by: Gia78 on June 30, 2006, 02:12:28 PM

a lot of files ! i can't attach the zip file, i can send you via mail if it is possible.
Please note, i have reinstalled the adnm few time trying to solve the problem.
thanks
Gianluca

Title: Re: Login and DB problem
Post by: Lisandro on June 30, 2006, 02:20:16 PM

Quote from: Gia78 on June 30, 2006, 02:12:28 PM

a lot of files !

You can use Alwil FTP server as a second way to transfer only big files. Upload them to ftp://ftp.avast.com/incoming (please, note that you won't have READ access to the ftp server, just write - so you won't even be able to see what you've just uploaded).

Hope this help  :)

Title: Re: Login and DB problem
Post by: Gia78 on June 30, 2006, 03:29:18 PM

i have upload log.zip.
Thanks for help

Title: Re: Login and DB problem
Post by: Vlk on June 30, 2006, 04:19:43 PM

Thanks for the logs.

Clearly, the SQL Server is having hard time working with the database file. I have to say I have never seen anything like this so far... :-\

But I have found a MS KB article that discusses a similar issue:
http://support.microsoft.com/?kbid=870913

Could you please try deleting the following files:

C:\Programmi\Microsoft SQL Server\MSSQL$AVAST\Data\avast*.mdf
C:\Programmi\Microsoft SQL Server\MSSQL$AVAST\Data\avast*.ldf

and retry the "Create DB" function in the AMS Maintenance Tool?


Thanks
Vlk

Title: Re: Login and DB problem
Post by: Gia78 on June 30, 2006, 05:00:41 PM

Thanks a lot ! Now is perfect!   ;D

Title: Re: Login and DB problem
Post by: Vlk on June 30, 2006, 05:15:55 PM

Glad to hear that...

But I'm still wondering how did the problem occur. Was there a previous install of ADNM on this machine? I.e. did you install it more than once?


It seems that there must've been some remaints from some previous (maybe failed?) ADNM install...


Thanks :)
Vlk

Title: Re: Login and DB problem
Post by: Gia78 on June 30, 2006, 06:54:42 PM

I have installed ADNM one time 2 days ago, test with one client , all ok.
After i have change the administrator password and close the program... and ... (very very strange)... when i doubleclick on program icon to re-open the application nothing appear, double click again, nothing, neither an error message... i try also in program directory directly on .exe file... nothing !!! 
I decide to reboot the system to retry ... same problem nothing appear .. the application don't start.
So .... i decide to repair (with uninstaller) the application.. nothing.. same problem ... 
So ... uninstall and reinstall .... but at the question "you want to keep database" i choose OK.
The application now starting but i can't log in. I try the standard pwd (admin) and also my changed password... nothing...
I decide to ask in the forum and u know the end  ;D
Thanks a lot

Title: Re: Login and DB problem
Post by: Szabi on February 19, 2007, 09:35:38 AM

Hi!

Please help me!
I don't know wether I ask my question in the right forum here or not
My problem: after system booting the mssql server starts, and then after avast starts the sql server shots down and I can't start it.

Title: Re: Login and DB problem
Post by: Vlk on February 20, 2007, 12:13:02 AM

Gia, can you please check if the "avast! Management Server" service is running? (Control Panel -> Administrative Tools -> Services). If not, can you start it?

Szabi, what version of avast are you using? If it's avast Home or Profesional, you should start a new topic in the avast Home/Pro section of the forum.


Thanks
Vlk