SQL Server Connection String
builder for ADO .NET & JDBC.
.NET
JDBC
Driver Version
7.0
6.4
6.2
6.0
4.2
4.1
💡 No information entered leaves this browser.
Basic Settings
Data Source
Instance
Port
Database
Application Name
Connection Timeout
User ID
Password
Windows Authentication
SQL Server Authentication
Azure Active Directory - Password
Azure Active Directory - Integrated
Networking and Security
Network Library
TCP/IP
Named Pipes
Shared Memory
Multiprotocol, Windows RPC
AppleTalk
VIA
IPX/SPX
Banyan Vines
Packet Size
Encrypt with SSL
Trust Server Certificate
Connect Retry Count
Connect Retry Interval
Persist Security Info
Column Encryption Setting
Failover Partner
Connection Pooling
Pooling
Enlist
Minimum Pool Size
Maximum Pool Size
Connection Lifetime
Pool Blocking Period
Auto
AlwaysBlock
NeverBlock
Availability Groups
Multi-Subnet Failover
Application Intent
Read-only
Read/write
Even More Options!
Language
English
German
French
Japanese
Danish
Spanish
Italian
Dutch
Norwegian
Portuguese
Finnish
Swedish
Czech
Hungarian
Polish
Romanian
Croatian
Slovak
Slovene
Greek
Bulgarian
Russian
Turkish
British English
Estonian
Latvian
Lithuanian
Brazilian
Traditional Chinese
Korean
Simplified Chinese
Arabic
Thai
Type System Version
SQL Server 2022
SQL Server 2019
SQL Server 2017
SQL Server 2016
SQL Server 2014
SQL Server 2012
SQL Server 2008
SQL Server 2005
Workstation ID
Initial File Name
Transaction Binding
Implicit Unbind
Explicit Unbind
Multiple Active Result Sets (MARS)
Asynchronous Processing
Context Connection
Replication
Transparent Network IP Resolution
User Instance
Basic Settings
Server
Instance Name
Port
Database
Application Name
Login Timeout
User
Password
Server SPN
JASS Configuration Name
SQL Server Authentication
Windows Authentication
Kerberos Authentication
Networking
Encrypt
Trust Server Certificate
Host Name in Certificate
SSL Protocol
TLS
TLSv1
TLSv1.1
TLSv1.2
Query Timeout
Lock Timeout
Socket Timeout
Packet Size
Failover Partner
Server Name as ACE
Federal Information Processing Standard (FIPS)
Enable FIPS
Trust Store
Trust Store Password
Trust Store Type
Trust Manager Class
Trust Manager Constructor Arg
FIPS Provider
Connection Behaviour
Prepare on First Prepared Statement Call
Last Update Count
Send String Parameters as Unicode
Send Time as Datetime
Use Bulk Copy for Batch Insert
XOPEN State Codes
Prepared Statement Discard Threshold
Select Method
Direct
Cursor
Response Buffering
Adaptive
Full
Disable Statement Pooling
Statement Pooling Cache Size
Always Encrypted (AE)
Enable Column Encryption Setting
Use Java Key Store
Key Store Location
Key Store Secret
Availability Groups
Transparent Network IP Resolution
Multi-Subnet Failover
Application Intent
ReadOnly
ReadWrite
Even More Options!
Workstation ID
Access Token