Connection error

Enable Trust server certificate

Encryption was enabled on this connection, review your SSL and certificate configuration for the target SQL Server, or enable 'Trust server certificate' in the connection dialog. Note: A self-signed certificate offers only limited protection and is not a recommended practice for production environments. Do you want to enable 'Trust server certificate' on this connection and retry?

Azure Data Studio needs to contact Azure Key Vault to access a column master key for Always Encrypted, but no linked Azure account is available. Please add a linked Azure account and retry the query.

Azure Data Studio needs to contact Azure Key Vault to access a column master key for Always Encrypted, but no linked Azure account was selected. Please retry the query and select a linked Azure account when prompted.

Please select a linked Azure account:

The configured Azure account for {0} does not have sufficient permissions for Azure Key Vault to access a column master key for Always Encrypted.

Editor token refresh failed, autocompletion will be disabled until the editor is disconnected and reconnected

Failed to find azure account {0} when executing token refresh

Failed to find tenant '{0}' in account '{1}' when refreshing security token

No document found for URI {0}

No result returned from Notebook convert request

Unsupported platform {0}

{0} AAD token refresh failed, please reconnect to enable {0}

An error occurred converting the Notebook document to SQL. Error : {0}

An error occurred converting the SQL document to a Notebook. Error : {0}

Reload Azure Data Studio

Search Server Names

This setting requires Azure Data Studio to be reloaded to take into effect.

Add

Add Database file

Add Filegroup

Add Objects

Add database files

Add members

Add securables

Advanced

All Files

All objects belonging to a schema

All objects of certain types

Allow Triggers to Fire Others

An error occurred while dropping the {0}: {1}. {2} {0} object type, {1}: object name, {2}: error message.

An error occurred while opening the attach database dialog. {0} {0}: error message.

An error occurred while opening the detach database dialog. {0} {0}: error message.

An error occurred while opening the drop database dialog. {0} {0}: error message.

An error occurred while opening the new {0} dialog. {1} {0} object type, {1}: error message.

An error occurred while opening the properties dialog for {0}: {1}. {2} {0} object type, {1}: object name, {2}: error message.

An error occurred while refreshing the object explorer. {0} {0}: error message.

An error occurred while renaming {0} '{1}' to '{2}'. {3} {0} object type, {1}: original name, {2}: new name, {3}: error message.

Application Role

Apply

Are you sure you want to drop the {0}: {1}? {0} object type, {1}: object name.

Are you sure you want to purge the Query Store data from '{0}'?

Associated Database Files

Attach

Attach As

Attach Database (Preview)

Attach database

Authenticate with Microsoft Entra

Authenticate with password

Auto Create Incremental Statistics

Auto Create Statistics

Auto Shrink

Auto Update Statistics

Auto Update Statistics Asynchronously

Autogrow All Files

Autogrowth / Maxsize

Automatic

Automatically set I/O affinity mask for all processors

Automatically set processor affinity mask for all processors

Azure SQL Database pricing calculator

Back

Backup

Backup Storage Redundancy

Backup and Restore

Backup checksum

Blocked Process Threshold

Both failed and successful logins

Browse for an owner

Browse…

CPU {0}

Cannot create file '{0}' because it already exists.

Cannot use empty object names for filegroups.

Changes require server restart in order to be effective

Close existing connections

Collation

Compatibility Level

Compress Backup

Configure SLO

Confirm password

Containment Type

Cost Threshold Parallelism

Could not find a supported dialog for node type '{0}' and object type '{1}'.

Create

Create {0} {0} object type

Creating a login with a blank password is a security risk. Are you sure you want to continue?

Current Disk Usage

Current Service Level Objective

Cursor Threshold

Custom

DB Name

Data

Data Flush Interval (Minutes)

DataFile '{0}' could not be added to the collection, because it already exists.

Database

Database Data Files

Database Details

Database Files

Database Name

Database Read-Only

Database Role

Database Scoped Configuration

Database Scoped Options

Database Settings

Database State

Database default locations

Database files

Databases to Attach

Date Created

Default

Default Full-Text Language

Default Language

Default schema

Delete backup and restore history information for database

Deny

Detach

Detach Database - {0} (Preview)

Detach Database Options

Detach database '{0}' {0}: object name.

Drop

Drop Database - {0} (Preview)

Drop Database Options

Drop connnections

Drop {0} '{1}' {0} object type, {1}: object name.

Dropping server logins does not drop the database users associated with the logins. To complete the process, drop the users in each database. It may be necessary to first transfer the ownership of schemas to new users.

Edit

Edit Database file - {0}

