SQL 2005 Express and Standard on same server - Tools problem

Hey folks,

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!

Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

The client tools are only for managing the server and do not impact the servers engine itself.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
mach_1oAuthor Commented:
So I should ignore the warnings, eh?
I would.
Newly released Acronis True Image 2019

In announcing the release of the 15th Anniversary Edition of Acronis True Image 2019, the company revealed that its artificial intelligence-based anti-ransomware technology – stopped more than 200,000 ransomware attacks on 150,000 customers last year.

mach_1oAuthor Commented:
Sadly the removal worked, but the installation of the full tools failed.  Same error as before.  Will I really need to completely uninstall all SQL instances, then reinstall SQL Standard?
Which one is the named instance?

Also, are you trying to run the setup to add the tools from STD from add/remove programs > change/modify to add tools?
mach_1oAuthor Commented:
Unfortunately, my knowledge of SQL is highly limited.  How would I know which is the named instance?  The SQL Express installation existed before SQL Standard.  However, Express Tools allowed me to access both database instances.  When I attempted to connect via Express Tools, I'd be using the server's name to get to the Standard installation and SQLEXPRESS to get to the Express instance.

What I did:
I uninstalled Express Tools via Add/Remove Programs, then went into the SQL Standard install disk and ran SqlRun_Tools.msi, based on advice I saw elsewhere on the Internet. I was able to choose just the Management Tools.  However, it failed shortly thereafter (same as before) with the template.ini upgrade error (reproduced below):

"A component that you have specified in the ADD_LOCAL property is already installed.  To upgrade the existing component, refer to the template.ini and set the UPGRADE property to the name of the component."

It occurs to me that I might be best off detaching the SQL Express DB (running BES server for Blackberry) and migrating it to SQL Standard.  However, I'd like to do that as a last resort, because I fear (like most software) BES might get finicky about moving to a different SQL instance.

Thanks again for your help!
mach_1oAuthor Commented:
Nevermind!  I went back into the main Add/Remove Programs listing for SQL 2005 and ensured the entire tree for Workstation Components was x'd out.  It then allowed me to install the full SQL Standard Tools.

Thanks for your initial response, quelling my fears of uninstallation.  I will be accepting that as the solution to my original problem.  Thanks once again!
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2005

From novice to tech pro — start learning today.