search

amachanic / sp_whoisactive

sp_whoisactive
GNU General Public License v3.0
1.13k stars 281 forks source link

SQL 2019 errors #114

Closed dca00 closed 4 months ago

dca00 commented 7 months ago

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?

mfuller333 commented 7 months ago

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