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!
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.
|||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?
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
|||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. :(
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...
|||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
No comments:
Post a Comment