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.
2 problems one is the SQL Server service account has no privilege for lock pages in memory, see this http://sqlserver-qa.net/blogs/x64/archive/2008/05/21/4293.aspx blog post to correct it and http://www.informit.com/articles/article.aspx?p=599700 for setting up distributor.