SQL Server 2005 Express - error during installation on Windows XP Service Pack 3

Question

 

Hello!

 

We deploy an application that uses SQL Server Express 2005. One of our test engineers tried to use our setup on Windows XP SP 3. But the SQL server installer gave an error - unable to update msxml6r.dll. Is this a bug of the SQL Server installer or do we need to make use of a more recent version of msxml6?

Answer 1

Hi,

Which edition of windows XP you are holding (32 bit or 64 bit)??. You can try uninstalling msxml 6 from your machine, then install the same from the below link. Once this done successfully , try again installing SQLExpress and if it fails pls post summary.txt file...

Download details: Microsoft Core XML Services (MSXML) 6.0

Download details: MSXML 6.0 SP1

Answer 2

I'm installing the English version of SQL2005 Express on an Italian Windows XP SP3 and I've got the same error, I've try also the MSXML 6.0 SP1 but it fail with the same error message :

 

The Windows Installer service cannot update the system file C:\WINDOWS\system32\msxml6r.dll because the file is protected by Windows.  You may need to update your operating system for this program to work correctly.

 

Any idea?

 

 

Answer 3

Hi Marko & Zosimo,

 

You've run into a problem that is created by Windows XP SP3 and at the moment I don't have a resolution for you other than...

1. Install on Windows XP SP2 before upgrading to SP3.
2. Ensure that the language of SQL matches the language of your OS.

