I have a single-server installation of WSS3.0 using Windows Internal Database and also has a standalone install of Search Server Express 2008 on the same machine.
In the settings (Operations--Services on Server) for Windows SharePoint Services Search Service I changed the Content Access Account from Local Service to a local account I created called SPCrawler.
Now I get errors in the event log and the Admin Site does not show all the content (shows Render Error) for a little while, then works, then has the error again. Seems to be after a job runs and then it reverts back. I can't get to the Operations page again until it reverts back.
I tried to set the Content Access Account back to Local Service but it just takes me to the Unknown Error page with a link back to the site.
In the Event log I get:
Insufficient SQL database permissions for user '' in database SharePoint_AdminContent
(notice the empty quotes for user!)
SQL Database 'WSS_Content' on SQL Server instance 'np:\\.\pipe\MSSQL$Microsoft##SSEE\sql\query' not found. Additional error information from SQL Server is included below.
Cannot open database "WSS_Content" requested by the login. The login failed.
Login failed for user 'BC1CNQ\SPCrawler'.
A severe error occurred on the current command. The results, if any, should be discarded.
Can anyone help?