Author Topic: avast ADNM on Windows Server 2008 x64 w/ SQL Server 2008 x64  (Read 9719 times)

0 Members and 1 Guest are viewing this topic.

Offline avast@@dvantage77.com

  • J.R. Guthrie - avast! Sales and Support Specialist
  • Avast reseller
  • Advanced Poster
  • *
  • Posts: 738
  • the only avast! Distributor & Platinum Reseller
    • Advantage Micro Corporation
avast ADNM on Windows Server 2008 x64 w/ SQL Server 2008 x64
« on: August 05, 2011, 02:41:10 AM »
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.
« Last Edit: August 05, 2011, 02:45:28 AM by avast@advantage77.com »
Sincerely,
 
J.R. "AutoSandbox Guy" Guthrie

"At this point in time, the Internet should be regarded as an Enemy Weapons System!"

Offline Infratech Solutions

  • Avast reseller
  • Advanced Poster
  • *
  • Posts: 1051
  • www.infratech.es
    • La web de Avast para España
Re: avast ADNM on Windows Server 2008 x64 w/ SQL Server 2008 x64
« Reply #1 on: August 05, 2011, 12:52:50 PM »
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...  ;)

I don't know why to delete de database files  ???
La web de Avast antivirus para España: www.infratech.es/avast.

Offline avast@@dvantage77.com

  • J.R. Guthrie - avast! Sales and Support Specialist
  • Avast reseller
  • Advanced Poster
  • *
  • Posts: 738
  • the only avast! Distributor & Platinum Reseller
    • Advantage Micro Corporation
Re: avast ADNM on Windows Server 2008 x64 w/ SQL Server 2008 x64
« Reply #2 on: August 05, 2011, 06:33:54 PM »
This product was NOT SQL Express 2008, it was the pay version of SQL that was already loaded onto the server.  J.R.
Sincerely,
 
J.R. "AutoSandbox Guy" Guthrie

"At this point in time, the Internet should be regarded as an Enemy Weapons System!"

Offline wpn

  • Avast Evangelist
  • Super Poster
  • ***
  • Posts: 1449
  • If it ain't broke, fix it! ;)
    • Bevolkingsonderzoek Zuid-West
Re: avast ADNM on Windows Server 2008 x64 w/ SQL Server 2008 x64
« Reply #3 on: August 05, 2011, 07:24:14 PM »
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 ;)
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.

Offline Infratech Solutions

  • Avast reseller
  • Advanced Poster
  • *
  • Posts: 1051
  • www.infratech.es
    • La web de Avast para España
Re: avast ADNM on Windows Server 2008 x64 w/ SQL Server 2008 x64
« Reply #4 on: August 06, 2011, 12:26:45 PM »
+1  ;) @wpn
La web de Avast antivirus para España: www.infratech.es/avast.