cannot create database error

[hubercior]

HI!
After deinstallation and new installation of ADNM with MSDE database I have got error in C:\Program Files\Alwil Software\Management Tools\DATA\log :
 

Code: [Select]

2007-07-31 21:50:05 1185911405 SYSTEM 2780 Installer information: *: Going to check connection to MS SQL Server "SM19\avast", using user "sa"...   
2007-07-31 21:50:05 1185911405 SYSTEM 2780 Installer information: Going to create database of avast! on MS SQL server "SM19\avast", using user "sa"...   
2007-07-31 21:50:05 1185911405 SYSTEM 2780 Installer information: Cannot execute command for 0x00000065 resource, error 0x80040E14...   
2007-07-31 21:50:05 1185911405 SYSTEM 2780 Installer information: Cannot create database, error 0x0000A410...   
I cannot log to ADNM as admin and service avast management server is set to automatic but doesn't started even when i try to run it manually .
Please help me!

P.S
When I installed ADNM i was set password for database user SA

[hubercior]

So today I uninstall and install from scratch ADNM I use MSDE database with defaults settings .
And I still can't login to ADNM. Service Avast Management Server is not running and when I try to run it manually I get error 42000: 0xa410 !!!!

 ADNM LOGS shows:
error.log

Code: [Select]

2007-08-01 08:57:45 1185951465 SYSTEM 3120 Error 0000A410 has occured while loading the global data storage. 
2007-08-01 09:00:30 1185951630 SYSTEM 3716 Error 0000A410 has occured while loading the global data storage. 
info.log

Code: [Select]

2007-08-01 08:57:45 1185951465 SYSTEM 3120 Installer information: *: Going to check connection to MS SQL Server "SM19\avast", using user "sa"...   
2007-08-01 08:57:45 1185951465 SYSTEM 3120 Installer information: Going to create database of avast! on MS SQL server "SM19\avast", using user "sa"...   
2007-08-01 08:57:45 1185951465 SYSTEM 3120 Installer information: Cannot execute command for 0x00000065 resource, error 0x80040E14...   
2007-08-01 08:57:45 1185951465 SYSTEM 3120 Installer information: Cannot create database, error 0x0000A410...   
2007-08-01 09:00:30 1185951630 SYSTEM 3716 Installer information: *: Going to check connection to MS SQL Server "SM19\avast", using user "sa"...   
2007-08-01 09:00:30 1185951630 SYSTEM 3716 Installer information: Going to create database of avast! on MS SQL server "SM19\avast", using user "sa"...   
2007-08-01 09:00:30 1185951630 SYSTEM 3716 Installer information: Cannot execute command for 0x00000065 resource, error 0x80040E14...   
2007-08-01 09:00:30 1185951630 SYSTEM 3716 Installer information: Cannot create database, error 0x0000A410...   

PLEASE HELP ME!!!

[Vlk]

Hi,

please try using the AMS Maintenance Tool to check the DB connection.

Thanks
Vlk

[hubercior]

Hi,

please try using the AMS Maintenance Tool to check the DB connection.

AMS Maintenance Tool showed that connection is ok !

I solved the problem alone !!

I must delete 2 files
C:\Programmi\Microsoft SQL Server\MSSQL$AVAST\Data\avast*.mdf
C:\Programmi\Microsoft SQL Server\MSSQL$AVAST\Data\avast*.ldf

And everythink is ok !!!

[cairol220]

Whatever happens, when you delete these files, it really solves this issue ... thanks a lot!