Sorry, I posted in the wrong forum earlier... My bad.
Our shop is new to SharePoint, but we have experience with SQL Server. We plan to install SharePoint 2007 with SQL Server 2008 on Windows Server 2008.
What are the minimum SQL Server security requirements for installing and running SharePoint 2007? (Our SharePoint admin used his Administator account to install the software in a sandbox environment, and he used his Adminstrator account to run the SharePoint service account as well. I'm thinking something much privileged would be desired.)
Are the requirements the same for "running" and "installing" SharePoint?
I would like to provision the least amount of database privilege necessary in order to prevent unexpected, brand new databases being created without warning by our SharePoint admin. If at all possible, I would like confugure the database server in such a way to enforce the idea of consulting the Database team prior to any database changes taking place. Is that possible?