Wise Intregrated Connector 6.1.126 (SP2) is not SQL 2005 compatible. Error message:
Error executing query: A constant expression was encountered in the ORDER BY list, position 3. Altiris.ProductDelivery.ConnectWise.AeXNSWiseConnectorApp.GetCurrentPackageInfo AltirisNativeHelper.dll AeXNSWiseConnector.exe (2476) 1736
Download and extract the hotfix.
Execute the hotfix on the Notification Server with Wise Intregrated Connector 6.1.126 installed.
This issue is fixed in Wise Intregrated Connector 6.1.138.