EXECUTE permission was denied on the object 'proc_putObjectTVP'

While Configuring or creating the SharePoint 2013 Search Service Application using Central Administration - Start getting the error:-
Unable to retrieve topology component health states

Search Service application was not showing the topology. Then I start creating the Search Service Application using Power Shell Script, Error message start appearing :-

EXECUTE permission was denied on the object 'proc_putObjectTVP'


This error clearly state, Account you are using for configuring search service application does not have sufficient privileges on the above mention Stored Procedure.

Resolution:-


1. Expand Databases then expand the SharePoint_Config Database.
2. Expand Security -> Roles -> Database Roles
3. Find WSS_Content_Application_Pools role, right click it, and select Properties
4. Click on Securables and click Search
5. Next click Specific objects and click OK
6. Click Object Types and select Stored Procedures. Click OK
7. Add the Stored Procedure 'proc_putObjectTVP' and click OK (if it does not automatically grant it exec permission; you need to click the checkbox on "execute" and save it)

Again it was prompting for other stored procedure:- Again I followed the all above steps for theses two stored procedure:-
proc_putObject
proc_putDependency

Or Run the below commands:-
use [Sharepoint_Config]
GO
GRANT EXECUTE ON [dbo].[proc_putObjectTVP] TO [WSS_Content_Application_Pools]
GRANT EXECUTE ON [dbo].[proc_putObject] TO [WSS_Content_Application_Pools]
GRANT EXECUTE ON [dbo].[proc_putDependency] TO [WSS_Content_Application_Pools]

GO


Happy Coding..

No comments:

Post a Comment