I have installed a new instance of Sharepoint 2007 and am in the process of configuring all the farm services. At the moment the farm consists of a sharepoint box and a separate sql server. Here is the catch. There are already some non-sharepoint
databases on the sharepoint server. The account under which Central Administration runs has dbcreator and securityadmin privileges in the database. The Sharepoint_Config and SharePoint_AdminContent databases were created without any issues.
When I try to start the Windows Services Search, I get an "Unknown Error." Looking in the event viewer gives the following error "The server principal "MyServerPrincipal" is not able to access the database "MyDatabase" under the current security context."
This is true, MyServerPrincipal does not have privileges to access MyDatabase, but why should it. MyDatabase has nothing to do with sharepoint.
In an attempt to get past this issue, I gave MyServerPrincipal public access to MyDatabase, but that resulted in an additional error saying that it lacked INSERT privileges. This is really worriesome. Does anyone know why Sharepoint Search configuration
would try to access the non-Sharepoint database?
Thanks a lot.
View Complete Post