Author Topic: ADNM installer cant find SQLEXPRESS  (Read 9632 times)

0 Members and 1 Guest are viewing this topic.

Offline wpn

  • Avast Evangelist
  • Super Poster
  • ***
  • Posts: 1450
  • If it ain't broke, fix it! ;)
    • Bevolkingsonderzoek Zuid-West
ADNM installer cant find SQLEXPRESS
« on: August 07, 2008, 02:41:31 PM »
Hi,

Im evaluating ADNM for migrating from mcafee (unmanaged) to avast managed.

I have installed a server with SQLEXPRESS with default instance
I have enabled tcp and named pipes services for remote connecting.

I have WSUS installed on the databaseserver without problems
I can make ODBC connection to the server from the server where i want to install ADNM on, with connection testing it works great
(User DSN as well as System DSN)

When i install ADNM however, i get the message as show in attachment ScreenHunter_03 Aug. 07 14.23.gif  and ScreenHunter_03 Aug. 07 14.24.gif

To verify that i can have connection and can create and drop databases on the server see attachment ScreenHunter_03 Aug. 07 14.30.gif  and  ScreenHunter_03 Aug. 07 14.32.gif


I tried installing ADNM on a seperate server and on the SQL server itself, both come up with above problem.

I refuse to install MSDE on any of the servers becuz this is what i have SQLEXPRESS for.

if this problem gets solved i can start pressing my boss for clearing money to buy about 9 server licenses (1 for exchange also) and for about 100 desktops (which will grow in the near future).


I have looked on the forum here and saw several people with about the same problem, but they had some AMS Maintenance tool
which i dont have (or at least dont know how to obtain)

any lightshedding on this subject is very appreciated

btw: maybe i may suggest in the next ADNM release to improve the SQLSERVER detection and configuration during installation and maybe more documentation about this part.?

« Last Edit: August 07, 2008, 03:33:23 PM by wpn »

Offline Forejt

  • Sr. Member
  • ****
  • Posts: 233
    • ALWIL Software
Re: ADNM installer cant find SQLEXPRESS
« Reply #1 on: August 07, 2008, 06:53:33 PM »
You should configure SQL Server to use mixed authentication (using login "sa"), ADNM doesn't support SQL Server with NTLM authentication only.
The correct server name on ADNM setup page is NEBULA, and user name should be "sa" with appropriate strong password.

Offline wpn

  • Avast Evangelist
  • Super Poster
  • ***
  • Posts: 1450
  • If it ain't broke, fix it! ;)
    • Bevolkingsonderzoek Zuid-West
Re: ADNM installer cant find SQLEXPRESS
« Reply #2 on: August 08, 2008, 09:39:25 AM »
i tried that also, but unfortuanately it doesnt work

still get the same error

i tried it on the database server itself and on the other server.
both give the same error as in my original posting


from the error log after cancelling the installation:

08.08.2008 09:37:26 system: *: Going to check connection to MS SQL Server "NEBULA", using user "sa"...
08.08.2008 09:37:27 system: Cannot initialize data source, error 0x80004005...



ps: thank you for the quick reply :)

Offline Andrius

  • Newbie
  • *
  • Posts: 18
Re: ADNM installer cant find SQLEXPRESS
« Reply #3 on: September 01, 2008, 10:56:34 AM »
Any news? I have the same error.

Offline Gisabun

  • Jr. Member
  • **
  • Posts: 50
Re: ADNM installer cant find SQLEXPRESS
« Reply #4 on: September 02, 2008, 08:48:34 PM »
Just wondering. what version 2005, 2005 SP1, 2008?

I had asked elsewhere about 2008 compatibilities and never got a response.

Offline Andrius

  • Newbie
  • *
  • Posts: 18
Re: ADNM installer cant find SQLEXPRESS
« Reply #5 on: September 03, 2008, 11:57:05 AM »
2005 SP2 server (not express)

Offline wpn

  • Avast Evangelist
  • Super Poster
  • ***
  • Posts: 1450
  • If it ain't broke, fix it! ;)
    • Bevolkingsonderzoek Zuid-West
Re: ADNM installer cant find SQLEXPRESS
« Reply #6 on: September 08, 2008, 03:45:53 PM »
ok im back from vacation

i try to install this on:

VMWARE machine
Windows Server 2003
SQL Express 2005 (latest download version)


im goin to give it another try now, so we will see what happens now

Offline wpn

  • Avast Evangelist
  • Super Poster
  • ***
  • Posts: 1450
  • If it ain't broke, fix it! ;)
    • Bevolkingsonderzoek Zuid-West
Re: ADNM installer cant find SQLEXPRESS
« Reply #7 on: September 10, 2008, 09:07:52 AM »
i used VMWARE for testing so i reset my image to a clean install of the OS

i installed SQLEXPRESS 2005 as a named instance (dbserver:  NEBULA\SQLEXPRESS) and made sure the SA account could login..

there is no problem with installing avast ADNM now

im planning to try to install sqlexpress as a default (instead of named instance) including the SA authentication to see what happens
but first im goin to write an evaluation report about the software for buying and installing it as replacement of our mcafee..


Offline Andrius

  • Newbie
  • *
  • Posts: 18
Re: ADNM installer cant find SQLEXPRESS
« Reply #8 on: September 10, 2008, 09:31:51 AM »
Did you installed ADNM on the same mashine as SQL ?

Offline wpn

  • Avast Evangelist
  • Super Poster
  • ***
  • Posts: 1450
  • If it ain't broke, fix it! ;)
    • Bevolkingsonderzoek Zuid-West
Re: ADNM installer cant find SQLEXPRESS
« Reply #9 on: September 10, 2008, 12:38:47 PM »
yeah i installed the ADNM on the same machine as the SQLEXPRESS

i found a FAQ on the ADNM pages now which also states that SQLEXPRESS has to be installed as a named instance and with the mixed authentication enabled.....

if u follow this guideline the ADNM will install good

Offline Andrius

  • Newbie
  • *
  • Posts: 18
Re: ADNM installer cant find SQLEXPRESS
« Reply #10 on: September 10, 2008, 12:53:36 PM »
there is no problem with SQL and ADNM on the same mashine. I have problems then SQL is on a separate server.

Offline wpn

  • Avast Evangelist
  • Super Poster
  • ***
  • Posts: 1450
  • If it ain't broke, fix it! ;)
    • Bevolkingsonderzoek Zuid-West
Re: ADNM installer cant find SQLEXPRESS
« Reply #11 on: September 10, 2008, 04:36:05 PM »
did u fill in like this:   SERVER\INSTANCE

the instances must be named i figured, if its not a named instance i guess the installer cant install.... but that also depends on the version of MSSQL u use from what i understood from the faq on the page of ADNM

Offline Andrius

  • Newbie
  • *
  • Posts: 18
Re: ADNM installer cant find SQLEXPRESS
« Reply #12 on: September 11, 2008, 01:14:41 PM »
"...It is recommended to install the SQL Server as a named instance..."
I use default instance on SQL 2005 SP2 and need to use windows authentication.

Anyone from avast team reading this forum ?