I've just been testing this, but with Server 2003 32-bit, so I'm not sure how much of this is the same. Also, this isn't exactly step-by-step, just some of the important ones.
These things may already be on Server 2008, but I had to:
Make sure .NET 3.5 was installed
Install Windows Installer 4.5
Install Powershell 1.0
Run Windows Update several times to make sure everything was current
These may not be necessary, but I did them anyway:
Update Java runtime
Update Adobe Reader
For SQL 2008 Express, download it from the Download Center, not from microsoft.com/express. If you get it from microsoft.com/express, you won't be able to set the instance name, etc.
Database Engine: http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=01af61e6 -2f63-4291-bcad-fd500f6027ff
Management Studio: http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=08e52ac2 -1d62-45f6-9a4a-4b76a8564a2b
I hope I'm not doing anything illegal or in bad netiquette by posting those links. You might have to unwrap them.
Before installing SQL Server, I created a user on the server called ePOUser with an appropriate password. It is just a standard user, I didn't add it to any groups (other than "Users", which it is in by defualt).
When installing SQL Server, I used an instance name of ePOServer.
On the Service Accounts page of the SQL Server setup, I selected the ePOUser account I created above for the DB Engine.
I had to set the Browser service to Autostart (on the same Service Accounts page in the lower section), it was set to not start by default.
I used Windows Authentication mode.
Where you could add SQL administrators, I added the current user (the one I was logged in with to do the install, which was an Administrator account).
Then I ran Windows update several times to make sure everthing was up to date.
When installing ePO, I used the ePOUser account as the DB Server credentials.
Then, another round of Windows Updates.
Finally, I checked in the packages and extensions I wanted (Agent 4.5, VirusScan 8.7, and Engine 5400). Use Menu > Software > Master Repository and Menu > Software > Extensions.
Then, I started setting policies and testing deployments. I deployed to the server itself first.
See this thread for info on an Agent 4.5 with VirusScan 8.7 problem: http://forums.mcafeehelp.com/showthread.php?t=234263
Hope this helps.
It was a while since I did this so apologies for not having the step-by-step details available but it went something like this:
- Install SQL Express 2005 that came with ePO 4.5 manually
- Install SQL Server 2005 Backwards Compatibility x64 pack from microsoft.com
- Go into SQL configuration tool and enable TCP/IP communication if not already there, make a note of the SQL port number too
- Run the ePO 4.5 setup selecting <hostname>\SQLEXPRESS as the database and the port number from the step above
That was it I think.
Can the EPO 4.5 database be installed to a specific instance <SERVERNAME\INSTANCENAME> ?
If yes, what are step by step details required to accomplish this setup.
If my database server was named EPO1 and my instance was called EPO2 it would look like this when I browsed it - EPO1\EPO2
If this is not possible, can the database be relocated to an INSTANCE.
Forgive me if I screwup terms here since I am not a DBA, just the guy stuck doing all the work the DBA does not have precious time for...
Please, if you respond to this post provide a verbose response with step by step specifics.
Thanks in Advance!
Yes, it can be installed to an instance. One of the installation setup screens asks you which database to use. I think it even gives you a list of the ones that are available.
I know you asked for step by step details, sorry I can't help you there (no time). My earlier post on this thread is the closest I have to step by step.
FYI, I followed the instructions from jguenrdc and was able to succesfully installing ePO 4.5 w/SQL Express 2008 on a VM (Hyper-V) running Windows 2008 R2 64bit. The only thing I would add is that you are going to need to install the 2005 SQL Express backwards compatiblity pack.
Using jguenrdc I came up with following instructions to install ePO 4.5 w/SQL Express on Windows 2008 R2 64bit -
FIRST OFF, 2008 R2 64BT IS NOT SUPPORTED BY MCAFEE. THIS IS A HACK TO GET IT TO WORK, DO NOT DO THIS ON ANY PRODUCTION SERVER, UNLESS YOU'RE WILLING EXCEPT THE RISKS.
USE THIS AT YOUR OWN RISK!!
1) Create a local user account on the server title epouser in computer management mmc. Does *not* need to be a local admin account. Normal account works just fine.
2) Download and install SQL Express 2008 from here:
3) When prompted name the database EPOSERVER
4) Allow the local user epouser access to the database during the installation.
5) Once the install is finished download and install SQL 2005 Express Backwards compatiblity pack from here:
6) Open SQL Server Configuration Manager, expand SQL Server Network Configuration. On the right side you'll see "TCP/IP", right click and enable.
7) Open services in the Adminstration Tools and find "SQL Server Browser Properties", enable the service and set it startup type automatic.
8) Restart the server, or restart all SQL services now.
9) NOW, it's time to install EPO. In the installation directory create a file titled "SkipOS.ini". This will bypass the OS detection and allow the install.
10) Go the run and type REGEDIT and do the following:
Data Type: REG_DWORD
Range: 0 or 1
Set it to 0
11) Reboot the machine
12) Now run the setup.exe
13) When prompted for the database use the following format "<hostname>\EPOSERVER", use Windows Authentication and select the local computer from the drop down. User the local username create in step 1, epouser, and put in the password.
14) Change port settings as necassary, but it should finish installing in 10-15 minutes. ALL DONE!
I'm sure there are plenty of other ways to go about this, but I wanted to share what worked for me. Best of luck!
Message was edited by: ahall on 11/20/09 2:51 PM
Message was edited by: ahall on 11/20/09 2:56 PM
Message was edited by: ahall on 11/20/09 2:57 PM
Thanks for the info, but do you also happen to know of a way to install just the agent handler on 2008 R2 (and Vista SP2\XP SP3 potentially) as this particular trick doesn't seem to work except for the whole server installation.
You will have to wait on ePO 4.5 Patch 1 for the Agent Handlers. But it should ship with in the next few weeks.