SQL Server 2005 Replication – Distributor | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

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

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
This posting is provided �AS IS� with no rights for the sake of knowledge sharing.