SQL Server Settings

---

BackupAssist™ performs a SQL Server backup by logging into each selected database and performing a Backup Database operation.

To do this, it requires a valid login into the SQL Server. BackupAssist™ will use SQL authentication (username and password). Most database installations already have the sa user created, and we recommend using this account.

If you currently do not have the sa user, then we recommend creating one. You can do so by following these simple instructions.

Step 1: Launch the SQL Server Enterprise Manager as shown in the screenshot below.

Step 2: Check the Logins section for the sa user as shown in the screenshot below.

Step 3: If you need to create a new user then right click on Logins and select New Login...

Step 4: Setup the parameters as shown - use SQL Authentication, make sure that your login has the System Administrators role, and has access to each database you need to backup.

Note: BackupAssist™ accepts blank passwords

Now you can use the login in BackupAssist™.