SQL Server Performance Forum – Threads Archive
Replication – Adding a Distribution DB – SecurityIf I specify @Security_mode = 1 when running sp_adddistributiondb, does this mean the distribution database will run SQL scripts such as instdist.sql under the security context of the SQL Server service account? Dave
BOL refers : Is the security mode to use when creating the distribution database objects. security_mode is int, with a default of 0. 0 specifies SQL Server Authentication; 1 specifies Windows Authentication. Note that if the Distributor is running on MicrosoftÂ® Windows NTÂ® 4.0 or WindowsÂ® 2000, Windows Authentication is always used, regardless of the setting used for @security_mode. With [@createmode = 1] will – CREATE DATABASE or use existing database and then apply instdist.sql file to create replication objects in the distribution database. Satya SKJ
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.