Operational Defect Database
BugZero found this defect 280 days ago.
Data sources
All data on this page is proprietary to BugZero® or gathered from public sources
Microsoft SQL Server | 2506723
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/14/2023
Affected products:
SQL Server 2019 on Linux
SQL Server 2019 on Windows
Affected releases:
build lower than 15.0.4322.2
Fixed releases:
15.0.4322.2
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.
