Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

My problems started when I set up an exploratory domain controller at home. During that process, I changed the name of my laptop, from 'erisia' to 'erisia-laptop', and this resulted in me losing my admin account on SQL Server 2005 on my laptop. SQL Server seems to store the machine name as part of the user name, so now my local admin account is 'erisia-laptop\brady', which SQL server didn't recognise.

I thought I'd cut my losses and just re-install SQL 2005, but the first install was aborted, so I tried a complete uninstall, followed by the new install. The latter didn't work while the former worked way too well.

Now every attempt at installing SQL Server 2005 SP2 on my laptop running XP SP3 ends in sadness, with MSXML6 being the cause, because it won't install on this OS version. WTF? Does anyone know what I can do to get SQL 2005 installed? It's the only full admin DB tool I have. SQL 2008 Express that installed with VS 2010 Beta 2 doesn't allow much server admin.

share|improve this question

2 Answers 2

up vote 2 down vote accepted

Unfortunately this is a known issue. I have used this information to get around it: http://www.ferolen.com/blog/error-install-ms-sql-server-express-in-windows-xp-sp3-msxml6-sp2/

share|improve this answer

I think you should focus on getting MSXML6 installed, because it ought to install just fine on XP SP3.

share|improve this answer
    
I will, as soon as I get my own internet connection back and can begin trying to decipher MS's utterly, gutrenchingly, useless error log messages. –  ProfK Dec 29 '09 at 12:31

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.