Add a SQL Server Instance

• You must create a Windows user who has Local Administrator rights to the computer and who is a member of the SQL sysadmin fixed server role for the instance. This account is used to perform jobs on the SQL Server instance, including backups, restores, accessing the Windows registry, and stopping SQL services during system database restores.

  The Local rights are needed for system database restore because the sqlserver is brought down in single user mode. They are also needed for VSS restores of the system database because the sqlserver will be stopped and then restarted after the restore. And they are needed to see if VSS services are enabled. SQL rights are needed to connect to a SQL instance.

• If the SQL server to which you are installing is also a Windows Domain Controller, you must use an account other than the domain administrator. Create a new user account which has both administrator and SQL 'sa' permissions and use that account.
• If the SQL Server service is running using any account other than the Local System account, you will need the user name and password of that account.
• For non-Microsoft cluster installations, the instance name must be manually entered in the New SQL Server dialog box.

Required Capability: See Capabilities and Required Actions

To add a SQL Server instance to the iDataAgent

1. From the CommCell Browser, open Client Computers, and then the client whose instances you need to add.
2. Right-click the SQL Server icon to open the shortcut menu; click All Tasks, and then click New SQL Server.
3. From the New SQL Server dialog box, click in the Server Name list any SQL instance that is not yet configured within the iDataAgent.
4. Within the Properties section, enter the required account and password.
5. Within the Storage Policies section, select the default storage policies to be used by the default subclient.
6. Click OK to complete the procedure.

This task is now complete.