SQL Server Security

How you log in to the SQL Server depends on the authentication method being used by the Backup Agent for Microsoft SQL Server and by the SQL Server instance. If you are unsure of the authentication method you are using, consider that, in most cases, the SQL Server uses Windows-based authentication. However, certain situations (if you are running SQL Server 7.0 on a cluster, for example) require that you use native SQL security. For more information, including instructions on checking the authentication method in use by the SQL Server, see the Agent for Microsoft SQL Server Guide.

• Windows security--If the SQL Server is using Windows-based authentication to control access to the database, the user name and password in the security will be ignored.
• SQL security--If the SQL Server is using SQL-based authentication to control access to the database, you need to enter the user name and password of a user that has System Administrator privileges. The user name does not need to be domain-qualified.
• By default, SQL Server creates the "sa" user account, which has the required privileges. You can enter the information for this account, or for any other account that has the proper privileges on the target machine.

More information:

Full Node Backup Jobs