Login and DB problem

[Gia78]

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

[Vlk]

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.

[Gia78]

Error.log is attached, thanks

[Vlk]

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

Grazie
Vlk

[Gia78]

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

[Vlk]

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

BTW is this a MSDE or full SQL server install?

Ciao
Vlk

[Gia78]

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

[Vlk]

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

[Gia78]

Other errors...
Thanks
Gia

[Vlk]

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

[Gia78]

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

[Lisandro]

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 

[Gia78]

i have upload log.zip.
Thanks for help

[Vlk]

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

[Gia78]

Thanks a lot ! Now is perfect!