Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Oct 06, 2010 10:42 AM by desmondo
Oct 15, 2007 01:21 PM|LINK
I'm trying to upgrade my management studio to the full version, I uninstalled Express edition and started the install for the full version, but I get an error stating "you cannot install this component because it is already installed". I had a word with
one of the guys in the office and he said the only way he's ever been able to get round this is by flattening the entire PC and starting again. Obviously I want to avoid that!
Oct 15, 2007 02:33 PM|LINK
You asked awesome question , I never had this problem but I had something like this.
At first tell me Do you have any SQL Server on your desktop ? if so what version is that?
and review your Regedit to find SQL Server directory there is some setting that you can change them and I hope you will able to set that up.
Oct 16, 2007 06:41 AM|LINK
I don't have SQL on my desktop nope.
I took a look in the registry and the only settings I can find that look at all relevant are in HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SQL Redist. Theres a folder called 1.00.00 with a default token with no value, and a folder called Setup with a default
token (no value) and a REG_DWORD called ExitCode with 0x000000 (0) as the value.
I can't see how they would be interfering really, is it worth deleting the whole SQL Redist folder?
Oct 19, 2007 03:23 AM|LINK
So, you have sql server management studio express installed on your machine(without database engine installed) and now, you want to update(anyway, i don't think it can be count as "update")management studio to a "full" version--develope version or enterprise
version or standard version or whatever. Correct me if my understanding is wrong.
Open your control pannel and click "add or remove programms", then select sql server, click the change button. All the sql component you have installed are listed there. Just check if you have uninstalled management studio express successfully. And if not,
select it and choose "next", "remove".
Hope my suggestion helps
Oct 19, 2007 07:21 AM|LINK
I've tried that. There is no entry in add/remove for SQL Server, I have already uninstalled it from this route. Thats why its baffling me, there must be something left after the uninstall which is stopping the install for the new version, but I can't find
I wish I'd never decided to upgrade now, I'm stuck using the server explorer in VS2005 which is OK, except that I need to use table/field extended properties which can't be modified through VS. :(
Nov 02, 2007 04:36 PM|LINK
I am having this same problem. I was wondering if you ever found a solution? I had Mgmt Studio Express installed and removed it. I had a version of Visual Studio installed and removed it. There were some errors during de-installation, and I think that has
left my system in a sort of install limbo, with maybe registry entries and some shared files still installed. Apparently the SQL Server installer is tripping over those files/entries and not allowing me to upgrade. I checked the logs and changed the settings
in template.ini for the installer to upgrade the Tools and skip upgrade blockers, but that didn't work. I really don't want to re-image my machine to get past this problem. Does anyone know the files/registry entries that the installer is checking? I will
just delete them by hand if I have to. Why does Microsoft have to make this so complicated?
Nov 06, 2007 07:10 AM|LINK
Nope I never found a solution, aparently the ONLY option is to wipe the PC and start again, which simply is not an option for me. So now I'm stuck writing any complex update to the DB in pure SQL...
Nov 06, 2007 11:09 AM|LINK
Sorry its a little late but take a read of
Hope its helpful
Jun 03, 2010 03:24 PM|LINK
Definitely late on my reply, but I just wanted to inform anyone searching that the above link has resolved the issue for me.
Oct 06, 2010 10:42 AM|LINK
Oh the power of the internet - good shout jeremyh, I thought I'd just crippled one of my dev VM's