Hello,
I am trying to install ePO 5 on a Windows Server 2012 box. Its a domain controller.
When I started the installation, I am greeted with the failure of the included SQL 2008 Express installation. So from using what I found on these forums, I installed SQL 2008 Express manually. Using all the defaults. (I used the SYSTEM account)
I restart the ePO 5 installation:
Setup Type
->Custom
Choose Database Option
->Microsoft SQL Server
Destination Folder
->Default
It then searches for Domain Controllers, then proceeds to search for SQL servers. It fails to find any.
"Setup was unable to get a list of SQL servers in your environment. Click Yes to search again, No to enter settings manually" (Paraphrasing)
I click "No", and the Database Information dialog box comes up.
Database Server:servername
Database Name:ePO_servername
Database Server Credentials
Windows Authentication (Selected)
Domain:domainname
Username:administrator
Password:adminpassword
SQL server TCP port:1434/1433
I get the following error:
"Setup was unable to to access the SQL UDP port 1434 on the specfied SQL server. Setup requires such access to retrieve the TCP port assignment information from the SQL server"
Help would be greatly appreciated.
Thanks,
Wes
Wes,
First McAfee does not recommend installing ePO server on DC.(But compatible)
Go to SQL Server configuration Manager and see the SQL UDP port there.
Restart the SQL Browser service
Make sure that TCP/IP Pro is enabled.
Remember:You will put in the same port which you will find in SQL Manager settings.
Post back if it deosnt hep.
Alexn
Alexn,
In the SQL Configuration Manager, under SQL Native Client 10.0 Configuration->Client Protocols->TCP/IP, the default port is 1433.
However, I did take notice that the SQL Browser Service is stopped. When I try to adjust settings it says "The service cannot be started, either becuase it is disabled or because it has no devices associated with it 0x80070422"
Any advice?
Thanks,
Wes
Alexn,
I was able to start SQL Browser Service, The Start Type was set to Disabled, I set it to Automatic. However, I still get the same error with ePO.
Wes
Wes,
Is it SQL server 2008 sp1 Express that comes with ePO 5.0?
if yes then to easy troubleshoot SQL connection prblem is to install SQL Management studio 2008 as well.It is small tool that will give you an easy way to loginto SQL server.
Also restart SQl Server service.
Alexn,
Yes it was the application bundled with ePO 5. I will install what you recommended and try it out. Would I have better luck with SQL 2012 Express?
Thanks,
Wes
Yes, it is tested with ePO 5.0 and provides more MDF space.(MDF is SQL Data files).After Installing SQL Managemt Studio log into SQL server.
If you have any Antivirus Disable it before installing ePO5.0.
Your windows firewall should allow ports 1433-34. Better is to turn off before running ePO setup.exe.
On DC I have experienced that these ports are usually taken by some other aopplications so you must confirm that after restarting SQL Browser service you are getting right POrt and during epo install same port should be pop up or manaually put in that port.
Although you can install ePO with Local admin rights but i have experienced that if your server (DC) is also part of your domain than it is far better to login as domain adin like domain\administrator and then install epo.
Check the following before running setup again
Alexn,
I tried disabling the firewall completely. I also chose 47800 as the port to try an use. Still gave me an error. I uninstalled SQL 2008 Express, which was no small feat. lol. I am going to try to install SQL 2012 Express next. Do you have any advice, so that I may get this right on the first try with 2012?
Thanks,
Wes
Sure, Please follow this link
http://www.jsinh.in/2012/09/install-sql-server-2012-express-step-by-step/
So after I install SQL 2012 Express using that guide will Mcafee just see it?
Wes
Corporate Headquarters
6220 America Center Drive
San Jose, CA 95002 USA