---
isPrivate: true
title: Can I use a named instance in the SQL Server integration?
description: Datadog, the leading service for cloud-scale monitoring.
breadcrumbs: >-
  Docs > Integrations > FAQ Integrations > Can I use a named instance in the SQL
  Server integration?
---

# Can I use a named instance in the SQL Server integration?

{% callout %}
# Important note for users on the following Datadog sites: us2.ddog-gov.com

{% alert level="info" %}
To find out if this integration is available in your organization, see your [Datadog Integrations](https://app.datadoghq.com/integrations) page or ask your organization administrator.

To initiate an exception request to enable this integration for your organization, email [support@ddog-gov.com](mailto:support@ddog-gov.com).
{% /alert %}

{% /callout %}

When connecting to a default instance in SQL Server, users specify the host name with the port (1433 by default) as the host value in the sqlserver.yaml file. When [troubleshooting connection issues with SQL Server](https://docs.datadoghq.com/integrations/guide/connection-issues-with-the-sql-server-integration.md), determine whether you are connecting to a default instance or a named instance. Named instances can be connected using the $SERVER$INSTANCE_NAME syntax, but only if the SQL Server Browser service is enabled since this service provides the port the instance is on.

Here are the docs from Microsoft with more about the SQL Server Browser service:

```text
https://technet.microsoft.com/en-us/library/ms181087(v=sql.105).aspx#Anchor_2
```

The [SQL Server Browser service](https://technet.microsoft.com/en-us/library/ms165734%28v=sql.90.aspx) is required to use named instances and is disabled by default. Datadog recommends the approval of a system admin before enabling this service.

Once the SQL Server Browser service has been enabled, you can configure the [sqlserver.yaml](https://github.com/DataDog/integrations-core/blob/5.17.x/sqlserver/conf.yaml.example#L61) file to connect to a named instance by designating the named instance in the host value. For example:

```yaml
instances:
  - host: $SERVER\$INSTANCENAME
```