SQL Server Error Msg 20624 – The value specified for the @login parameter is not valid. User ‘%s’ is not a user in database ‘%s’. Add the user account to the database before attempting to execute the stored procedures sp_grant_publication_access or sp_revoke_publication_access.

In this blog post, let’s learn about the error message “20624 – The value specified for the @login parameter is not valid. User ‘%s’ is not a user in database ‘%s’. Add the user account to the database before attempting to execute the stored procedures sp_grant_publication_access or sp_revoke_publication_access.” in Microsoft SQL Server, the reason why it appears and the solution to fix it.

SQL Server Error Message

20624 – The value specified for the @login parameter is not valid. User ‘%s’ is not a user in database ‘%s’. Add the user account to the database before attempting to execute the stored procedures sp_grant_publication_access or sp_revoke_publication_access.

Reason for the Error

To be update soon…

Solution

To be update soon…