When I do a search on the SharePoint Web application I get the following message: Your search cannot be completed because of a service rror." And, the corresponding error in the Application event log is: "Query machine ‘SERVER1’ has been taken out of rotation due to this error: Access is denied. 0x80070005."
The application pool that the SharePoint Web application uses is configured to run as the Network Service identity (the least priviledge recommendation). It seems that the Network Service account is not granted a priviledge or access right while it tries to access the WSS Search Service running on the same machine.
If I change the identity of the application pool to the Administrator account, everything works great, the search runs correctly. However I don’t think this is the best solution for the issue, as from a security point of view, running a Web application with an administrative account is simply not a choice.
Note also that if I reinstall WSS using a stand-alone installation (with SQL 2005 Embedded Edition), search seems to work correctly. But I need to install it as a farm installation (with an existing SQL Server 2005 on the same server machine).
Any help in resolving this issue is much appreciated. Thank you in advance!