CreateCSSQLAccount

Scope

Intended Audience
All	X
CommVault Internal
CE/System Test
Development

Release

· 8.0.0

Description

The tool will create a Galaxy account for connection to the CommServe database.

Usage

1. Stop Galaxy services if they are running.

2. Copy CreateCSSQLAccount under the <GalaxyHome>\Base directory.

3. Following are the command line options for this utility:

-server <Instance Name> -salogin <sa login> -sapwd <sa password>
-cslogin <CS SQL login> -cspwd <CS SQL password>

[-CreateSQLLogin] [-SetRegistry [Focus]]
-CreateSQLLogin will create the <CS SQL Login> account in the SQL server.
-SetRegistry will create the registry entries for the login.
Focus should be in format of: Controlset (the machine name of the CommServe database).

Example scripts:
a) createCSSQLAccount –server griffen\commvaultqinetix –salogin sa –sapwd sa –cslogin cslogin123
–cspwd cspassword123 –SetRegistry controlset001(griffen)
This would create an account with username cslogin123 and password cspassword123 in the registry under ControlSet0001(griffen).

b) createCSSQLAccount –server griffen\commvaultqinetix –salogin sa –sapwd sa –cslogin cslogin123
–cspwd cspassword123 –CreateSQLLogin
This would create an account with username cslogin123 and password cspassword123 in the CommServe database with the Sys Admin role.

4. If your CommServe is a cluster machine, then you must run this utility on each physical node.
On all passive nodes, choose the option to only change the registry because the account on SQL would be created from the active node.

5. Start Galaxy services.

6. Expected Results:
In the case of creation of a SQL account, a new account is created.
The newly created SQL account has a System Administrator role on the CommServe database.
In the case of creation of a Galaxy account, only the registry information under HKEY_LOCAL_MACHINE\SOFTWARE\CommVault Systems\Galaxy\Platform Information\<machine name>\Database\pACCESS is updated.

NOTE

The Galaxy account will be created only for users who have a SQL server login account.

History

Revision	Date	Description
Revision 1	January 1, 2007	Initial revision

Disclaimer of Warranties

CommVault provides software tools and utilities on an "as is" basis, as a courtesy and convenience to its users, and they may be changed from time to time without notice. These tools and utilities are provided without express, implied, or statutory warranties of any kind. You assume full risk and responsibility for the selection, possession, performance and proper installation and use of the software tools and utilities, and for verifying the results obtained there from. Your use of CommVault software tools and utilities indicates your unconditional acceptance of the above disclaimer.