avast ADNM on Windows Server 2008 x64 w/ SQL Server 2008 x64

Notes on installing Avast ADNM on Windows Server 2008 x64 with SQL Server 2008 x64

I found this article very helpful and I wanted to share this with the avast! community.

http://blogs.windwardreports.com/wunder_fodder/2010/03/notes-on-installing-avast-adnm-on-windows-server-2008-x64-with-sql-server-2008-x64.html

If I knew who wrote it, I would give them credit! I believe this pertains to all installations of SQL Server 2008 x64. We found that most ADNM installation issues are dealing with SQL and NOT with avast ADNM. You have to know the SQL instance name, and get that inserted correctly during the install. I haven’t had to support an installation yet with the new Administration Console (SBC) and 64 bit SQL Server 2008 yet. However, the SQL requirements haven’t changed. You have SQL free and SQL Pay 32 bit, and you have free SQL and Pay SQL 64 bit. This is the number 1 issue! J.R.

We have a lot of customers using MS SQL 2008 Express (64 bits) with ADNM and we never had to do things like these.

You have to install MS SQL 2008 Express using “MIXED MODE” authentication.

When you install ADNM, in the database you can to use: servername\SQLExpress

No more… :wink:

I don’t know why to delete de database files ???

This product was NOT SQL Express 2008, it was the pay version of SQL that was already loaded onto the server. J.R.

no offense meant but i have not ever read such a load of crap…

last december (2010) i installed ADNM on a Windows 2008 R2 server with a dedicated database server running Windows 2008 R2 and MS SQL 2008 R2.
I installed the database instance i wanted to use for Avast with mixed mode security since this is required for ADNM, ADNM doesnt handle SSPI (windows authentication).

I had not have to delete files
AMS tool runs perfectly the only thing is that even if you are logged in on the server using an account with administrative rights, you need to start AMS tool in elevated mode (runas administrator). This would have probably saved this guys time and effort…

and the guy explained btw that it was an installation of SQL so it was not loaded on the server yet :wink:
BUT if it had been already then you had to change things…

he makes the whole a confusing posting by talking about situations that are non-excistant and handled wrongly by him if they excisted.

+1 :wink: @wpn