SQL Server Performance

SQL Server 2005 Replication - Distributor

Discussion in 'SQL Server 2005 Replication' started by iambhushan, Jul 26, 2006.

  1. iambhushan New Member

    Hi Everyone,

    I am having problems with Development box “MyDatabaseServer” in setting up as Distributor. When I am configuring as Distributor that is giving me an error that



    Configuring...

    - Configuring the Distributor (Error)

    Messages

    * SQL Server could not configure 'MyDatabaseServer' as a Distributor. (Microsoft.SqlServer.ConnectionInfo)



    ------------------------------

    ADDITIONAL INFORMATION:



    An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)



    ------------------------------



    The server 'MyDatabaseServer' is already defined as a Distributor.

    Changed database context to 'master'. (Microsoft SQL Server, Error: 14099)



    For help, click:http://go.microsoft.com/fwlink?Prod...3&EvtSrc=MSSQLServer&EvtID=14099&LinkId=20476



    - Enabling Publisher 'MyDatabaseServer' (Stopped)







    So if it were already configured as distributor then I wanted to drop that distributor to make fresh distributor. I executed “Sp_dropdistributor” on Development box then I am getting different error message as given below. If you know any information, that would be really great.



    Msg 5845, Level 16, State 1, Procedure sp_procoption, Line 105

    Address Windowing Extensions (AWE) requires the 'lock pages in memory' privilege which is not currently present in the access token of the process.





    Thanks,

    Bhushan Kalla
  2. satya Moderator

    issue. Make sure the SQL Server service account has enough permission on the SQL Server data folder, you can check the permission of Data folder to see if you service account account is there (or add it to local administrators group to see if things improve).

    Satya SKJ
    Microsoft SQL Server MVP
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided �AS IS� with no rights for the sake of knowledge sharing.

Share This Page