Sounds like it is having problems connecting to the database.
Have you rebooted yet? If not, try that first.
Few things to check... make sure your altiris service, sql services, and IIS service are all starting successfully on the server. Try restarting them to make sure they are not hung or see if they fail to restart. See if the console will open. If not, open up the
http://localhost/Altiris/NS/Install/NSSetup.aspx on the server and see if reconfiguring the NS will get it running. You might want to check the NS documentation on the nssetup options. Check the log viewer to see what it says. Open up enterprise manager and drill down to the sql logs. Any errors?
