July 13, 2011 at 11:16 am
Hi,
We are following the method "Deploy by using DBA-created databases (SharePoint Server 2010)" to create the Share Point 2010 databases in SQL Server 2008 R2. Following the guide lines from the link
http://technet.microsoft.com/en-us/library/cc262869.aspx
I know the dbcreator & securityadmin server roles are required when Share point set up creates the databases automatically (No involvement of SQL DBA). But here, the DBA is creating the databases ahead and granting share point set up account to db_owner.
Question:
1. Even after we create the database and assign the share point set up account to db_owner database role, Does the Share Point set up account still require dbcreator & securityadmin server roles?
Please advice
July 13, 2011 at 11:32 am
It's better if you just let SharePoint have it otherwise it will start b*tch*ng.
July 13, 2011 at 11:41 am
It's better if you just let SharePoint have it otherwise it will start b*tch*ng.
But, we do not have much control to separate data files log files while creating databases from Share point application and it's our company policy to create the databases by the DBA.
If any body followed the Databases created by DBA method, please advice.
Thanks
July 13, 2011 at 12:39 pm
Sure you do in /server properties/database settings.
July 19, 2011 at 7:52 am
We use only DBA-created databases in our environment and the only permission granted to the Sharepoint account is the db_owner role in each database. We do not grant securityadmin or dbcreator and have not experienced any issues. Hope that helps.
July 19, 2011 at 9:20 am
from memory, the farm account will require at least dbcreator and securityadmin when creating content and search databases
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply