Problems with MS SQL SERVER 2005

Hi

I m having a problem while installing MS SQL SERVER 2005!

Initially I had the Developer edition, which got corrupted without giving me a single clue....why it happend!

And later to free some space, i uninstalled all the SQL components from add/remove programs!

Now, i have this Enterprise edition which when i tried to install went till the last and cropped up with an error:

"A component that you have specified in the ADD_LOCAL property is already installed. To upgrade the existing component, refer to the template.ini and set the UPGRADE property to the name of the component."

what to do??

i have tried removing the instance from my control panel and re-installing but the same error popped up again!

I have no clue.....so kindly guide me out of it!!

http://support.microsoft.com/kb/909967

Manually uninstall...restart and try again

MLF

Tried doing that!

done all the steps in there.....restarted the machine and tried installing again!

now here's the new error that cropped up during installation!!

plz guide!

You might want to start by trying it on a supported OS. XP ain't one of them. I don't even know if you can fake it to install on XP. It's missing some major requirements right there.

guidance = install on 2000 Server (sp4) or 2003 Server or download the free Desktop version.

Well...i didnt get that completely!

I have installed SQL Server 2000 and the SQL SERVER 2005 Express Edition on my Windows XP earlier and they worked fine.

So, I think the current version i.e. SQL SERVER 2005 Enterprise Edition must also work normally. Do u think, it requires some server component that might be present in the SERVER OS and not the CLIENT OS?

Thanks

n installing a new OS will b a bit difficult for me. coz this I m using on my own standalone home machine for doing out a project.....and I may not be able to get a new OS at this point of time!

Any other things, u might want to suggest?

I think the key word here is

"Enterprise Edition"

and no...it aint gonna work on a workstation OS

MLF

aah....yes...that can be the thing!

maybe the enterprise edition is accustomed to work on only SERVER OS and not the CLIENT OS!

In that case, I can arrange a different edition of SQL....coz thats part of the deal from where i got this thing! So which edition should i go for?

Quote:

---

or download the free Desktop version.

---

http://msdn.microsoft.com/vstudio/ex...r/default.aspx

Its amazing but www.microsoft.com has alot of info about MS SQL 2005

;)

MLF