Re: Removing a DP

Tried all this didn't work. Still have all the DP stuff in IIS on the
server, as well as all the packages?
Terry

"Jack Wang [MSFT]" <jackwa@xxxxxxxxxxxxxxxxxxxx> wrote in message
news:cr%23OKeQ5FHA.2672@xxxxxxxxxxxxxxxxxxxxxxxx
> Hi Terry,
>
> Thank you for posting!
>
> From your message, I understand that you need to remove a DP.
>
> Based on my experience, you may refer to the following steps to remove it
> manually.
>
> 1 Open every package that used these Distribution Points, then delete
> these Distribution Points from the list. To do that,
>
> SMS Admin Console -> Packages -> Distribution Points -> highlight -> Right
> click -> Delete.
>
> 2. Delete these Distribution Points from SQL Database.
>
> Open SQL Enterprise Manager. -> Select SMS Server -> SMS Database ->
> Tables
> -> locate SysReslist -> right click -> Open Table -> Return all rows -> If
> you see these server names under ServerName column, it should be deleted.
>
> 3. To delete them, use SQL Query Analyzer. Consult with SQL expert to
> create a SQL query. Basically, you have to use "Delete" TSQL statement.
>
> 4. Stop and start SMS_Executive.
>
> Also, you may refer to the following steps.
>
> 1. Go into SQL Enterprise Manager and open the SMS Database
> 2. Go to Tables and select the Table "Summarizer_SiteSystem"
> 3. Right click and select Open Table-Return All Rows
> 4. Place a "-1" (without the quotes) in the Replicate Column for all
> instances of DP Servers that no longer exist.
> 5. Go to Tables and select the Table "sysreslist" delete all references to
> the component server that is no longer valid.
> 6. On the site server access and delete old Site Component Servers still
> found in the registry of the SMS site server under:
> HKLM/Software/Microsoft/SMS/Components/SMS_SITE_COMPONENT_MANAGER/Component
> Servers
>
> Delete those servers no longer defined as component servers (that is, not
> set in the MMC Site Settings/Site Systems as a DP).
>
> 7. Then open the SMS admin console and DELETE the entry under Site
> Settings/Site Systems.
>
> Hope this helps! If you have further concern, feel free to let me know.
> Have a great day!
>
> Sincerely,
> Jack Wang, MCSE 2000/2003, MCSA 2000/2003, MCDBA, MCSD
> Microsoft Online Partner Support
>
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
>
> =====================================================
> Business-Critical Phone Support (BCPS) provides you with technical phone
> support at no charge during critical LAN outages or "business down"
> situations. This benefit is available 24 hours a day, 7 days a week to all
> Microsoft technology partners in the United States and Canada.
>
> This and other support options are available here:
>
> BCPS:https://partner.microsoft.com/US/technicalsupport/supportoverview/40010
> 469
> Others:https://partner.microsoft.com/US/technicalsupport/supportoverview/
>
> If you are outside the United States, please visit our International
> Support page:
> http://support.microsoft.com/default.aspx?scid=%2finternational.aspx.
> ======================================================
>
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> --------------------
> | From: "Terry Matthews" <nospam@xxxxxxxxxxx>
> | Subject: Removing a DP
> | Date: Tue, 8 Nov 2005 17:43:39 -0700
> | Lines: 15
> | X-Priority: 3
> | X-MSMail-Priority: Normal
> | X-Newsreader: Microsoft Outlook Express 6.00.2900.2527
> | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2527
> | X-RFC2646: Format=Flowed; Original
> | Message-ID: <OsfKaaM5FHA.1140@xxxxxxxxxxxxxxxxxxxx>
> | Newsgroups: microsoft.public.sms.admin
> | NNTP-Posting-Host: 208.4.182.60
> | Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!tk2msftngp13.phx.gbl
> | Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sms.admin:68317
> | X-Tomcat-NG: microsoft.public.sms.admin
> |
> | So three hours ago I went to a site system and removed the checkbox to
> be
> a
> | distribution point.
> |
> | However nothing is happening??
> |
> | There is no throttling or sender restrictions... it is on a high speed
> | connection.
> |
> | Does anyone know how I can speed things up here? I have tried starting
> and
> | stopping services, but not sure what else?
> |
> | Thanks,
> | Terry
> |
> |
> |
>


.

Relevant Pages

  • RE: Random NT Authority/Anonymous Login Errors - REALLY NEED HELP.
    ... After disabling the TCP/IP network settings in SQL Server and using Named ... Microsoft MSDN Online Support Lead ...
    (microsoft.public.dotnet.framework.aspnet)
  • NFS locking
    ... We have a NFS server here with a fairly high load. ... lockd: server xxx.xxx.xxx.xxx not responding, ... # ACPI Support ... # CD-ROM/DVD Filesystems ...
    (Linux-Kernel)
  • Re: Cannot setup SQL Mail on SBS 2003
    ... the newsgroups are staffed weekdays by Microsoft Support professionals to ... server since Exchange server has intalled on the box. ... However if you want to configure SQL to send mail you need to install ... Microsoft CSS Online Newsgroup Support ...
    (microsoft.public.windows.server.sbs)
  • Re: SQL Server installation problem with Vista
    ... The MODIFY FILE problem went away when I deleted the "Microsoft SQL ... Server" directory before reinstallation. ... Microsoft Online Community Support ...
    (microsoft.public.sqlserver.setup)
  • Systems Engineer / Support Analyst, MS MOM, T-SQL, IIS, Active Directory
    ... If you're interested in challenging your network, system and SQL ... Server support skills, working with complex applications on a tenured ... Windows servers, .NET applications, and SQL Server 2005. ... position requires solid knowledge of IIS, AD, web services and SQL ...
    (microsoft.public.sqlserver.setup)