Followed this guide: http://support.microsoft.com/kb/832770
I have setup my account SPadmin to have access to my SQL DB
i went into IIS and attempted to change it there for my Default sharepoint site in the applications pool page > Properties>Identity
Nada, i changed it his apply reset IIS and back to my old account(very frustrating) so further reading showed attempting to change it via Central administration.
Went there and chose Operations>Service accounts chose my webservice,Application pool and configurable and setup my SPadmin, reset IIS and still no change.
Thoughts? i feel like there is some stupid step i'm missing because it will not change regardless.
Thanks Steve K
View Complete Post