Operational Defect Database
BugZero found this defect 284 days ago.
Data sources
All data on this page is proprietary to BugZero® or gathered from public sources
Microsoft SQL Server | 2506726
Improves sp_addpublication_snapshot by exposing additional parameters (@distributor_security_mode, @distributor_login, and @distributor_password). With these parameters, you can configure the Snapshot Agent to connect to the Distributor using SQL Server Authentication. Before this fix, the Snapshot Agent connects to the Distributor with Windows Authentication, and you can't configure it to connect to the Distributor using SQL Server Authentication.
Last update date:
8/10/2023
Affected products:
SQL Server 2022 on Linux
SQL Server 2022 on Windows
Affected releases:
build lower than 16.0.4065.3
Fixed releases:
16.0.4065.3
Description:
Improves sp_addpublication_snapshot by exposing additional parameters (@distributor_security_mode, @distributor_login, and @distributor_password). With these parameters, you can configure the Snapshot Agent to connect to the Distributor using SQL Server Authentication. Before this fix, the Snapshot Agent connects to the Distributor with Windows Authentication, and you can't configure it to connect to the Distributor using SQL Server Authentication.
