October 21, 2009 at 4:25 pm
Not exactly sure why this option is not available from within my SQL Server 2000 install in my clustered environment.
Trying to create a DTS package that will modify an Address Lists in Active Directory.
Windows Server 2003 SP1, MS SQL Server 2000 SP3, MDAC 2.8 SP1.
The option just does not exist, although I have Data Mining Services, OLAP Services, OLAP Services 8.0, Oracle and SQL Server OLE DB providers available.
Cheers to whom can point me in the right direction.
Thanks,
Eldin
October 21, 2009 at 4:47 pm
eldin (10/21/2009)
Not exactly sure why this option is not available from within my SQL Server 2000 install in my clustered environment.Trying to create a DTS package that will modify an Address Lists in Active Directory.
Windows Server 2003 SP1, MS SQL Server 2000 SP3, MDAC 2.8 SP1.
The option just does not exist, although I have Data Mining Services, OLAP Services, OLAP Services 8.0, Oracle and SQL Server OLE DB providers available.
Cheers to whom can point me in the right direction.
Thanks,
Eldin
It could be related to service packs because Win2003 SP2 fixed many MDAC issues and your SQL Server is too out of date because SQL Server was SP4 in 2005 or 2006.
Kind regards,
Gift Peddie
October 21, 2009 at 4:51 pm
The only reason we have not updated out service pack levels on this machine is because of our ERP system. It is very fidelly and does not like patches. We have been told by the vendor to leave the current service pack levels as is.
So in other words, there is no way to manually fix this or add this?
October 21, 2009 at 5:04 pm
eldin (10/21/2009)
The only reason we have not updated out service pack levels on this machine is because of our ERP system. It is very fidelly and does not like patches. We have been told by the vendor to leave the current service pack levels as is.So in other words, there is no way to manually fix this or add this?
I think it is very careless for an ERP vendor to expose their customer to the reason SQL Server 2000 must be SP3a and above and you need to ask them what their application is doing with Windows so you cannot add SP2 which fixes a lot of problems. ERP system is too expensive to force your system to be out dated.
Kind regards,
Gift Peddie
October 22, 2009 at 12:03 am
Well I took your advice, contacted the vendor and asked if those updates were ok, they said that was fine.
Upgraded to SP2 on the OS and SP4 on SQL.
Rebooted, tried again and still no Directory Services listed.
=/
Any more ideas?
October 22, 2009 at 7:23 am
eldin (10/22/2009)
Well I took your advice, contacted the vendor and asked if those updates were ok, they said that was fine.Upgraded to SP2 on the OS and SP4 on SQL.
Rebooted, tried again and still no Directory Services listed.
=/
Any more ideas?
Check to see if someone or some application disabled it but what I told you to do was the right thing because of SQL Server worm if your SQL Server 2000 is not up to SP3a.
http://support.microsoft.com/kb/327489
Kind regards,
Gift Peddie
October 22, 2009 at 4:13 pm
OK this is the weird part.
When I create a linked server, I see the option OLE DB Provider for Microsoft Directory Services.
But when I attempt to create a DTS package with the connection type set to the Directory Services provider, it does not appear in the drop down list.
Is this normal behaviour and something that is not supported by DTS, or does there appear to be something wrong with my configuration?
October 23, 2009 at 2:42 pm
eldin (10/22/2009)
OK this is the weird part.When I create a linked server, I see the option OLE DB Provider for Microsoft Directory Services.
But when I attempt to create a DTS package with the connection type set to the Directory Services provider, it does not appear in the drop down list.
Is this normal behaviour and something that is not supported by DTS, or does there appear to be something wrong with my configuration?
I am running Windows 7 which may not run SQL Server 2000 without virtual machine but in 2005 I can see the AD OLE DB driver so it may be your employer have installed only needed components as a developer I use all features so you may install SQL Server 2005 to use that driver I am in SP3.
Kind regards,
Gift Peddie
Viewing 8 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply