Consider the following scenario:
- You have a computer that is running Microsoft SharePoint Server together with Microsoft SQL Server 2008 R2.
- You use a user account (User A) to install and configure a SharePoint Server farm.
- User A makes another user (User B) a member of the Farm Administrator group.
- User A makes User B a member of the sysadmin role of the SQL Server 2008 server that hosts the farm configuration database.
- User B runs the Farm Configuration Wizard on a different computer, and joins that computer to the farm.
In this scenario, User B can open the SharePoint Central Administration Web site after the configuration is completed. However, User B cannot see some configuration options. For example, the Manage Services on Server
option in the System Settings
section is missing. Or, the Farm Configuration Wizard
option in the Configuration Wizards
section is missing.
To work around this problem, User A should follow these steps to install and configure the farm:
- Install SQL Server 2008 R2.
- Install SharePoint Server.
- Configure SharePoint Server.
- Add User B to the Farm Administrator group.
- Add User B to the Site Collections Administrator group.
- Add User B as the database owner of the SharePoint configuration database.
- Add User B as the database owner of the SharePoint AdminContent database.
- Add User B as the computer administrator on every computer in the farm.
User B can now log on to the farm and configure it successfully.
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
Article ID: 981592 - Last Review: September 17, 2011 - Revision: 2.0
- Microsoft SQL Server 2008 R2 Datacenter
- Microsoft SQL Server 2008 R2 Developer
- Microsoft SQL Server 2008 R2 Enterprise
- Microsoft SQL Server 2008 R2 Standard
- Microsoft SQL Server 2008 R2 Standard Edition for Small Business
- Microsoft SQL Server 2008 R2 Workgroup
|kbexpertiseadvanced kbtshoot kbsurveynew kbprb KB981592|