SQL Express and Std on same server - Tools problem

[SnoConeGod]

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!

Thanks!
John

 

[SQLWilts]

Suggestion: Shut down your SQLExpress service.
Backup the files by copying all of the MDF and LDF files somewhere safe.
Done that? Once you have them safe, you can effectively put SQLExpress back the way it is now.
Now restart the service.
Use add/remove programs to remove SQLExpress tools, accepting the warning.
Install SQL Standard tools.
Test
All OK?
Great
All gone wrong?
Uninstall SQLExpress
Install SQL standard tools
Install SQLExpress instance, less tools
Stop the instance
Replace the master, model etc databases with the MDF and LDF files that you previously reserved
Should be done and dusted.
Did I say back up the backup the files first? Can't stress that one enough

 

[SnoConeGod]

Thanks for the tips! I actually figured it out late yesterday, myself. I went ahead and uninstalled the management tools from Add/Remove Programs, then ALSO uninstalled the Management Tools tree from the SQL Server listing in Add/Remove Programs. Afterward, I was able to successfully install the full, Standard Tools. And, of course, I had to apply the SP2 patch to get Maint. Plans going.

Thanks again for your suggestion! Now I need to migrate from SQLEXPRESS -> SQL STD fully (but the Express DB is a BES instance...I fear breaking BES by moving it, even if I follow instructions!)

 

[SQLWilts]

Depends on where the connection strings are held...
You could always install a SQL Std instance with the same name once you have uninstalled Express... just a thought