amachanic/sp_whoisactive

SQL 2019 errors

Closed this issue · 1 comments

dca00 commented

sp_whoisactive used to run fine on previous versions but on SQL 2019 I get the following errors.
It was compiled by sa and runs also under sa account. I added with execute as owner as well.

Msg 15562, Level 16, State 2, Line 42
The module being executed is not trusted. Either the owner of the database of the module needs to be granted authenticate permission, or the module needs to be digitally signed.
Msg 15562, Level 16, State 2, Line 335
The module being executed is not trusted. Either the owner of the database of the module needs to be granted authenticate permission, or the module needs to be digitally signed.

What is required to run it without hiccups?

Sounds like the database you created the stored procedure in is not set to trustworthy.