Log in to legacy SQL Server agent

Logging in to SQL Server is accomplished by clicking Login To SQL Server on the View/Assign Database Backup Profiles screen.

Full functionality of the SQL Server agent requires authentication to a SQL Server instance. The SQL Server agent connects to a Microsoft SQL Server instance. This connection must be established before the SQL Server agent can obtain information regarding your existing SQL Server database or before a backup or restore can be performed.

There are two possible authentication methods available. One is to log in to the SQL Server instance using Standard authentication, for which a valid SQL Server login and password need to be supplied. Alternatively, log in to the SQL Server instance using Windows authentication, whereby a connection is made to the SQL Server instance using the Windows login information.

To enable Windows authentication, select the Use Windows Authentication checkbox on the SQL Server log in screen.

The SQL Server log in interface displays a list of operating SQL Server instances on the system. Named SQL Server instances are displayed using the format: \\ComputerName\InstanceName.