Unable to regain connectivity to SQL Database following SQL Server restart / NSSetup wizard prompt.
NOTE: Inetpub folder contains the wwwroot folder.
To reproduce error:
The error also occurred when changing the NS to point to another Database Server when it was previously pointing to an on-box database, after SQL Server was removed from the NS server.
IIS, any version
SQL, any version
User moved the "Inetpub" folder from the default location. Problem manifested when Altiris services were restarted and then NS Console is accessed. Since DB was not ready, the NS Setup page started.
Resolved issue by stopping IIS (iisreset /stop) and Altiris Services. Moving the \Inetpub folder back to the default location (See IIS > Default Website properties > Home Directory tab > Local Path), restarting IIS and Altiris Services.
Console then loaded normally.