shirans2308
asked on
I am receiving a "Class Not Registered" error when launching DTS Designer in SQL Server 2000.
I am receiving a "Class Not Registered" error when launching DTS Designer. This error only started happening recently and I am thinking one of the dll's have been overwritten. I backed up all my databases and DTS packages, uninstalled and reinstalled SQL Server 2000. Interestingly, I did not receive the error immediately after reinstalling the product and then going into DTS Designer. However, when I restarted the serverceived the same error again. Here are other things that I have tried:
1. Uninstalled and reinstalled a couple of other times.
2. Installed SQL Server 2000 SP3a on the server.
3. Registered dtspkg.dll through the command prompt.
I am still receiving the error after all of the above.
Thanks in advance,
Shiran.
1. Uninstalled and reinstalled a couple of other times.
2. Installed SQL Server 2000 SP3a on the server.
3. Registered dtspkg.dll through the command prompt.
I am still receiving the error after all of the above.
Thanks in advance,
Shiran.
Did you install SP3a on the server AND your client tools that you use to access the server (the client you actually use to create the DTS packages)???
Maybe some other component is overwritten.
download
http://www.sysinternals.com/files/ntregmon.zip
It is easy to use, search for "NOT FOUND" and "ACCESS DENIED" events before the message occurs.
download
http://www.sysinternals.com/files/ntregmon.zip
It is easy to use, search for "NOT FOUND" and "ACCESS DENIED" events before the message occurs.
ASKER
Hi Arbert,
Yes to both questions.
Yes to both questions.
Ok, so I guess I would as--what changed on the machine around the time it quit working? New software installs? Service Packs? Windows Updates?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
O.K. I found that these dll's were not being registered correctly:
DTSPKG.dll
DTSFFILE.dll
DTSPUMP.dll
However, I can not register them until I had to re-register ATL.dll. Once I had registered this dll and then registered the above, I was able to access the DTS Designer.
When I restarted the machine, the error happened again. I had to re-register all the dll's. It sounds to me as if these dll's are being overwritten everytime I restart the machine. A workaround but no solution : - (.
S.
DTSPKG.dll
DTSFFILE.dll
DTSPUMP.dll
However, I can not register them until I had to re-register ATL.dll. Once I had registered this dll and then registered the above, I was able to access the DTS Designer.
When I restarted the machine, the error happened again. I had to re-register all the dll's. It sounds to me as if these dll's are being overwritten everytime I restart the machine. A workaround but no solution : - (.
S.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.