Discussion Locked

SQL Server 7.0 Errors

0 helpful
7 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I recently uninstalled my SQL Server 7.0 120 day evaluation and installed the full production version. I have noticed a couple of problems.

1. Within Enterprise Manager, under SQL Server Group, the icon next to my SQL Server has the green arrow with a squiggly red vertical line to the right of it.

2. When I right-click on Data Transformation Services and select All Tasks, Import Data, I receive the following dialog box:
DTS Wizard Error: CoCreateInstance
Class not registered.
When I click on OK, I am taken to the first dialog box of the DTS Wizard.

Any help on these issues would be greatly appreciated.

Thanks.

7 replies

by veetel

When you uninstalled, did you delete the mssql7 folder after it finished. If not, try that. When you install the full version, it will re-create the mssql7 folder and you should get a clean install.

by father jack

Only 50% of an answer i'm afraid. The red squggly line as you describe it is meant to be there, dont panic.

by aetrevitt

1. The green arrow means your SQL Server is running; the squiggly red vertical line to the right means you are already connected to your SQL Server.

2. The error "DTS WIZARD ERROR: CoCreateInstance - Class not Registered" most likely means your DTS .dll has been overwritten. Try re-registering DTSPkg.dll first, as a quick fix. If this doesn't work, then try the following:

(Re-)Apply SP1 or SP2
(Re-)Install Internet Explorer 5
Re-Register DTSPkg.dll [Regsvr32 \mssql7\binn\dtspkg.dll]

Anna Trevitt
ADS Ltd

This discussion is closed to new replies.