Wednesday 17 December 2008

HMC4.5, Deployment Halted

I have started deploying HMC4.5 all over again for performance and scalability testing. I hit a new error message fairly early on in the deployment this time from the Provisioning Deployment Tool. The error appearer at the point I had completed all the settings for the Deploy Core MPS Components section and clicked Start Deployment. After a few seconds the following error message appeared -

Deployment Halted

Deployment interrupted for Mpf Audit And Recovery/MPS01 because SQL Server MPSSQL is either offline or non-existent

I attempted all the normal troubleshooting of ensuring IP connectivity, browsing, DNS records were all okay. Rebooted both servers, checked Event Logs and searched for *.log files, all to not result. After changing the following, it seemed to resolve the situation. I do not know enough about SQL to know if this is the fix, or if it was just some sort of coincidental timing...
On the SQL Database server, open the SQL Server Configuration Manager. Expand SQL Server 2005 Network Configuration > Protocols for MSSQLSERVER. Right click TCP\IP and select Enable. Restart the relevant SQL services. After completing this the Deployment finally continued without the above error.

(NB. I have changed the server names in the errors and post above)

No comments: