TdsServerOptions Class

When this is null, the requests that SqlBulkCopy sends to read the destination table go to the query handler, and its rows are rejected with the error 50001.

A TDS message is made of as many packets as the client decides to send, and the server has to buffer the whole message before it can be parsed. This limit bounds that buffer. It applies from the very first packet of a connection, so it also bounds what an unauthenticated client can make the server allocate. Raise it when clients legitimately send large parameters or SQL batches. Must be at least TdsServerOptions.MaximumPacketSize so that a single full packet always fits.

Must be between TdsServerOptions.MinimumPacketSize and TdsServerOptions.MaximumPacketSize. The TDS packet header stores the packet length in 16 bits, so a larger value cannot be represented on the wire.

When this is false and no TLS certificate is configured, the server answers PRELOGIN with NOT_SUPPORTED, and clients that allow it (for example Encrypt=Optional) log in over an unencrypted connection. The LOGIN7 password is then protected only by the TDS nibble-swap and XOR obfuscation, which is trivially reversible by anyone on the network path. Configure TdsServerOptions.TlsPfxPath or the PEM options for any deployment that is not loopback-only.

The responder answers the SQL Server Resolution Protocol on UDP, so clients can connect with an instance name (host\INSTANCE) instead of host,port. It advertises the port of the first TCP listener.

The server accepts transaction requests without a handler, so SqlConnection.BeginTransaction works even when nothing tracks transactions. Set it to observe the transactions, or to reject a request by returning an error. When a connection closes with an active transaction, the handler is called with a rollback request whose TdsTransactionContext.IsConnectionClosing is true.