Edition

Effective permissions for selected securable

Effective permissions for: {0}

Enable Autogrowth

Enabled

Encryption Enabled

Enter new name

Execution Count

Explicit permissions for selected securable

Explicit permissions for: {0}

FILESTREAM Data

Failed logins only

Failed to retrieve the connection information, please reconnect and try again.

File Group

File Growth

File Name

File Type

File group '{0}' could not be added to the collection, because it already exists.

FileStream

Filegroup

Filegroup Name

Filegroups

Filegrowth cannot be greater than the Maximum file size for a file

Files

Filestream Files

Filters

Find

Full-Text Upgrade Option

General

Grant

Grantor

Hardware Generation

How do you want to add objects?

I/O Affinity

In Megabytes

In Percent

Is Clustered

Is HADR Enabled

Is Ledger Database

Is PolyBase Installed

Is XTP Supported

LOG

Language

Last Database Backup

Last Database Log Backup

Ledger

Limited to (MB)

Limited to {0} MB

Loading objects completed, {0} objects found

Loading objects…

Locks

Log

Logical Name

MDF File Location

Mapped to a Windows user/group

Mapped to a server login

Max Degree Parallelism

Max Plans Per Query

Max Size

Max Size (MB)

Max Text Replication Size

Maximum File Size

Maximum Server Memory (MB)

Maximum file size cannot be less than size

Maximum server memory cannot be lower than minimum server memory

Members

Membership

Memory

Memory Allocated To Memory Optimized Objects

Memory Optimized Data

Memory Used By Memory Optimized Objects

Minimum Server Memory (MB)

Monitoring

N/A

Name

Name cannot be empty.

No Login Access

No database files were specified to attach to the server.

None

Numa Node {0}

Number of Users

Object Type

Object Types

Objects

Operating System

Operation Mode (Actual)

Operation Mode (Requested)

Optimize Ad Hoc Workloads

Owned Schemas

Owner

Page Verify

Password

Password cannot be empty.

Password doesn't meet the complexity requirement. For more information: https://docs.microsoft.com/sql/relational-databases/security/password-policy

Password must match the confirm password.

Path

Permission

Platform

Processor

Processor Affinity

Processor Affinity Table

Processors

Product

Properties

Purge Query Store Data

Query Store

Query Store Available

Query Store Capture Mode

Query Store Capture Policy

Query Store Retention

Query Store Used

Query Wait

ROWS Data

Read-Only

Recovery

Recovery Model

Remove

Remove database file

Remove selected member

Remove selected securable

Rename {0} '{1}' to '{2}' {0} object type, {1}: original name, {2}: new name

Reserved Storage Size (MB)

Restrict Access

Root Directory

Rows

SQL Server and Windows Authentication mode

Scan Startup Procs

Schema

Search Text

Securables

Security

Select

Select Database Role Members

Select Database Role Owner

Select Folder

Select Securables

Select Server Role Members

Select Server Role Owner

Server

Server Collation

Server Role

Server authentication

Service Tier

Set Secondary same as Primary

Size (MB)

Size Based Cleanup Mode

Space Available

Specific objects…

Stale Threshold

State

State Query Threshold (Days)

Statistics Collection Interval

Status

Storage Space Usage (MB)

Successful logins only

Target Recovery Time (Seconds)

The selected collation '{0}' is not valid. Please choose a different collation.

This command is not supported for object type '{0}'.

Total Compile CPU Time (ms)

Total Execution CPU Time (ms)

Two Digit Year Cutoff

Type

Unlimited

Update statistics

Update {0} '{1}' {0} object type, {1}: object name.

Use full-text indexing

User

Value for Primary

Value for Secondary

Value should be greater than {0}. Choose 0 for default settings.

Version

Wait Statistics Capture Mode

Windows Authentication mode

With Grant

Yes

application role

column

database

database role

server role

table

user

view

{0}

{0} - New (Preview) {0} object type.

{0} MB

{0} Properties (Preview) - {1} {0} object type, {1}: object name.

({0} KB)

Downloaded {0}

Downloading {0}

Extracted {0} ({1}/{2})

Failed to start {0}

Installed {0}

Installing {0}

Installing {0} to {1}

Starting {0}

{0} Started

Do you want to reduce the table designer load time by enabling the database model preloading? The database model will be preloaded when you expand the database node in object explorer.

Failed to get connection string for the table. Please reconnect to the server and try again.

New Table

Yes

View Known Issues

{0} component exited unexpectedly. Please restart Azure Data Studio.

Add…

An error occurred while generating the script. {0}

Edit

