A couple of weeks ago we noticed that we were having a problem with our Deployment Server losing its connection to the SQL server every couple of hours. We were at a loss as to what was going on.
The only information we could see was in the event viewer on our Altiris server which showed us exactly what time we would lose the connection.
It turns out that about a week earlier we upgraded our main HP switch in the server and figured there must be some correlation between this and our Altiris/SQL communication problem.
It turns out that since we team the NICs on our SQL server the two network cables needed to be in the same switch. We put the network cables for the SQL server back on the same switch and all has been well since.
Just wanted to pass this along in case anyone else has had a similar problem. I know I racked my brain for a good week on this.