Hi Everyone, I am having problems with Development box â€œMyDatabaseServerâ€ in setting up as Distributor. exec sp_adddistributor @distributor =@@ServerName GO exec sp_adddistributiondb @database = 'distribution' GO exec sp_adddistpublisher @publisher = @@ServerName, @distribution_db = 'distribution' GO When I am configuring as Distributor that is giving me an error that Msg 14099, Level 16, State 1, Procedure sp_adddistributor, Line 109 The server 'ServerName' is already defined as a Distributor. Configuration option 'allow updates' changed from 0 to 1. Run the RECONFIGURE statement to install. Msg 5845, Level 16, State 1, Line 1 Address Windowing Extensions (AWE) requires the 'lock pages in memory' privilege which is not currently present in the access token of the process. Msg 14117, Level 16, State 1, Procedure sp_MSrepl_adddistpublisher, Line 379 'distribution' is not configured as a distribution database.