Generating script...

Help

Loading dialog completed

Remove

Script

Script generated

Script has been generated successfully. You can close the dialog to view it in the newly opened editor.

Select

There is no action to be scripted.

Yes

A URL to a schema or a relative path to a schema in the current directory

A file pattern that can contain '*' to match against when resolving JSON files to schemas.

Advanced

Always Encrypted

An array of file patterns to match against when resolving JSON files to schemas.

An execution time-out of 0 indicates an unlimited wait (no time-out)

Application intent

Application name

Associate schemas to JSON files in the current project

Attach (Preview)

Attach DB filename

Attestation URL

Attestation protocol

Authentication type

Azure Attestation

Change SQL Notebook Connection

Clear Pooled Connections

Command timeout

Compatibility Level

Computer Name

Connect retry count

Connect retry interval

Connect timeout

Connection Resiliency

Context

Context connection

Current language

Custom name of the connection

Database

Declares the application workload type when connecting to a server

Delay between attempts to restore connection

Design

Detach (Preview)

Disable Group By Schema

Disabled

Drop (Preview)

Edition

Enable Group By Schema

Enable Parameterization for Always Encrypted

Enable SET ANSI_DEFAULTS

Enable SET ANSI_NULLS

Enable SET ANSI_NULL_DFLT_ON

Enable SET ANSI_PADDING

Enable SET ANSI_WARNINGS

Enable SET ARITHABORT option

Enable SET CURSOR_CLOSE_ON_COMMIT

Enable SET DEADLOCK_PRIORITY option

Enable SET IMPLICIT_TRANSACTIONS

Enable SET LOCK TIMEOUT option (in milliseconds)

Enable SET NOCOUNT option

Enable SET NOEXEC option

Enable SET PARSEONLY option

Enable SET QUERY_GOVERNOR_COST_LIMIT

Enable SET QUOTED_IDENTIFIER

Enable SET STATISTICS IO option

Enable SET STATISTICS TIME option

Enable SET TRANSACTION ISOLATION LEVEL option

Enable SET XACT_ABORT ON option

Enable/disable default JSON formatter (requires restart)

Enabled

Enables connection pooling on MSSQL connections to improve overall performance of Azure Data Studio connectivity. This setting is enabled by default. Azure Data Studio is required to be relaunched when the value is changed. To clear pooled connections, run the command: 'MSSQL: Clear Pooled Connections'

Enables or disables Always Encrypted for the connection

Enables or disables Secure enclaves for the connection

Enables use of the Sql Authentication Provider for 'Active Directory Interactive' authentication mode when user selects 'AzureMFA' authentication. This enables Server-side resource endpoint integration when fetching access tokens. This option is only supported for 'MSAL' Azure Authentication Library. Azure Data Studio is required to be relaunched when the value is changed.

Encrypt

Expensive operation highlighting will be turned off for execution plans.

Export Notebook as SQL

Export SQL as Notebook

Failover partner

Highlights the execution plan operation that took the most time.

Highlights the execution plan operation that used the most CPU time.

Highlights the execution plan operation with the greatest actual number of rows for all executions.

Highlights the execution plan operation with the greatest number of rows read.

Highlights the execution plan operation with the highest cost.

Highlights the execution plan operation with the highest subtree cost.

Host Guardian Service

Host name in certificate

Indicates the host name specified in TLS certificate that will be used by SQL Server to validate server certificate. When not specified, the server name is used by default for certificate validation.

Indicates the password to be used when connecting to the data source

Indicates the user ID to be used when connecting to the data source

Indicates which server type system the provider will expose through the DataReader

Initialization

Last Database Backup

Last Log Backup

Last backup

Load balance timeout

MSSQL configuration

Mandatory (True)

Max pool size

Maximum number of characters to store for each value in XML columns after running a query. Default value: 2,097,152. Valid value range: 1 to 2,147,483,647.

Maximum number of characters/bytes to store for each value in character/binary columns after running a query. Default value: 65,535. Valid value range: 1 to 2,147,483,647.

Maximum number of old files to remove upon startup that have expired mssql.logRetentionMinutes. Files that do not get cleaned up due to this limitation get cleaned up next time Azure Data Studio starts up.

Maximum number of rows to return before the server stops processing your query.

Maximum size of text and ntext data returned from a SELECT statement

Microsoft Entra ID - Universal with MFA support

Microsoft SQL Server

Min pool size

Multi subnet failover

Multiple active result sets

Name

Name (optional)

Name of the SQL Server instance

New (Preview)

New Database (Preview)

New Table

None

Number of attempts to restore connection

