From the new SQL installation, open the sql server configuration manager and select the Protocols for ( Instance name) --Check the protocols name ( name pipes, TCP/IP and shared memory) is enabled.
By default all are disabled with new installation.
>> Enable all the options and then Go to services and select SQL service and restart the service.
This helps to generate the dynamic port for TCP/IP protocol.... ( To confirm open the same path and double click on TCP/IP and click on IP Addresses == Scroll down and from the IP ALL tab: TCP Dynamic Ports ( XXXX) port number will be visible.
>> You have to update this port number from the core/config page.
Moreover, it is better to go for sql authentication and for creating new sql user Ex: eposa), please check the attached document...
Once you completed this task, then run the "upgrade compatibility tool " On old EPO server and make a note of ( 65000 files should be max in EPO folder).
>> If this fails, follow the KB71078 to move EPO from 32 to 64 bit os and then inplace upgrade from 4.5.7 to 5.0.1.
Note: Any upgrade or Migrate EPO, I suggest to follow the KB71825 EPOchecklist and backup epo folder and EPO DB as this is recommended.
I hope this helps, if you still find issues, reply to this post.
Message was edited by: rgc on 9/11/13 5:35:15 AM CDT
Raghavendra GC McAfee Technical Support – APAC Customer Success Group www.mcafee.com