Sharepoint credentials – HP Storage Mirroring V5 Software User Manual
Page 117
HP StorageWorks Storage Mirroring Application Manager user’s guide 107
For SQL, you should first configure all permissions as described in ”
Storage Mirroring Application Manager
” on page 101. In addition, the user must have SQL Server System Administrator permission.
In order to operate the Application Manager for setup and to manage failover and failback for SQL, the
following permissions are required:
•
The user must be assigned the “System Administrator” role on the SQL server in order to query and
Administer SQL.
•
If the SQL Server service is
not
using the same domain user account on the source and target servers, the
SQL Service Principal Names (SPNs) of the source and target servers must be modified.
NOTE:
The Application Manager will fix this during validation granting permission to the local system
account on the target. For more information, see ”
Manually set SPN update permissions
Assigning SQL Server System Administrators permission
The user must be assigned the “System Administrator” role on the SQL server.
1.
Start SQL Server Enterprise Manager (SQL Server 2000) or SQL Server Management Studio (SQL 2005).
2.
Expand the
Security
folder under the server.
3.
Select
Logins
.
4.
Create a login for the user, if one does not already exist.
5.
Select
Server Roles
.
6.
Double-click the
System Administrators
(SQL Server 2000) or
sysadmin
(SQL Server 2005) role.
7.
Click
Add
, select the user, and click
OK
.
8.
Click
OK
on the Server Role Properties dialog box to save the change.
SharePoint Credentials
Proper rights must be assigned to the account that is entered when the Application Manager prompts for
credentials. If these credentials are not properly assigned, you will be prompted to enter alternate credentials
before protection can be enabled
For SharePoint, you should first configure all permissions as described in ”
” on page 101. In addition, the user must have the same permissions as are required for
SQL. For more information, see ”
The source SharePoint configuration (for either standalone or farm) has an administrator account that must be
specified when you are installing and configuring SharePoint. You will need to use that farm administrator
account when logging into the Application Manager (
domain\username
).
Additionally, the account you use must have local administrator (or equivalent) rights on the following servers:
•
Source front-end web server
•
Source back-end SQL server
•
Target front-end web server
•
Target back-end SQL server
In order to extend the target web server, you will also need to add the Sharepoint administrator account to the
local Domain Admin group on the target server before you extend the target web front-end server into the
farm.