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!
Please mark posts as the answer if I was helpful. Thanks!
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.
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?
Please mark posts as the answer if I was helpful. Thanks!
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
Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.
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
it.
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. :(
Please mark posts as the answer if I was helpful. Thanks!
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?
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...
Please mark posts as the answer if I was helpful. Thanks!
Regards
Jeremy
If this has helped Please: Don't forget to click "Mark as Answer" on the post that helped you.
That way future readers will know which post solved your issue.
Marked as answer by TATWORTH on Jul 03, 2010 10:49 AM
ParrotBoy
Contributor
2379 Points
487 Posts
Cannot Install SQL Server Management Studio after removing Express edition
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!
Visit my blog
pooriamadani
Member
122 Points
27 Posts
Re: Cannot Install SQL Server Management Studio after removing Express edition
Oct 15, 2007 02:33 PM|LINK
Hey Parrotboy,
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.
MCP , MCAD.NET
ParrotBoy
Contributor
2379 Points
487 Posts
Re: Cannot Install SQL Server Management Studio after removing Express edition
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?
Visit my blog
Bo Chen – MS...
All-Star
17706 Points
1389 Posts
Re: Cannot Install SQL Server Management Studio after removing Express edition
Oct 19, 2007 03:23 AM|LINK
Hi Parrotboy,
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
ParrotBoy
Contributor
2379 Points
487 Posts
Re: Cannot Install SQL Server Management Studio after removing Express edition
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 it.
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. :(
Visit my blog
cfmunster
Member
2 Points
1 Post
Re: Cannot Install SQL Server Management Studio after removing Express edition
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?
ParrotBoy
Contributor
2379 Points
487 Posts
Re: Cannot Install SQL Server Management Studio after removing Express edition
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...
Visit my blog
jeremyh
Star
8173 Points
1477 Posts
Re: Cannot Install SQL Server Management Studio after removing Express edition
Nov 06, 2007 11:09 AM|LINK
Sorry its a little late but take a read of
http://blogs.msdn.com/publicsector/archive/2007/10/26/installing-sql-server-management-studio-when-you-already-have-management-studio-express-installed.aspx
Hope its helpful
Jeremy
If this has helped Please: Don't forget to click "Mark as Answer" on the post that helped you.
That way future readers will know which post solved your issue.
mattboy_slim
Member
17 Points
4 Posts
Re: Cannot Install SQL Server Management Studio after removing Express edition
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.
desmondo
Member
2 Points
1 Post
Re: Cannot Install SQL Server Management Studio after removing Express edition
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