SQL 2025 Database Mail Linked Server Replication

SQL 2025 Gotcha

Posted by John Liu on Monday, February 9, 2026

SQL 2025 is GA and SQL 2016 is on it’s end of life on Jul 14, 2026. Some changes in SQL 2025 might break things working before.

SQL 2025 uses MSOLEDBSQL 19, and its defaults are different from what we have been using, like with old SQL Native Client (SQLNCLI).

In SQL 2025, encrypt is on by default, trust server certification is off by default, and it enforces strick certificate chain validation. These change will cause issues with Linked SErvers, Replications and Full-text Search, naming a few. Read more from SQL Server 2016 Ends in July. Here's What Will Break..

There is alos a know database mail bug in sQL 2025 CU1 and SQL 2022 CU23 that completely breaks database mail. Read more from Database Mail Bug Forces Microsoft to Pull SQL Server 2025 CU1... and 2022 CU23.

FEATURED TAGS
ai api automation availability availability-sets availability-zones aws-vm azure azure-automation-runbook azure-blob azure-cosmos-db azure-data-lake azure-function-app azure-openai azure-sign-in azure-site-recovery azure-sql-database azure-sql-db azure-subscription azure-vm base64 certificate change-data-capture change-tracking chrome clr container cte data-api-builder data-conversion data-gateway database-mail database-role database-size date-table dax db-config derived-table diagram direct-query disk-management disk-space docker downtime dtc dynamic-m-parameter embedding encrypted-connection excel excel-online execution-plan extended-events external-data fabric fabric-capacity failover-cluster fk geometry hierarchy httpwebrequest hugo hyper-v incognito-mode index infrastructure inline-tvf json kql lakehouse linked-server live-query-statistics locking m machine-learning machine-learning-model machine-learning-services master-key mcp mdx memory memory-grant mermaid mirrored-sql-server network network-card network-category onedrive onnx-runtime openrowset p2v parquet performance polybase power-automate power-bi power-bi-report-tricks power-platform power-query powershell printer public-ip-address pyspark python qgis qt-designer query-performance query-plan query-troubleshooting r regex replication route s3 schema-design scripting self-signed-certificate server-role sharepoint snowflake software-development sofware-development spark sql sql-2025 sql-agent sql-availability-group sql-error sql-failover-cluster-instance sql-index sql-openjson sql-permission sql-recovery sql-script sql-security sql-server sql-server-admin sql-server-config sql-statistics ssis ssisdb ssl ssl/tls-error ssms table-expression tempdb tips troubleshooting unicode view visual-studio visual-studio-code vmware wait-statistics wi-fi-connection-issue windows-settings