Number of minutes to retain log files for backend services. Default is 1 week.

OS Version

Optional (False)

Owner

Packet size

Password

Persist security info

Pooling

Port

Pricing Tier

Properties (Preview)

Recovery Model

Rename (Preview)

Replication

SQL Login

SQL Server: Disable Group By Schema

SQL Server: Enable Group By Schema

Search: Clear Search Server Results

Search: Servers

Secure enclaves

Security

Server

Should BIT columns be displayed as numbers (1 or 0)? If false, BIT columns will be displayed as 'true' or 'false'

Should IntelliSense be enabled

Should IntelliSense error checking be enabled

Should IntelliSense quick info be enabled

Should IntelliSense suggestions be enabled

Should IntelliSense suggestions be lowercase

Should column definitions be aligned?

Should data types be formatted as UPPERCASE, lowercase, or none (not formatted)

Should keywords be formatted as UPPERCASE, lowercase, or none (not formatted)

Should references to objects in a select statements be split into separate lines? E.g. for 'SELECT C1, C2 FROM T1' both C1 and C2 will be on separate lines

Show Log File

Size (MB)

Size in bytes of the network packets used to communicate with an instance of SQL Server

Source

Specifies a protocol for attesting a server-side enclave used with Always Encrypted with Secure enclaves

Specifies an endpoint for attesting a server-side enclave used with Always Encrypted with Secure enclaves

Specifies the method of authenticating with SQL Server

Status

Strict

The SQL Server language record name

The default metric to use to highlight an expensive operation in query execution plans

The length of time (in seconds) to wait for a command to execute before terminating the attempt and generating an error

The length of time (in seconds) to wait for a connection to the server before terminating the attempt and generating an error

The maximum number of connections allowed in the pool

The minimum amount of time (in seconds) for this connection to live in the pool before being destroyed

The minimum number of connections allowed in the pool

The name of the application

The name of the initial catalog or database int the data source

The name of the primary file, including the full path name, of an attachable database

The name of the workstation connecting to SQL Server

The name or network address of the instance of SQL Server that acts as a failover partner

The schema definition for the given URL. The schema only needs to be provided to avoid accesses to the schema URL.

The timeout in seconds for expanding a node in Object Explorer. The default value is 45 seconds.

Traces the communication between Azure Data Studio and SQL Tools Service to the SQL Tools Service output channel. WARNING: This may include sensitive information when verbose logging is enabled.

Trust server certificate

Type

Type system version

Used by SQL Server in Replication

User name

Version

When 'Mandatory' or 'Strict', SQL Server uses SSL encryption for all data sent between the client and server if the server has a certificate installed. When set to 'Strict', SQL Server uses TDS 8.0 for all data transfer between the client and server. 'Strict' is supported on SQL Server 2022 onwards.

When enabled, the database objects in Object Explorer will be categorized by schema.

When false, security-sensitive information, such as the password, is not returned as part of the connection

When true (and encrypt=true), SQL Server uses SSL encryption for all data sent between the client and server without validating the server certificate. This property is not supported with Encrypt=Strict.

When true, indicates the connection should be from the SQL server context. Available only when running in the SQL Server process

When true, multiple result sets can be returned and read from one connection

When true, the connection object is drawn from the appropriate pool, or if necessary, is created and added to the appropriate pool

Whether to allow table designer to disable and re-enable DDL triggers during publish

Whether to preload the database model when the database node in the object explorer is expanded. When enabled, the loading time of table designer can be reduced. Note: You might see higher than normal memory usage if you need to expand a lot of database nodes.

Windows Authentication

Workstation Id

[Experimental] Whether the requests to the SQL Tools Service should be handled in parallel. This is introduced to discover the issues there might be when handling all requests in parallel. The default value is false. Azure Data Studio is required to be relaunched when the value is changed.

[Optional] Do not show unsupported platform warnings

[Optional] Log debug output to the console (View -> Output) and then select appropriate output channel from the dropdown

[Optional] Log level for backend services. Azure Data Studio generates a file name every time it starts and if the file already exists the logs entries are appended to that file. For cleanup of old log files see logRetentionMinutes and logFilesRemovalLimit settings. The default tracingLevel does not log much. Changing verbosity could lead to extensive logging and disk space requirements for the logs. Error includes Critical, Warning includes Error, Information includes Warning and Verbose includes Information

[Optional] Should Personally Identifiable Information (PII) be logged in the log file.

e.g. servername,port

should commas be placed at the beginning of each statement in a list e.g. ', mycolumn2' instead of at the end e.g. 'mycolumn1,'