sp_whoisactive icon indicating copy to clipboard operation
sp_whoisactive copied to clipboard

SQL 2019 errors

Open dca00 opened this issue 1 year ago • 1 comments

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?

dca00 avatar Jan 18 '24 17:01 dca00

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

mfuller333 avatar Jan 30 '24 10:01 mfuller333