SQL Server 2005 Replication - Distributor

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