sp_ActiveDirectory_Start problem

I have two Windows 2003 servers that both have SQL 2000 on them with
Service Pack 4 installed. If I run the stored procedure
sp_ActiveDirectory_Start on one, it runs with no problem. However, on
the other, if I run it, I receive the error message xpadsi.exe failed.
Cannot drop the table 'msdb.dbo.ADSINewDBs', because it does not exist
in the system catalog. Could anyone please tell me why I get this. The
only difference that I can see on the servers is that on the one that
runs successfully, there is an x86 folder within Program
Files\Microsoft SQL Server\MSSQL, but on the other there is not,
despite me having run the identical service pack 4 download from MSDN
on both. I would be extremely grateful to anyone who can provide me
with a possible solution to this.

.

Relevant Pages

  • Re: sp_ActiveDirectory_Start problem
    ... > I have two Windows 2003 servers that both have SQL 2000 on them with ... If I run the stored procedure ... > only difference that I can see on the servers is that on the one that ... > despite me having run the identical service pack 4 download from MSDN ...
    (comp.databases.ms-sqlserver)
  • Re: Service pack issue
    ... but you can get away with different service pack levels in most ... my distribution and Subscriber servers are SP3a. ... I cannot update SQL SP ... for the publisher because the applications is not certified SQL SP3a. ...
    (microsoft.public.sqlserver.replication)
  • Re: DTS packages or stored procedures?
    ... a DTS script or a stored procedure ... with linked (SQL) servers? ... Prev by Date: ...
    (microsoft.public.sqlserver.dts)
  • RE: Workload File
    ... There is a specific change in SQL Profiler in SQL Server 2000 from SQL ... obtain the latest service pack for SQL Server ... all ad-hoc queries and executed stored procedure events. ...
    (microsoft.public.sqlserver.programming)
  • Re: per T-SQL alle Tabellen anzeigen?
    ... sind durch den ANSI Standard definiert, während die Systemtabellen des SQL ... Servers sich theoretisch auf Service Pack Ebene ändern können. ...
    (microsoft.public.de.sqlserver)