Re: Too many connections

Tech-Archive recommends: Speed Up your PC by fixing your registry



It's most likely Enterprise Manager. EM uses DMO and it is likely it calls
this sp when building the tree or if someone clicks on the replication node.
Even if you don't have any publishers or subscribers.

--
Andrew J. Kelly SQL MVP


"willyE" <willyE@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:E4FB5761-5D19-4A37-9DD7-E42CD4D49EEF@xxxxxxxxxxxxxxxx
> We have many SQL 2000 server, that is not setup as a distributor or a
> publisher. It is not involved in replication. we we have been
> seeing a bunch of connections on the server from user
> NT AUTHORITY/SYSTEM application SQLDMO executing exec
> sp_helpdistpublisher @check_user = 1 a number of times. Why would it
> be doing that, when the server is not setup for replication.
> One more thing.. We have MOM2005 would this be related.. ??
>
> Appreciate your help.
>
>


.



Relevant Pages

  • Re: SBS 2003 and Replication Errors with Remote DC
    ... I just promoted the remote DC last week, so I still have time to solve the replication issues. ... Domain Controller Diagnosis ... Connecting to directory service on server alpha. ... Performing upstream analysis. ...
    (microsoft.public.windows.server.sbs)
  • Re: SBS 2003 and Replication Errors with Remote DC
    ... alpha server as soon as you can to get things going. ... A simple DNS replication test is to create a host record in the SBS server ... Domain Controller Diagnosis ...
    (microsoft.public.windows.server.sbs)
  • Re: SBS 2003 and Replication Errors with Remote DC
    ... I did make the changes that you suggested on the DNS of my alpha server and rebooted. ... I did run the simple DNS test that you suggested by adding a host record to my SBS server. ... A simple DNS replication test is to create a host record in the SBS server and wait till it shows up in the remote server. ...
    (microsoft.public.windows.server.sbs)
  • Re: Unable to decommission a Windows 2008 DC via dcpromo
    ... Can you open and compare sysvol and netlogon share on both DCs? ... Verifying that the local machine server2, ... The File Replication Service Event log test ... Latency information for 8 entries in the vector were ...
    (microsoft.public.windows.server.active_directory)
  • Re: adding 64-bit R2 DC to existing domain
    ... Server 2003 standard edition 32-bit domain controllers. ... The schema master did not complete a replication cycle ..." ... server1 failed test KnowsOfRoleHolders ... ForestDnsZones failed test CrossRefValidation ...
    (microsoft.public.windows.server.setup)