StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>I'm running windows 7 64 bit on my laptop. I had originally installed SQL Server 2008 Express Edition with Advanced Services and then because it ran so slow on my machine, I used Revo Uninstaller to uninstall it from my system. That was a big mistake! I have used Revo for years without issue, until I used it for uninstalling SQL Server.</p> <p>So, the lesson learned is use the control panel to remove SQL Server if I ever do it in the future. I couldn't reinstall windows as I've got too much configured software and code on this machine. I couldn't do a system restore as my restore points didn't go back that far and I was able to get my registry reset prior to all these changes by doing a system restore back to the early part of April 2013. There were no options to go back any farther. </p> <p>Then I found SQL Server 2008R2 Express with tools and that sounded like what I needed as it required a lot less memory to run. However, I couldn't get it installed. I'd try doing deletes in the reqistry, based on blogs I'd read about how to manually reinstall SQL Server when you used a 3rd party tool to uninstall it. I'd get a 1605 error, then another error, then another different one. I tried these different ways:</p> <ol> <li><a href="http://social.msdn.microsoft.com/Forums/en-US/sqlsetupandupgrade/thread/aea5f2ae-91f1-431a-9458-bcfa641d2eae/" rel="nofollow noreferrer">Clean install of SQL Server</a> </li> <li><a href="http://support.microsoft.com/kb/955404" rel="nofollow noreferrer">Reinstall of SQL Server fails</a> </li> <li><a href="https://superuser.com/questions/299929/how-to-remove-a-broken-installation-of-sql-server-2008">How to remove a broken install of SQL Server 2008</a> </li> <li><a href="http://social.msdn.microsoft.com/Forums/en-US/sqlexpress/thread/befb3f11-26a4-4eb9-8170-36cc097636ec/" rel="nofollow noreferrer">Error while installing SQL Server 2008R2</a> </li> </ol> <p>, but nothing worked. At best everything installed, except tools, but then I'd delete more registry items and it wouldn't even start to install.</p> <p>I started over with the registry back to when I first started the reinstall, after the system restore and tried to install it again. What I did was type %localappdata%\Microsoft_Corporation into the address box in Windows Explorer and then deleted that folder as mentioned above. That got me past one error about a missing file that the installer couldn't find and that I had seen before, but this didn't solve the other problems, as when I tried to install everything, the management tools - basic didn't install and threw an installation error. </p> <p>So I used the control panel and removed the tools and the server instance only. <strong>It seems that if you can get SQL Server loaded up again or mostly so to where you can uninstall it or items that weren't fully installed through the control panel in windows, that is the best way to get things back to a state where you can get it reinstalled. Otherwise you are stuck with manually editing the registry and hoping you don't mess things up worse. I tried the registry tricks five or six times with no successes!</strong> </p> <p>In any event, it threw an error trying to remove the tools, but had removed enough so that I could reinstall it again, just adding in those two items that I had removed or partially remove through the control panel: management tools and the server instance. </p> <p>No registry changes were made and I didn't have to delete any of the SQL Server folders on my machine, but this time it worked! The tools version doesn't take much memory to run, so my machine can handle it well with 4gb's of ram.</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload