March 23, 2010 at 9:59 am
I am attempting to install SQL Server 2008 developer onto a brand new Dell (32 bit) running Windows 7. I am a programmer, and am used to having the machines I use come loaded by the hardware/installation guy in the company I work with. New company now, so new rules and I am at a total loss on the settings and issues that come up, despite having spent the last 6 years at the computer 5 days a week.
I first ran the setup yesterday, creating a name instance of SQL Server (let's call it "inst01" for now). Something failed while I was doing it, but when I picked up the computer to move it somewhere else, I accidentally leaned on the keyboard and everything disappeared. I could not figure out how to retreive the post-installation screen that I was looking at or how to fix the problem, so I decided (probably not the brightest idea, but I'm stumbling in the dark here) to uninstall everything and start again. So I went into the Remove Programs screen and uninstalled everything that had an installation date of 3/22, inserted the SQL Server 2008 Developer disk again, and started repeating what I had done yesterday. However, when I got to the default instance/named instance screen, I noticed that there was already a choice for the instance "inst01", and sure enough, when I tried to create a new "inst01", it did not allow me to. So instead, I decided to select the other option (something like "add features to existing inst01 instance"). I noticed that this install did not install everything that yesterday's install did (I think Visual Studio 2008 was installed the first time, but not this time) Then I went to download SQL Server 2008 SP1, as per all the instructions for installing SQL Server 2008 on a Windows 7 machine, and I got the following error:
SQL Server Setup has encountered the following error:
A failure was detected for a previous installation, patch, or repair for instance 'inst01' during configuration for features [SQL_Replication_Core_Inst,SQL_Engine_Core_Inst,MPT_AGENT_CORE_CNI,SQL_FullText_Adv,Analysis_Server_Full,RS_Server_Adv,]. In order to apply this patch package (KB968369), you must resolve any issues with the previous operation that failed. View the summary.txt log to determine why the previous operation failed.
Error code 0x84B20001.
I looked at the file summary.txt, but there were no obvious errors. How can I figure out what to do from here - either repair or start clean (preferrably with the same name)?
March 23, 2010 at 11:13 am
when you uninstalled SQL, did you happen to bounce the box? this would have finished the uninstall process by doing things stopping the services, and deleting the remaining files in the directory. If not, do that. Then open Windows Explorer and delete the directory and any files that may still be there. also, check registry to verify that all of the SQL hives are gone. Do you already have an instance named Express on this box?
Then bounce the box again, and begin the install. your first install failed for some reason. The log files are still on the box, but it is not worth the time or trouble to view them. Dump what you have and start the install again. Simple and quick
Why do you want a named instance? You can use the default instance of no name. I would not recommend using an instance name unless you plan on installing multiple flavors of SQL Server on the same box. I have SQL 2000, 2005 and 2008 all on the same box, so I use instance names to keep them organized for ease of viewing.
When installing software, do not move the box, just keep things simple and run thru the installs. You should never move a box while it is running any way. That can really mess up a fast spinning drive. Ever heard of centrifugal force?
Andrew SQLDBA
March 24, 2010 at 9:08 am
Thanks for your help. I uninstalled, tried to delete everything I could find (hopefully I was not overzealous), rebooted a couple times, and reinstalled a default instance. The installation went through with no errors, although it STILL found the named instance on my machine (I admit I did not touch the registry, as I don't think I understand it well enough and didn't want to wreck anything.)
One question: I deleted a folder/programs for Microsoft Visual Studio, since they appeared to be installed on 3/22, just like the other SQL programs. However, they did not get reinstalled with this installation. Do I need Visual Studio? If so, what do you recommend I do now?
Thanks!
March 24, 2010 at 1:13 pm
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply