The EXECUTE permission was denied on the object proc_MSS_GetTopology’, database ‘Search_Service_Application_DB

Hello Folks,

when i got back to work in the morning i saw my search service was not working and throwing the error.

The EXECUTE permission was denied on the object ‘proc_MSS_GetTopology’, database Search_Service_Application_DB  {GUID} ”  this was caused due to the fact my new farm account didn’t have the“SPSearchDBAdmin”  role assigned under the Security > Users  > “SP farm Account”  on Search_Service_Application_DB  database (SQL Server Management Studio) other databases related to SharePoint Search service.  Once this was resolved my “Search Service Application: Search Administration” page displayed and I could create crawls.  you can follow below image for assigning the role of SPSearchDBAdmin.

423350

 

Thanks

Hope this Help.

Happy SharePointing 🙂

 

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s