SOLVED

SMS_WSUS_CONFIGURATION_MANAGER - Errors

Brass Contributor


The WCM.log shows many errors like:
----
[ODBC Driver 18 for SQL Server][SQL Server]The EXECUTE permission was denied on the object 'fnIsSnapshotInitializing', database 'name', schema 'dbo'.
-----
Does anyone have a tip?
The KB25858444 is installed.

2 Replies
best response confirmed by K_E (Brass Contributor)
Solution

The account that is trying to execute the function (I think), doesn't have execute rights to run it. Running one of commands in SSMS may work:

GRANT EXECUTE ON SCHEMA::[dbo] TO [accountname]

OR

GRANT EXECUTE TO [accountname]

The first one will give it execution right to just the dbo schema which is what the error message is complaining about. The second command will give the account access to all the schema. The question is........why did all of a sudden did that account lose it's execution rights or maybe it didn't have the right to begin with.

Thank you. That works.

But now the WCM.log shows Message:
Please republish client as new package id (someID) is available. Current published package id = otherID and version = 5.00.8355.1000
1 best response

Accepted Solutions
best response confirmed by K_E (Brass Contributor)
Solution

The account that is trying to execute the function (I think), doesn't have execute rights to run it. Running one of commands in SSMS may work:

GRANT EXECUTE ON SCHEMA::[dbo] TO [accountname]

OR

GRANT EXECUTE TO [accountname]

The first one will give it execution right to just the dbo schema which is what the error message is complaining about. The second command will give the account access to all the schema. The question is........why did all of a sudden did that account lose it's execution rights or maybe it didn't have the right to begin with.

View solution in original post