MOSS 2007 domain account install requirements
I would like someone to explain the initial domain accounts needed to setup MOSS2007 with out getting concurency errors, permission denied errors or, "Only the site admin is allowed to querry from the profiles db." This is my 9th MOSS installation in 3 days and there was no combination of domain accounts that have worked.
My first installation.
1. Installed Windows 2003 r2, SQL standard x86, .net 3.0 then installed Sharepoint 2007.
2. I used a domain acount FESGWIRE as the service account for all SQL services and all accounts in MOSS2007. The account was also a local administrator.
First the installation complains about some random web application at port 15097 and suggest that it must be registered as a Kerberos service provider when I selected NTML and port 40000 for the admin service. Not sure what that was. However when I created the SSP an error event is thrown : Office SharePoint Server EID: 7888 - The program attempted to update an object that was updated by another user. This causes the synchronization for the Shared Services Provider to fail. After that sql consumes 100 of the processor until I reimage.
The Second Installation
1. All the same as above however I used a different domain account FHOUPB for the Office Search and the WSS3 Search.
This time the installation went with out error however after creating the SSP it kept throwing errors claiming that the account FHOUPB was not granted a certain right denied the logon. (Microsoft's documentation states that MOSS will take care of all permissions granted after the installation - Well I guess they are wrong). After trying to import the user profiles from the domain and getting (Error: You can not update or run a querry from the profileDB unless you are a site admin) Sharepoint search decides to throw an error every minute that for some reason it cannot explain.
So I yearn to hear that some one has installed Sharepoint on the same server as SQL using the complete mode and actually getting it to work. Also please include the exact type of accounts used and their permissions on the server. Please help!!!!!!!!!!!!!!!!!!!!!11

