I have SharePoint farm consisting of three front-end server (S1,S2,S3). Most of the web apps run on S2 server, but I had to spin up a new web app on S3 server and I'm running in to issue with SSP Search. When I try to search on S3 server I
get a message "The search request was unable to connect to the Search Service ". I have also checked ULS logs and I believe this might be related "SqlError: 'The EXECUTE permission was denied on the object 'proc_MIP_GetObjectVersion'...."
The search service is running on S2 server and it's working fine, so I'm not sure what the issue could be?