This section lists the JDBC connection properties supported by the SQL Server driver and describes each property. The properties have the form:

property=value

You can use these connection properties with either the JDBC Driver Manager or SQL Server driver data sources unless otherwise noted.

Note: All connection property names are case-insensitive. For example, Password is the same as password. Required properties are noted as such.
Note: The data type listed for each connection property is the Java data type used for the property value in a JDBC data source.

The following table provides a summary of the connection properties supported by the SQL Server driver and their default values.

Table 1. SQL Server Driver Properties
Property Default
AccountingInfo empty string
AlternateServers None
AlwaysReportTriggerResults false
ApplicationIntent ReadWrite
ApplicationName empty string
AuthenticationMethod auto
BulkLoadBatchSize 2048 (rows)
BulkLoadOptions None
CatalogOptions 0
ClientHostName empty string
ClientUser empty string
CodePageOverride None
ConnectionRetryCount 5
ConnectionRetryDelay 1 (second)
ConvertNull 1 (data type check is performed if column value is null)
CryptoProtocolVersion

No default value
Database None
DatabaseName None
DateTimeInputParameterType auto
DateTimeOutputParameterType auto
DescribeInputParameters noDescribe
DescribeOutputParameters noDescribe
Domain None
EnableBulkLoad false
EnableCancelTimeout false
EncryptionMethod noEncryption
FailoverGranularity nonAtomic
FailoverMode connect
FailoverPreconnect false
FetchTSWTZAsTimestamp false
FetchTWFSasTime false
HostNameInCertificate empty string
HostProcess empty string
ImportStatementPool empty string
InitializationString None
InsensitiveResultSetBufferSize 2048 (KB of memory)
JavaDoubleToString false
JDBCBehavior 1
LoadBalancing false
LoadLibraryPath None
LoginTimeout 0 (no timeout)
LongDataCacheSize 2048 (KB of memory)
MaxPooledStatements 0 (driver’s internal prepared statement pooling is not enabled)
MaxStatements 0 (driver’s internal prepared statement pooling is not enabled)
NetAddress 000000000000
PacketSize -1 (maximum packet size accepted by the database server)
Password None
PortNumber 1433
ProgramID empty string
ProgramName empty string
QueryTimeout 0 (query does not time out)
RegisterStatementPoolMonitorMBean false
ResultSetMetaDataOptions 0 (no additional processing to determine the correct table name for each column in the result set)
SelectMethod direct
ServerName None
SnapshotSerializable false
SpyAttributes None
StringInputParameterType nvarchar
StringOutputParameterType nvarchar
SuppressConnectionWarnings false
TransactionMode implicit
TruncateFractionalSeconds true
TrustStore None
TrustStorePassword None
User None
UseServerSideUpdatableCursors false
ValidateServerCertificate true
WSID empty string
XATransactionGroup None
XMLDescribeType None