Need equivalent for SQL Server 2005 Express that will work with 12th generation Intel i7-12SSU processor

Question

SQL Server 2005 Express will not work with processor on new PC (Intel 12th gen, i7...) The SQL is needed to install and run "The Photo Atlas of Minerals". Is there an equivalent or a work around? Install log, processor info, and screen shot of error message below:

Install log ---

The following properties have been set:

Property: [AdminUser] = true {boolean}

Property: [ProcessorArchitecture] = AMD64 {string}

Property: [VersionNT] = 6.2.0 {version}

Running checks for package 'Microsoft Data Access Components 2.8', phase BuildList

Reading value 'FullInstallVer' of registry key 'HKLM\Software\Microsoft\DataAccess'

Read string value '6.3.9600.16384'

Setting value '6.3.9600.16384 {string}' for property 'MDACVersion'

The following properties have been set for package 'Microsoft Data Access Components 2.8':

Property: [MDACVersion] = 6.3.9600.16384 {string}

Running checks for command 'MDAC28\mdac_typ.exe'

Result of running operator 'VersionGreaterThanOrEqualTo' on property 'MDACVersion' and value '2.80': true

Result of checks for command 'MDAC28\mdac_typ.exe' is 'Bypass'

'Microsoft Data Access Components 2.8' RunCheck result: No Install Needed

Running checks for package '.NET Framework 2.0', phase BuildList

Running external check with command line "C:\Users\Cimar\AppData\Local\Temp\VSD92D4.tmp\dotnetfx\dotnetchk.exe"

Process exited with code 2

Setting value '2 {int}' for property 'DotNetInstalled'

Reading value 'Version' of registry key 'HKLM\Software\Microsoft\Internet Explorer'

Read string value '9.11.22621.0'

Setting value '9.11.22621.0 {string}' for property 'IEVersion'

The following properties have been set for package '.NET Framework 2.0':

Property: [DotNetInstalled] = 2 {int}

Property: [IEVersion] = 9.11.22621.0 {string}

Running checks for command 'dotnetfx\instmsia.exe'

Result of running operator 'ValueExists' on property 'VersionNT': true

Result of checks for command 'dotnetfx\instmsia.exe' is 'Bypass'

Running checks for command 'dotnetfx\WindowsInstaller-KB893803-v2-x86.exe'

Result of running operator 'ValueExists' on property 'Version9x': false

Result of running operator 'VersionLessThan' on property 'VersionNT' and value '5.0.3': false

Result of running operator 'VersionGreaterThanOrEqualTo' on property 'VersionMsi' and value '3.0': true

Result of checks for command 'dotnetfx\WindowsInstaller-KB893803-v2-x86.exe' is 'Bypass'

Running checks for command 'dotnetfx\dotnetfx.exe'

Result of running operator 'ValueNotEqualTo' on property 'DotNetInstalled' and value '0': true

Result of checks for command 'dotnetfx\dotnetfx.exe' is 'Bypass'

'.NET Framework 2.0' RunCheck result: No Install Needed

Running checks for package 'Windows Installer 2.0', phase BuildList

The following properties have been set for package 'Windows Installer 2.0':

Running checks for command 'InstMSI\instmsia.exe'

Result of running operator 'ValueExists' on property 'VersionNT': true

Result of checks for command 'InstMSI\instmsia.exe' is 'Bypass'

Running checks for command 'InstMSI\instmsiw.exe'

Result of running operator 'ValueExists' on property 'Version9x': false

Result of running operator 'VersionGreaterThanOrEqualTo' on property 'VersionMsi' and value '2.0': true

Result of checks for command 'InstMSI\instmsiw.exe' is 'Bypass'

'Windows Installer 2.0' RunCheck result: No Install Needed

Running checks for package 'Windows Installer 3.1', phase BuildList

The following properties have been set for package 'Windows Installer 3.1':

Running checks for command 'WindowsInstaller3_1\WindowsInstaller-KB893803-v2-x86.exe'

