Tip: Error Accessing OutSystems Applications after a SQL Server reboot

Tip: Error Accessing OutSystems Applications after a SQL Server reboot

  

Symptoms:

All applications throw the following exception:
System.Data.SqlClient.SqlException: SELECT permission
denied on object 'ASPStateTempApplications', database 'tempdb', owner 'dbo'.
SELECT permission denied on object 'ASPStateTempApplications', database
'tempdb', owner 'dbo'. INSERT permission denied on object
'ASPStateTempApplications', database 'tempdb', owner 'dbo'.


Cause:

- SQL Server was restarted and SQL Server Agent didn't or
- The server that hosts SQL Server rebooted and SQL Server Agent isn't set to "Auto-start when OS starts"

Resolution:

Start SQL Server Agent

-----------------------------------------------------
Best Regards

Paulo Silva