SQL Server Performance

SQL Server 2005 Replication - 64bit computer Distributor Error

Discussion in 'SQL Server 2005 Replication' started by richard_boy, May 20, 2008.

  1. richard_boy New Member

    Hi Everyone,

    I am having problems with Development box “MyDatabaseServer” in setting up as Distributor.
    exec sp_adddistributor @distributor =@@ServerName
    exec sp_adddistributiondb @database = 'distribution'
    exec sp_adddistpublisher @publisher = @@ServerName, @distribution_db = 'distribution'
    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. satya Moderator

Share This Page