Result of running operator 'VersionGreaterThanOrEqualTo' on property 'VersionMsi' and value '3.1': true

Result of checks for command 'WindowsInstaller3_1\WindowsInstaller-KB893803-v2-x86.exe' is 'Bypass'

'Windows Installer 3.1' RunCheck result: No Install Needed

Running checks for package 'SQL Server 2005 Express Edition', phase BuildList

Running external check with command line "C:\Users\Cimar\AppData\Local\Temp\VSD92D4.tmp\SqlExpress\SqlExpressChk.exe"

Process exited with code 1

Setting value '1 {int}' for property 'SQLExpressInstalled'

The following properties have been set for package 'SQL Server 2005 Express Edition':

Property: [SQLExpressInstalled] = 1 {int}

Running checks for command 'SqlExpress\sqlexpr32.exe'

Result of running operator 'ValueEqualTo' on property 'SQLExpressInstalled' and value '0': false

Result of running operator 'VersionGreaterThanOrEqualTo' on property 'VersionNT' and value '5.1': true

Result of checks for command 'SqlExpress\sqlexpr32.exe' is 'Bypass'

Running checks for command 'SqlExpress\sqlexpr32.exe'

Result of running operator 'ValueEqualTo' on property 'SQLExpressInstalled' and value '0': false

Result of running operator 'VersionLessThan' on property 'VersionNT' and value '5.1': false

Result of running operator 'ValueEqualTo' on property 'AdminUser' and value 'false': false

Result of running operator 'ValueExists' on property 'Version9x': false

Result of running operator 'VersionLessThan' on property 'VersionNT' and value '5.1.2': false

Result of running operator 'ValueNotEqualTo' on property 'ProcessorArchitecture' and value 'Intel': true

Result of checks for command 'SqlExpress\sqlexpr32.exe' is 'Fail'

'SQL Server 2005 Express Edition' RunCheck result: Fail

A prerequisite failed for Package "SQL Server 2005 Express Edition"

Package failed with message "This version of SQL Server 2005 Express Edition is not supported for the current processor architecture."

Processor --- Processor 12th Gen Intel(R) Core(TM) i7-1255U 1.70 GHz

error message screen shot

Answer 1

I get the impression that the error message comes from Photo Atlas application, not the SQL Server installation itself. SQL 2005 should have no issue with the Intel processer, no matter if it's 32-bit or 64-bit SQL Server.

It is possible to install SQL 2005 on Windows 10 and WIndows 11, but it does require tweaks. If you you run Setup and press Next, Setup will fail. If you want to know the tweaks, Google is your friend. (I say so, because I don't remember the tweak on the top of my head.)

Then again, if you install SQL Server manually, you might as well install a newer version. Assuming that is that Photo Atlas does not check the SQL Server version. And for that matter, Photo Atlas is prepared to use an existing SQL Server instance at all.

Answer 2

Hi @Writhdar ,

As you can see, the error is 'This version of SQL Server 2005 Express Edition is not supported for the current processor architecture'.
You can refer to the prerequisites for installing SQL Server 2005.

However, the Intel i7 series is all 64-bit.
So you have two options, one is to change the processor or install a 64-bit SQL Server. the SQL Server 2005 version is too old. You can choose a newer SQL Server if your operating system allows it.
Using SQL Server in Windows

Best regards,
Seeya

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 3

SQL Server 2005 Express will not work with processor on new PC

SQL Server 2005 is out-of-support since a very long time, so you can not expect it's supports current OS or hardware.

Answer 4

The process for notifying me of responses is labyrinth to say the least.
I only became aware of these answers when I just did a DuckDuckGO search on the SQL - I did not get any emails on this and it was very difficult to find these on the Q&A.

So, thank you for the responses. From ES's answer, I found https://download.cnet.com/Microsoft-SQL-Server-2005-Express-Edition-Service-Pack-4/3001-10254_4-75452276.html and this allowed me to install the SQL 2005 and then the Photo Atlas. I now have some issues with the Photo Atlas on the new PC but I will try to work through them.