The problem is that Windows has decided to put msxml6 under System File Protection for SP3, and this change conflicts with the pre-existing requirements of installing SQL Server. In your specific case (at least Zosimo's case) the issue is related to installing a different language of SQL than the OS you have. During installation msxml64.dll attempts to make a language change that is not allowed under System File Protection.

 

I'm gong to raise this issue with the Windows team to see what solutions they recomend, but I'll let you know up front that these types of issues are not easily, or quickly, solved.

 

Regards,

Mike

 

Answer 4

The error occured when trying to install msxml6 sp1/MSSQL2005 Express SP2 english version onto a german Windows XP SP3. So it is the same case as Zosimos.

Answer 5

I've got the same error on Polish version of Windows XP SP3 - I was installing SQL Server 2005 Express SP2.

Answer 6

Thanks Mike,

 

the workaround you suggest is at least in my case not useful, because I've have to manage different OS languages with my installation procedure and I can't provide all the different SQLEXPR32.EXE on the installation CD.

I've notice that in any case the SQL Express seems to be installed, maybe the msxml6 shipped with the SP3 is the same version, so I hope that the SQL engine can still work with.

 

I hope the Microsoft can provide a new version of the SQLEXPR32.EXE, that check the XP SP3 presence and skip the installation of the msxml6 msi, or as an alternative, the merge modules involved so that we can customize the installation of the SQLExpress.

 

Regards 

 

Answer 7

Well, on my XP (integrated SP3) when I'm installing Visual Studio Pro 2008, SQLExpr32.exe is waiting for nothing. In the same way, SQLExpr32.exe standalone setup waiting for nothing too. So, there are a problem with SP3 because on XP SP2 (with same configuration) there aren't any problem at all.

 

VS log:

 

...

 

[05/15/08,10:43:15] Setup.exe: GetGlobalCustomProperty - Property: {092114C2-997D-4D68-8F3A-8BC2584FD23B} - PropertyName: Quiet Mode Setup - Value:
[05/15/08,10:43:15] Setup.exe: GetComponents()
[05/15/08,10:43:15] Setup.exe: get_Components()
[05/15/08,10:43:15] Microsoft SQL Server 2005 Express Edition (x86): ISetupManager::GetGlobalCustomProperty() failed to find global prop in CBaseComponent::GetGlobalCustomProperty()    <<<<<< ????
[05/15/08,10:43:15] Setup.exe: GetGlobalCustomProperty - Property: {BBE1827C-F2FD-4FDA-A6D6-C83B62FFFDCA} - PropertyName: compfailed - Value: 0
[05/15/08,10:43:15] Setup.exe: GetGlobalCustomProperty - Property: {E0875D42-A33D-4C64-81C9-167795F29CA4} - PropertyName: PathFromCartmanToRoot - Value: ..
[05/15/08,10:43:15] Microsoft SQL Server 2005 Express Edition (x86): GenericComponent Action: CreateProcess launched with cmd line : \\Server\h\setup\..\wcu\sse\SQLEXPR32.EXE -q /norebootchk /qn reboot=ReallySuppress AddUserAsAdmin=1 addlocal=all instancename=SQLEXPRESS SCCCHECKLEVEL=IncompatibleComponents:1;MDAC25Version:0 ERRORREPORTING=2 SQLAUTOSTART=1 /watsongenman=SQL???.mft
[05/15/08,10:43:15] BWaitForMSI(): Verifying we're the only installation currently in progress.
[05/15/08,10:43:15] BWaitForMSI(): Ready to proceed with installation.  Continuing...    <<<<<<<< HERE, Waiting for nothing!
[05/15/08,11:29:54] Install_Close: Microsoft SQL Server 2005 Express Edition (x86)      <<<<<<<< Forced to close!

 

...

 

Regards,

 

Martín

Answer 8

Another workaround seems to be to temporarily disable the system file protection checks.

 

I was able to install the english SQL Server Tools on a german Windows XP after I had set SFCDisable to 2 in the registry(http://support.microsoft.com/kb/222473 / "%SystemRoot%\System32\REG.exe" ADD "\\%ComputerName%\HKLM\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Winlogon" /v SFCDisable /t REG_DWORD /d 2 /f).

 

After the reboot that is necessary to disable the system file protection I successfully ran the tools setup: Setup.exe /qb+ ADDLOCAL=ALL

Answer 9

 

is there a SP-3 for Windows XP professional 64 bit??

Answer 10

Windows XP x64 is serviced by the Windows Server 2003 x64 branch (http://www.microsoft.com/downloads/details.aspx?familyid=893FD6C0-6283-44C3-BB84-B2F0315B2AE6&displaylang=en) and so there won't be a SP3 for it until there is one for server 2003.

 

Windows XP for Itanium 64 Bit Systems was discontinued in early 2005.

Answer 11

 

Ive got the same Error on an Windows Server 2008 Standard x64 ( Terminalserver ):

 

Ive tried to install Navision 5.0 without SP1 including SQL Express 2005 successfully.

 

Then Ive tried to install Navision 5.0 SP1 and got that msxml6r.dll fileprotection error.

 

Anybody knows how to disable the fileprotection on 2008 Server ?

 

Best Regards

 

Hanno Piest

Answer 12

Mike,  You had mentioned in reference to this that you were going to raise this with the Windows team.  Any new info on this?  I am a product manager for an application that uses SQL Express and we just found that we cannot install this on an all English setup.  Are we to recommend to customers to un-install SP3, if that is even possible?  If they already have it installed before they install our app, that might pose a problem.  I was looking for a workaround in this case so that I can document it.

Kind regards,

Stephen

Answer 13

 

Hi i was having the same problem when i am tryig to install Nokia Software Updater. Also it consists MSXML 6.0 Core Services and it failed the installation process since msxml6r cannot be updated since it is protected and it says update your system. So i download MSXML 6.0 SP1 from MS download site and the installation cannot be completed because of same problem again. So i get tired of trying to overwhelm this problem and lastly i uninstall my Service Pack 3 from windows xp. And then i install MSXML 6.0 sp1 without any problems. So i install winxp sp3 again without having any trouble. I recommned you first to uninstall winxp sp3 and then install MSXML 6.0 Core Services Sp1 and lastly install winxp sp3 again to your system.

Answer 14

Another way I successfully tried today is:

- Install Microsoft Core XML Services (MSXML) 6.0 Service Pack 1 (msxml6_x86.msi):

msiexec /i msxml6_x86.msi /qb

 

- Then install SQL Server 2005

SQLEXPR.EXE ADDLOCAL=... ... /qb

 

This way I was able to install without this message, because msxml6_x86.msi seems to be tolerant and SQL Server installation detects MSXML6.1 is already installed.

 

Regards

 

Simon

Answer 15

Same error with English SQL Express 2008 with Advanced Services on a german WinXP Pro SP3:
--
TITLE: Microsoft SQL Server 2008 Setup
------------------------------

The following error has occurred:

The Windows Installer service cannot update the system file C:\WINDOWS\system32\msxml6r.dll because the file is protected by Windows.  You may need to update your operating system for this program to work correctly.

For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=10.0.1600.22&EvtType=0xF45F6601%25401201%25401
--

Details ID: 50000                                              Source: setup.rll                                                  We're sorry There is no additional information about this issue in the Error and Event Log Messages or Knowledge Base databases at this time. You can use the links in the Support area to determine whether any additional information might be available elsewhere.

Thank you for searching on this message; your search helps us identify those areas for which we need to provide more information.

--
Despite the error setup finishes and installs the product.
According to http://msdn.microsoft.com/en-us/library/ms143506.aspx "The English-language version of SQL Server 2008 is supported on all localized versions of supported operating systems."

Answer 16

Hello, this is a known issue and this warning can be safely ignored:

 

1.    Even if you get this warning when installing SQL Server 2005 Express, if you then press OK on the message box, the installation continues normally and SQL Server 2005 Express is installed successfully. The final installation is healthy and it is fully supported by Microsoft, regardless of this warning. So this warning message can be safely ignored.

 

2.    There are some workarounds to avoid this warning:

 

a.     You can disable the system file protection checks before you install SQL Server 2005 Express. You can do this by editing the registry as described in this KB article: Registry settings for Windows File Protection (http://support.microsoft.com/kb/222473)

b.    You can install SQL Express 2005 before you install Windows XP SP3.

c.     You can uninstall Windows XP SP3, then install SQL Express 2005 and finally reinstall Windows XP SP3.

d.    You can use the same language of SQL Server Express to match the language of your Operating System (e.g. install German SQL Express on German Windows XP with SP3).

e.    Install SQL Server by using the command line switch: /qn. This switch will suppress this warning (but it will also suppress all installation errors/warnings).

 

So this warning can be safely ignored

 

Regards,

JD

Answer 17

I also am in an all English environment that is hanging during the install. We do a silent install of Sql S E and it seems to just stop and never finishes. I have looked through the logs and I don't really see anything that stands out to me. The summary.txt file has almost nothing in it which is really weird to me. The install that we do has had no problems working on SP2. We have to be able to install on top of SP3 and can't do the workaround of uninstalling it then installing it. Has Microsoft said anything about this?

 

Answer 18

Any luck with raising this error to the Windows Team?

If nothing else an updated SQL Express 2005 installation that will not fail on XP SP3?

Answer 19

during an installation of SQL EXR the installer failed on MSXML6 and SQL Server Database Services, when i removed sp3 it worked fine, altho now ive lost all the critical updates that i had installed. 

for future reference, are there any workarounds, i tried to install msxml6 sp1 and that failed to install, this would be greatly appreciated so that we can document it in our Help & FAQ Section of our website.

Regards,

Craig Marshall

CM Development / ITHelpAndSupport.Com

Answer 20

 

I'm also still struggling with this error. Our silent installation has stopped working since SP3 got on to our customers XP machines.
Havnt anyone found a working workaround that doenst involve us telling our customer to unistall SP3? Or change in the registry and restart? The menaing of a silent installation is the ease of use for the IT dep and they dont like to manually have to install clients that have SP3 on them.

 

Can someone put some pressure on MS to create a SQL Express 2005 that doenst have this error?

 

Regards,

 

Thomas

Answer 21

JODASK's post on Aug 18, 2008 was insightful but not helpful.

For several years we have deployed a product that installs SQL Server 2005 Express in a silent install mode ( /qn ).  As soon as we started getting customers with Win XP SP3, the install has failed due to the MSXML "warning".  This happens even when the O/S is the same language as SQL Server.

Therefore, two of the five suggested workarounds are not viable because we're already using the same language and we're already using the /qn switch.

The other three suggested workarounds are not attractive.  In some cases, the customer's machine is pre-loaded with Win XP SP3 and cannot be downgraded to SP2.  Directing the customer to hack the SFCDisable key in the registry is risky when you are directing a barely PC-literate customer.  Not to mention that all of these workarounds leave our customers with a low opinion of our product.

What we need is a real fix, not some suggested workarounds that are unworkable in the real world.

Regards,

Answer 22

Has anyone had any success in providing a workaround for this in a commercial software product? 

So far it seems that Microsoft has been silent about providing a fix for this setup bug that they introduced.

---

DanL

Answer 23

Has anyone who saw the problem with  MSSQL Express 2005 SP2 tried MSSQL Express 2005 SP3 (12/2008) to see whether it exhibits this problem?

http://www.microsoft.com/downloads/details.aspx?FamilyID=3181842a-4090-4431-acdd-9a1c832e65a6&DisplayLang=en

Cheers.

Answer 24

Hi, Please note SQL Server 2005 Express Edition SP3 only works with Windows SP XP3 (I have checked it in Read ME). So the problem  SQL Server 2005 SP2 faces with XP SP3 still persists.

Answer 25

Hi all,

Still no reliable answer to this problem ?

None of solutions proposed can be tolerated in production environment.
We cannot ask our end-users to manually use msicuu2.exe.



Best regards,

Answer 26

After refer to URL http://netindonesia.net/blogs/paulus/archive/2009/03/03/cannot-install-sql-server-express-2005-sp2-sp3.aspx - Using Windows Installer Clean Up to remove MS XML SP2, everythings work fine. Is this the only way to solve? MS Team shell make the installer smarter. :>

Answer 27

ManServ,

That's an interesting approach.   Two questions:
a) is there any way not to reboot to affect registry or some sort of fake reboot?
b) would this technique fix Vista installation problem with sql server 2005 express as well?

Thanks.

Answer 28

ahe, just found an answer to a).

Answer 29

@Aryan Kapoor and all,

I've tried the SQL Server 2005 Express Edition SP3 with Windows XP home edition SP3 and Windows XP home edition  SP2 respectively, results: both installations were successful.  Good news.   Could anyone back me up?

TIA.

Answer 30

Here is the answer to most of the problems about Windows SP3 and SQL Server 2005 Express sp2 or sp3. Consider the following scenario:

• You have a Windows XP-based computer on which you apply the update for Microsoft XML Core Services (MSXML) 6.0 that is described in the following Microsoft Knowledge Base article:
  
  
  954459  (http://support.microsoft.com/kb/954459/ ) MS08-069: Description of the security update for XML Core Services 6.0: November 11, 2008
• After you apply this MSXML update, you upgrade the computer to Windows XP Service Pack 3 (SP3).

Go to this knowledge artical and it will guide you threw the problems. http://support.microsoft.com/?kbid=968749

Have a nice day!!!

Answer 31

Mike Wachal,

I've run into an error attempting to install SQL Server 2005 Express for 32 bit Windows XP relative to MSXML6. After browsing some threads in the forum it seems the answer is to be sure to install SQL Server 2005 Express prior to installing Windows XP SP3.  The Install file from the MS Downloads site is named SQLEXPR32.EXE

Background:
I purchased a Visual Basic 2008 Express book (MS Press) with exercises that require SQL Server 2005 Express. Wanting to be sure my machine was all up-to-date before installing the SQL Server I installed Windows XP SP3. The SQL Server installation subsequently failed, log entry below.

Property(S): WrongPackage = This MSXML6 Service Pack 2 (KB954459) package is not supported on the current processor type.

What I tried after reading the forum threads:
Uninstalling MSXML6 using Add Remove Programs. - Uninstall errs.
Uninstalling XP SP3 using Ad Remove Programs. - There is no Remove option.

Now I'm stuck. Can't back out MSXML6 or XP SP3.

Any suggestions?

Thanks,
Eric

----------- 5/19/2008
I found a Knowledge Base article that details how to uninstall Windows XP SP3.
The link is -
http://support.microsoft.com/kb/950249
It describes four ways to uninstall SP3.
The 2nd way worked for me.

Since I had upgraded to IE8 from IE6 after installing SP3 I uninstalled IE8 which brought me back to IE6 prior to uninstalling SP3.
The SQL Server 2005 Express install then went fine.

Following that I successfully installed Visual Basic 2008 Express using the SP1 install file from the Visual Studio Express links. Interestingly, this offered to install SQL Server 2008 Express which I declined since the MS Press book I'm following is based on SQL Server 2005 Express.

I also visited the Update center to get the latest updates since I had backed down to XP SP2. I don't plan in installing XP SP3.

Eric

Answer 32

In my case, I had got no error message. But right now I still can not install sql server express 2005 SP3, my installation pauses at  System Configuration Check screen and it just stands there. I leaved that for several hours but nothing happen, it just shows that screen.


I use windows xp professional verson 2002 sp3.

Anybody can help?

Answer 33

The file they tell you to download is corrupt!

---

Buddha Dude

Answer 34

As I mentioned above, the file MS says to download is corrupt from the server.  I have tried the registry modifications mentioned in previous replies and it does not help for either SQL 2005 Express or Developer editions.  I tried SQL 2008 and although it will go father in the install, it stops saying it has timed out waiting for SQL to start and to check the event viewer.  I check the even viewer and it says:

 

FCB::Open failed: Could not open file e:\sql10_main_t\sql\mkmastr\databases\objfre\i386\model.mdf for file number 1.  OS error: 3(The system cannot find the path specified.).

 

And…

 

FileMgr::StartLogFiles: Operating system error 2(The system cannot find the file specified.) occurred while creating or opening file 'e:\sql10_main_t\sql\mkmastr\databases\objfre\i386\modellog.ldf'. Diagnose and correct the operating system error, and retry the operation.

 

I uninstalled it and reinstalled 3 times and get the same error every time, I have no idea why it is looking in the E drive because I do not have an E drive and I had set the installation to install on C:

---

Buddha Dude

Answer 35

OK, I finally got SQL Express 2008 working, I had to install SQL Express 2005, I let it run though and fail during the install.  I then ran the SQL Express 2008 install and did the upgrade path, now everything is working; what a pain in the *((&%$# !!! 

 

These are the tools we need to get our job done everyday(SQL and VS.net), I sure hope I do not have to go through this every time I rebuild/scrub a system, I need SQL developer but have settled with Express because I need some version of SQL but I just can not spend any more time on it.

 

Please, will someone in the SQL department get this issue fixed!

---

Buddha Dude

Answer 36

This problem is months old.  Why won't Microsoft update their installer for SQL 2005.  We have lots of SQL Express and Workgroup installations as we migrate from Visual Foxpro and we're seeing this problem as often as 5 times a week and it's accellerating as people use Windows Update.

Who is testing at Microsoft? 

When we have to do tech support on what should be a normal installation, it costs lots of money and it is a simple fix to change the installer to require MSXML6 SP1 or later so it would not try to overwrite the SP2.

You want us to tell our clients to use Windows Update, but then when they use it, they disable the installation of our product.

When is the SQL Server 2005 install getting fixed?

-Pat-

---

PatD

Answer 37

I have so far attempted the SP1 of the XML Parser without success, and removing XP3, which has made my system so unstable other than in safe mode, that I am reinstalling SP3.

The original issue presented to me was that the problem was none of the above, which was a RPC security problem there was a patch for, that is supposed to be in SP3, and cannot be installed on top of SP3.

Are there any other options?  Is it possible to hack a script in my installer install to make GP install without installing Sql Server 2005 Express, using Sql Express 2008 instead for example?  That I install separately?  Or switch as a setup up file for this script with 2005 Express?

Or has MS come up with a fix for the SQl 2005 Express installation file that I can use with my existing scripts?

Thanks.

MMP

Answer 38

Hi,

I have XP SP3 and tried instaling SQL 2005. As usual installation failed. Whne I checked the LOG, it showed as OS not suported.

I think its the OS not supported SP3.

SO, I wil try al of the suggested steps.

and wil update here shortly

Answer 39

I was unable to get the MSXML6 function through the standard download installation disk or standard disk.  Disabling SP3 protection failed and no installation. 

Still needing the management studio, I was able to get the studio express to work and now I have the tools I need.

http://www.microsoft.com/downloads/details.aspx?familyid=5D76230D-580D-4874-8C7D-93491A29DB15&displaylang=en#filelist

 

 

Answer 40

Hello Sir,

I'm unable to install SQL 2005 nor use it when installed since there was no instance relating to Database Engine on my system,I tried re installing but it gave me an error saying that SQL server cannot change or upgrade SQL server previously installed.I'm using Windows XP  SP3.I'm able to find instances pertaining to other  services provided by the respective software but not the Database engine.I've tried installing 10 times in a row but in vain.Please help.

Regards,

Deekshit.

Answer 41

The MSXML 6.1 install vs. the MSXML 6.0 worked for me too.

Thanks for suggesting this.

Answer 42

raf

Thanks a lot for sharing.

Answer 43

hi can u help me how do u install sql server 2005 on in xp sp2 pls my id [e-mail]

Answer 44

Hello Mike,

           when i am installing SQL server 2005 express sp2 on windows 2008 r2 (here sql 2008 express edition is already installed) instance creation is failed.and it is showing error message like "The SQL Server service failed to start. For more information, see the SQL Server Books Online topics"

is there any compatible issues are there?

thanks in advance!!!!

Regards,