---
title: "New-VBRMSSQLCredentialsOptions"
description: "Creates Microsoft SQL Server credentials configuration that defines the connection between Veeam Backup & Replication and a discovered Microsoft SQL Server instance for Veeam Plug-In for Microsoft SQL Server backup operations."
canonical: "https://helpcenter.veeam.com/docs/vbr/powershell/new-vbrmssqlcredentialsoptions.html"
breadcrumb: "Veeam PowerShell Reference > Veeam PowerShell Reference > Veeam Plug-Ins for Enterprise Applications, MongoDB Backup and Epic EHR System Protection > Working with Managed Veeam Plug-Ins, MongoDB Backup and Epic EHR System Protection > Application Backup Policy Settings for Veeam Plug-In for Microsoft SQL Server > New-VBRMSSQLCredentialsOptions"
dateModified: "2026-08-19"
---

# New-VBRMSSQLCredentialsOptions

## Short Description
Creates Microsoft SQL Server credentials configuration that defines the connection between Veeam Backup & Replication and a discovered Microsoft SQL Server instance for Veeam Plug-In for Microsoft SQL Server backup operations.

**Product Edition**: Standard, Enterprise, Enterprise Plus, Veeam Universal License

## Syntax
```
New-VBRMSSQLCredentialsOptions -Instance <VBRDiscoveredMSSQL> -Credentials <CCredentials> [-UseSAAccount] [<CommonParameters>]
```

## Detailed Description
This cmdlet applies to application backup policies for Veeam Plug-In for Microsoft SQL Server.

Use this cmdlet to set authentication credentials for the Microsoft SQL Server instance.

## Parameters

<table style="width:100%;" class="Blue_Table">
      <tr style="vertical-align:top">
        <th style="width:20%;">
          <p>Parameter</p>
        </th>
        <th style="width:20%;">
          <p>Description</p>
        </th>
        <th style="width:20%;">
          <p>Type</p>
        </th>
        <th style="width:10%;">
          <p>Required</p>
        </th>
        <th style="width:10%;">
          <p>Position</p>
        </th>
        <th style="width:10%;">
          <p>Accept Pipeline Input</p>
        </th>
      </tr>
      <tr style="vertical-align:top">
        <td>
          <p class="Table_Text_Bold"><span class="Table_Text_Bold">Credentials</span></p>
        </td>
        <td>
          <p>Specifies the credentials used to connect to the Microsoft SQL Server instance.</p><p>Accepts the <code>CCredentials</code> object. To get this object, run the <a href="get-vbrcredentials.md"><code>Get-VBRCredentials</code></a> cmdlet.</p>
        </td>
        <td style="width:10%;">
          <p><code>CCredentials</code></p>
        </td>
        <td style="width:10%;">
          <p>True</p>
        </td>
        <td style="width:10%;">
          <p>Named</p>
        </td>
        <td style="width:10%;">
          <p>False</p>
        </td>
      </tr>
      <tr style="vertical-align:top">
        <td>
          <p class="Table_Text_Bold"><span class="Table_Text_Bold">Instance</span></p>
        </td>
        <td>
          <p>Defines the discovered Microsoft SQL Server instance.</p>
        </td>
        <td style="width:10%;">
          <p><code>VBRDiscoveredMSSQL</code></p>
        </td>
        <td style="width:10%;">
          <p>True</p>
        </td>
        <td style="width:10%;">
          <p>Named</p>
        </td>
        <td style="width:10%;">
          <p>False</p>
        </td>
      </tr>
      <tr style="vertical-align:top">
        <td>
          <p class="Table_Text_Bold"><span class="Table_Text_Bold">UseSAAccount</span></p>
        </td>
        <td>
          <p>Applies use of Microsoft SQL Server authentication account for authentication instead of the supplied Windows OS credentials.</p>
        </td>
        <td style="width:10%;">
          <p><code>SwitchParameter</code></p>
        </td>
        <td style="width:10%;">
          <p>False</p>
        </td>
        <td style="width:10%;">
          <p>Named</p>
        </td>
        <td style="width:10%;">
          <p>False</p>
        </td>
      </tr>
    </table>

`<CommonParameters>`

This cmdlet supports Microsoft PowerShell common parameters. For more information on common parameters, see [ Microsoft Docs](https://docs.microsoft.com/en-us/powershell/module/microsoft.powershell.core/about/about_commonparameters?view=powershell-7).

## Examples

::: example
### Associate Discovered Microsoft SQL Server Instance with Specific Credentials

This example shows how to apply stored service account credentials to the discovered Microsoft SQL Server instance.

```
$creds = Get-VBRCredentials -Name "SQL_Account"
$mssqlInstances = Get-VBRDiscoveredApplication -MSSQL -MSSQLEntityType -Instance
$mssqlInstance = $mssqlInstances[0]
$sqlcredentials = New-VBRMSSQLCredentialsOptions -Credentials $creds -Instance $mssqlInstance
```

Perform the following steps:

1. Run the [`Get-VBRCredentials`](get-vbrcredentials.md) cmdlet. Save the result to the `$creds` variable.
2. Run the [`Get-VBRDiscoveredApplication`](get-vbrdiscoveredapplication.md) cmdlet. Specify the `MSSQL`, `MSSQLEntityType` and `Instance` parameters. Save the result to the `$mssqlInstances` variable.
3. Run the `New-VBRMSSQLCredentialsOptions` cmdlet. Specify the `Credentials` parameter with the `$creds` variable. Specify the `Instance` parameter with the name of the Microsoft SQL Server instance. Save the result to the `$sqlcredentials` variable.

:::