So I have a previous installation of SQL 2005 Express on my server and have since added an instance of 2005 Standard (both are running with live, production data). The problem is, the 2005 Express Tools are still installed and I cannot install the full 2005 Tools over the top. Each time I receive an error asking me to use an upgrade method in the template.ini file.
Would it be sufficient to uninstall the 2005 Express Tools from Add/Remove Programs, then attempt a new install of the full 2005 Tools afterwards? I balked at this because the Express Tools removal warned me that SQL may stop functioning. Is this just a blanket warning from Microsoft, or is it a real concern? Should I possibly take another route of installation?
I just want to be able to set up Maint. Plans!