Skip to Content (Press Enter)
2020-08-05 11-44-39
Paulo Silva
Staff
4Views
0Comments
Tip: Error Accessing OutSystems Applications after a SQL Server reboot
Question

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

0
0
03 Jul 2006
Copy Link
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.