> For the complete documentation index, see [llms.txt](https://system-development-services.gitbook.io/truesecure-guide/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://system-development-services.gitbook.io/truesecure-guide/restore-backup-data/ms-sql-server-database-restore/step-5.-select-a-sql-server-instance.md).

# Step 5. Select a SQL Server Instance

On this wizard page, you can select a SQL Server instance to which to restore the database(s).

![](https://1045802759-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FKVwxMpGGsUkYo2D86SKb%2Fuploads%2F1QxEt8gkP385fYSeIL7x%2Ft118.PNG?alt=media\&token=8cb05d89-50bd-47db-be63-a0a4e711606d)

You need to specify the following main settings on this wizard page:

* **SQL Server Instance** Specifies the SQL Server instance to which to restore your database(s).
* **Authentication** Specifies the authentication mode to use for connecting to SQL Server. The following modes are available:
  * **Windows Authentication**

    Uses Windows credentials of the current user to connect to SQL Server.
  * **SQL Server Authentication**\
    Connects to SQL Server using the specified credentials.\
    You can save this password in the TrueSecure Backup configuration file by enabling the corresponding option.

    > The selected authentication mode [should be enabled in SQL Server](https://docs.microsoft.com/en-us/sql/relational-databases/security/choose-an-authentication-mode).

In addition, you can enable the following options on this wizard page:

* **Check if the specified account has necessary permissions to perform the restore operation**\
  Enable this option to make the wizard automatically check whether the specified user account has all necessary permissions to restore the database.

  > The user must be assigned the [sysadmin](https://docs.microsoft.com/en-us/sql/reporting-services/security/role-definitions-create-delete-or-modify) role in SQL Server.
* **Use secure connection (SSL/TLS)**\
  Use this option to select whether you need to secure an encrypted SSL/TLS connection between the database server and TrueSecure Backup.

  > The SQL Server instance must have a corresponding certificate installed, which becomes automatically trusted by the TrueSecure client application.