Install Altiris Deployment and Microsoft SQL Express 2005

Environemnt
  • Symantec Altiris Deployment 6.X
  • Microsoft SQL Express 2005
Introduction
Altiris Deployment needs SQL Database. Not to use MSDE 2000, but use SQL Express 2005, however, get a error - 10061 cannot connect to the database. Finding that is caused by the connection setting of SQL Express 2005


Solutions
Run "SQL Server Configuration Manager" -> Go to "SQL Server 2005 Network Configuration" -> "Protocols for SQLEXPRESS" -> Set the TCP/IP properties - IPALL TCP Port of SQL Express to be 1433

Moreover, not only SQL Database, but also be careful if these are installed / set before running installation
  • Internet Information Service
  • DHCP Server
  • SQL Database Service is started