Avast community forum
Home
Help
Search
Login
Register
Avast WEBforum
»
Business Products
»
Avast Business
»
Archive (Legacy)
»
Avast Distributed Network Manager
(Moderators:
ClayL
,
Matt_T
,
GeorgeP
,
Milla2
,
James827
,
P794851
) »
Login and DB problem
« previous
next »
Print
Pages: [
1
]
2
Go Down
Author
Topic: Login and DB problem (Read 17175 times)
0 Members and 1 Guest are viewing this topic.
Gia78
Guest
Login and DB problem
«
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
Logged
Vlk
Avast CEO
Serious Graphoman
Posts: 11658
Please don't send me IM's. Email only. Thx.
Re: Login and DB problem
«
Reply #1 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.
Logged
If at first you don't succeed, then skydiving's not for you.
Gia78
Guest
Re: Login and DB problem
«
Reply #2 on:
June 30, 2006, 11:03:08 AM »
Error.log is attached, thanks
Logged
Vlk
Avast CEO
Serious Graphoman
Posts: 11658
Please don't send me IM's. Email only. Thx.
Re: Login and DB problem
«
Reply #3 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
Logged
If at first you don't succeed, then skydiving's not for you.
Gia78
Guest
Re: Login and DB problem
«
Reply #4 on:
June 30, 2006, 12:32:40 PM »
This is the error when i perform "Check DB".
Grazie mille.
Ciao
Logged
Vlk
Avast CEO
Serious Graphoman
Posts: 11658
Please don't send me IM's. Email only. Thx.
Re: Login and DB problem
«
Reply #5 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
Logged
If at first you don't succeed, then skydiving's not for you.
Gia78
Guest
Re: Login and DB problem
«
Reply #6 on:
June 30, 2006, 01:21:50 PM »
Is MSDE. The OS win 2003 SBS standard edition.
Ciao
Gianluca
Logged
Vlk
Avast CEO
Serious Graphoman
Posts: 11658
Please don't send me IM's. Email only. Thx.
Re: Login and DB problem
«
Reply #7 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
Logged
If at first you don't succeed, then skydiving's not for you.
Gia78
Guest
Re: Login and DB problem
«
Reply #8 on:
June 30, 2006, 01:32:46 PM »
Other errors...
Thanks
Gia
Logged
Vlk
Avast CEO
Serious Graphoman
Posts: 11658
Please don't send me IM's. Email only. Thx.
Re: Login and DB problem
«
Reply #9 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
Logged
If at first you don't succeed, then skydiving's not for you.
Gia78
Guest
Re: Login and DB problem
«
Reply #10 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
Logged
Lisandro
Avast team
Certainly Bot
Posts: 67194
Re: Login and DB problem
«
Reply #11 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
Logged
The best things in life are free.
Gia78
Guest
Re: Login and DB problem
«
Reply #12 on:
June 30, 2006, 03:29:18 PM »
i have upload log.zip.
Thanks for help
Logged
Vlk
Avast CEO
Serious Graphoman
Posts: 11658
Please don't send me IM's. Email only. Thx.
Re: Login and DB problem
«
Reply #13 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
Logged
If at first you don't succeed, then skydiving's not for you.
Gia78
Guest
Re: Login and DB problem
«
Reply #14 on:
June 30, 2006, 05:00:41 PM »
Thanks a lot ! Now is perfect!
Logged
Print
Pages: [
1
]
2
Go Up
« previous
next »
Avast WEBforum
»
Business Products
»
Avast Business
»
Archive (Legacy)
»
Avast Distributed Network Manager
(Moderators:
ClayL
,
Matt_T
,
GeorgeP
,
Milla2
,
James827
,
P794851
) »
Login and DB problem