Install Microsoft SQL on Windows 11

Discussion in 'Parallels Desktop on a Mac with Apple silicon' started by CraigH23, Jul 21, 2023.

  1. CraigH23

    CraigH23 Junior Member

    Messages:
    21
    Hello,

    I'm using Parallels on my 2021 M1 MacBook Pro to run Windows 11 ARM, but I'm struggling to install Solidworks because Microsoft SQL won't install properly. Is there a workaround to fix the SQL installation issue so that I can get Solidworks running?
     
    CraigH23, Jul 21, 2023
    #1
  2. Avinash Bundhoo

    Avinash Bundhoo Staff Member

    Messages:
    674
    Hello,

    The issue you're encountering is related to the fact that Microsoft SQL Server does not support ARM based processors yet.

    As workaround from Github, you can try the steps below:

    To install MySQL server,

    1. Go to the link https://github.com/jimm98y/MSSQLEXPRESS-M1-Install
    2. Click on the folder "src".
    3. Right Click on the each *.bat and .*ps1 files, and Select "Save link as".
    4. Save all *.bat and .*ps1 to the Mac Desktop
    5. Copy all the *.bat and .*ps1 files to the Windows virtual machine.
    6. In the virtual machine, launch Powershell as Administrator
    7. In Powershell, type "Set-ExecutionPolicy Bypass" and press "Enter"
    8. Right Click on the .bat file for the SQL Server version you want to install and "run as Administrator"
    9. Wait until the script is executed successfully

    Let us know if the workaround works for you.

    Thanks
     
    Avinash Bundhoo, Jul 21, 2023
    #2
  3. CraigH23

    CraigH23 Junior Member

    Messages:
    21
    Hi Avinash,

    Thanks for your response.

    Will your fix address the Solidworks-specific problem or just the SQL issue? I need to ensure a successful Solidworks installation.

    Thanks
     
    CraigH23, Jul 21, 2023
    #3
  4. Mike Retondo

    Mike Retondo Bit poster

    Messages:
    7
    Curious how does these steps make a Microsoft SQL Server what was not built for ARM now run on ARM. I thought Parallels for M series Macs don't do Intel to ARM emulation?
     
    Mike Retondo, Nov 18, 2023
    #4
  5. MatthewR20

    MatthewR20 Most valuable person

    Messages:
    244
    Microsoft has a translation layer (similar to rosetta) built into windows arm that can run x86 programs.
     
    MatthewR20, Nov 18, 2023
    #5
  6. mrbartuss

    mrbartuss Bit poster

    Messages:
    3
    5. Copy all the *.bat and .*ps1 files to the Windows virtual machine.

    Sorry, but I'm a total noob. Where exactly should I copy them. If I share my Mac Desktop to Parallels can I simply run them from here?
     
    mrbartuss, Mar 16, 2024
    #6
  7. MichaelT64

    MichaelT64

    Messages:
    1
    Craig, were you able to get this working? I'm in a similar position with Solidworks / PDM and would like to get it working on Mac. I don't see any *ps1 files at the GitHub link, either.
     
    MichaelT64, Nov 12, 2024
    #7

Share This Page