RE: SPS 2003 and SQL 2000 configuration
From: Mueller (Mueller_at_discussions.microsoft.com)
Date: 11/30/04
- Next message: Mueller: "RE: Portal Stats question"
- Previous message: John: "Error: Cannot retrieve properties at this time??"
- In reply to: Edouard LECOQ: "SPS 2003 and SQL 2000 configuration"
- Next in thread: Edouard LECOQ: "RE: SPS 2003 and SQL 2000 configuration"
- Reply: Edouard LECOQ: "RE: SPS 2003 and SQL 2000 configuration"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 30 Nov 2004 12:11:05 -0800
It appears you would be referring to the Configuration Database
Administration Account to access SQL. See comments below and this
information was taken directly from the SharePoint Administrators Guide.
This account is requested during setup when you select the Install without
database engine option.
This account will be used by SharePoint Central Administration functions to
access and modify settings in the configuration database and in all databases
for the portal site (people profile, content, and component settings
databases).
The account must be a member of the Power Users group on the server on which
you installed SharePoint Portal Server. The account must have the Database
Creators and Security Administrators server roles on the SQL Server instance.
In addition, the account must be a domain account if you have more than one
server in your configuration.
Important The following user rights are granted automatically to this
account (the configuration database administration account) on the local
server: Replace a process level token, Adjust memory quotas for a process,
and Log on as a service. If you change this account by using the Configure
Server Farm Account Settings page, the rights are not revoked automatically
for the previous account. See step 5 (Revoke rights from the old
configuration database administration account) in the following procedure to
remove these rights.
Note Changing the configuration database administration account requires
you to reenter the password for the default content access account and for
all rules that include or exclude content. Failure to do so causes crawls to
fail.
Note If you change this account on a server farm that uses shared
services, you must grant the new account access to search and index resources
on the parent server farm. For information about how to do this, see
Providing Shared Services.
Note If the password for this account expires and must be changed, or is
reset, perform the procedure in the "CentralAdminAppPool Application Pool
Account" section later in this document on the CentralAdminAppPool
application pool before performing the following procedure.
"Edouard LECOQ" wrote:
> Whe have 2 domains (appoved 2 way) on the same forest,
> one domain (d1) hosting this SPS server, the second (d2)
> hosting SQL Server (multiple instances).
>
> The account running SPS and having access to the database
> is on the d1 domain.
>
> Can anyone tell me which are the minimum rights to grant
> to this account on the specific instance of the SQL
> server ?
>
- Next message: Mueller: "RE: Portal Stats question"
- Previous message: John: "Error: Cannot retrieve properties at this time??"
- In reply to: Edouard LECOQ: "SPS 2003 and SQL 2000 configuration"
- Next in thread: Edouard LECOQ: "RE: SPS 2003 and SQL 2000 configuration"
- Reply: Edouard LECOQ: "RE: SPS 2003 and SQL 2000 configuration"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
