While patching SQL server 2005 SP1 to SP2, we face below error
Error: The image file is valid , but is for a machine type other than the current machine
This error clearly states that patch file is good, the issue is with my machines
Why we get this error:
In my case Sql server is 32 bit and I am applying 64 bit sql patch. The case could be vice versa as well.
To confirm which patch to be applied please run "Select @@version" in sql server query analyzer. This will give you x64 in case of sql server is 64 bit and x86 in case sql is 32 bit.
So once confirm what we need, Do a fresh patch down load and install.