question

raadee avatar image
raadee asked

SQL rights vs Project Server 2010

I got a Sharepoint 2010 with Project server 2010 integrated farm. According to the project server 2010 deployment: http://technet.microsoft.com/en-us/library/ee662108.aspx I need set the following rights for the Farm Admin Account: "dbcreator, securityadmin **and** sysadmin" So first off I do not need other server roles checked when I check sysadmin. But the big question is, why do I need to use sysadmin for the FARM account? Anybody been here?
sql-server-2008-r2sharepoint-2010
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
ThomasRushton avatar image
ThomasRushton answered
This sounds like one of those cases where you give a system its own dedicated server. I've seen other systems demand sysadmin rights, and that was the only "safe" way of doing so - give them a dedicated SQL Server with a dedicated sysadmin account.
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Yes, thinking of creating a new instance for Project Server 2010. But it looks very strange and I think that it is a typo, especially when the article states that you need to check dbcreator/securityadmin along with sysadmin. It doesn't make sense.
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.