January 25, 2008 at 1:59 am
Hi all,
I'm hoping someone can spread some light on some issues Im having now that I have uninstalled mssql2005. We decided we were not going to use the extra feature set of 2005 enough to justify the cost and time involved in lerning the new DTS developmen tools.
When we uninstalled 2005 though we immediately had two problems and I dread to think what else has gone one. The first we solved quickly enough but I'm pasting it here for others benefit (there is also an MSDN entry for it here http://support.microsoft.com/kb/914157). Basically, removing the backwards compatibility tools also removes required registry keys that EM uses and it wont start withtout these entries. You also have to re-register Program Files\Microsoft SQL Server\80\Tools\Binn\sqlmmc.dll the mmc snapin DLL.
The second problem which i have not been able to solve, I think involves paths in some way. None of the serveragent tasks that dun DTSrun can now find dtsrun. The jobs work fine again if you put the full path in the job step. I have checked the environment variables and Program Files\Microsoft SQL Server\80\Tools\Binn\ exists as a path variable. Is there somewhere else that serveragent gets its paths from..?
Any help appreciated and any other uninstallation issues and experience would be appreciated.
Thanks
Rolf
January 25, 2008 at 8:29 am
Rolf,
I hope you didn't test this on a production machine...
Have you tried re-running the SQL 2000 install process to see if it gives you a repair option?
Look at 2000 BOL for this topic: installing SQL Server, advanced options
That may or may not help you.
January 25, 2008 at 10:18 am
I have tried reinstalling....there is no repair option as such, just the option to add or remove sections. I could try removing all the client tools and reinstalling them.
I'll try that this evening.
I would like to get to the bottom of it though so I can find a proper solution to paste should it ever happen to anyone else.
Thanks
Rolf
January 25, 2008 at 10:48 am
The problem is that SQL Server Agent is not part of the client tools. It's part of the whole SQL Server Engine install. So taking off the client tools and putting them back in won't help.
Try restoring MSDB from a backup prior to the 2005 uninstall. See if that helps.
And Advanced Options has a Registry Repair that might assist you which is why I pointed it out in my last post. Have you tried that yet?
January 25, 2008 at 12:05 pm
I have already tried the registry rebuild, made no change.
January 25, 2008 at 12:11 pm
If all else fails, you might have to back up all your databases, uninstall and then reinstall SQL Server, then restore all your databases.
But try the MSDB restore first. See if that works by itself.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply