I can't install sql server management with windows 11 - M1 // Please help

Discussion in 'Parallels Desktop on a Mac with Apple silicon' started by faisal3, Jun 7, 2023.

  1. faisal3

    faisal3 Bit poster

    Messages:
    6
  2. Troy T.

    Troy T. Bit poster

    Messages:
    6
    Best Answer
    You can absolutely install and run either SQL Server 2019 or SQL Server 2022 Express or Developer Edition along with SQL Server Management Studio v19 within a Windows 11 on ARM installation in Parallels on Apple Silicon Macs. Since SQL Server Management Studio 2019 is 32-bit I had zero issues downloading it directly from Microsoft's website and installing it but SQL Server 2019 Express and Developer Editions as well as SQL Server 2022 Express and Developer Editions wouldn't install. The installer would download and inevitably choke. I searched the web and was starting to think going with a Docker style solution or installing UTM and going the x84-x64 emulation route which would have really hurt performance because of the emulation layer and then I stumbled upon this GitHub repository that contains both batch files that you can execute from the command line as well as the underlying PowerShell scripts they invoke that will download and install SQL Server 2019 Express, SQL Server 2019 Developer Edition, SQL Server 2022 Express or SQL Server 2022 Developer Edition on Windows on ARM installations. Just download and appropriate batch file and powershell script, put them in a temporary folder then open a command prompt as the administrator and execute the batch file. It will download the installation media for the desired version of SQL Server for you and also download and install SQL Server Management Studio 2019 as well.

    I wanted to do a clean install to avoid any errors so I removed SQL Server Management Studio v19 that I had previously downloaded so the scripts could download and install it and not run into any errors along the way. Use the links below to download the appropriate batch file and its associated Power Shell script that it invokes for the version of SQL that you want installed. If you're comfortable running Power Shell scripts you don't need the batch file but if you're not then download the batch file and it's matching Power Shell script to the same temporay folder and run the batch file as an administrator and you'll be good to go.

    https://github.com/jimm98y/MSSQLEXPRESS-M1-Install/tree/main/src
     
    PaoloR5, MennoE1 and DyanM like this.
  3. Pavel Merkulov

    Pavel Merkulov Parallels Team

    Messages:
    144
    Hello,

    As a result of a number of similar cases we've had, we've performed various tests on a physical Windows Arm PC, and we had to conclude and there doesn't appear to be a way to successfully run SQL Server products (including SQL Server Express/Compact etc.) on a Windows Arm machine, physical or virtual.

    These results are consistent with the information that can be found on the Internet in regard to running Microsoft Server on Windows ARM.

    As a workaround, you can perform the steps from the article: https://kb.parallels.com/en/129699
     
    Last edited: Jun 7, 2023
  4. faisal3

    faisal3 Bit poster

    Messages:
    6

    If sql server only works on Windows 10, I want to download it instead of Windows 11

    In Parallel, I can't download Windows 10, can you help me?
     
  5. Pavel Merkulov

    Pavel Merkulov Parallels Team

    Messages:
    144
    Windows 10 is no longer supported on Arm computers. Also the version of Windows does not depend on it, sql server does not work on Arm architecture computers.
     
  6. faisal3

    faisal3 Bit poster

    Messages:
    6
    I am in desperate need of sql server

    Do you have any information when the sql server will be supported on Arm?
     
  7. Pavel Merkulov

    Pavel Merkulov Parallels Team

    Messages:
    144
    We advise you to contact Microsoft support team to inquire about when the support for Windows ARM is going to be implemented.
     
  8. GregC13

    GregC13 Bit poster

    Messages:
    2
    I'm in the same boat. I need to be running SQL Server in windows 11 for my Geophysical software which is windows based to run properly. If you find a solution to this in the future, please post clear instructions on how to do it here for future users with the same problem.
     
  9. Carlos Lapao

    Carlos Lapao Parallels Team

    Messages:
    7
    Any problems in running it in docker? you can choose to run it in docker and still access it from any other VM or from the host itself
     
  10. JoseA48

    JoseA48 Bit poster

    Messages:
    1
    do you try with SQL Server 2014 ?? i try with 2022,2020,2016, and amazing with 2014 works fine
     
  11. Troy T.

    Troy T. Bit poster

    Messages:
    6
    Best Answer
    You can absolutely install and run either SQL Server 2019 or SQL Server 2022 Express or Developer Edition along with SQL Server Management Studio v19 within a Windows 11 on ARM installation in Parallels on Apple Silicon Macs. Since SQL Server Management Studio 2019 is 32-bit I had zero issues downloading it directly from Microsoft's website and installing it but SQL Server 2019 Express and Developer Editions as well as SQL Server 2022 Express and Developer Editions wouldn't install. The installer would download and inevitably choke. I searched the web and was starting to think going with a Docker style solution or installing UTM and going the x84-x64 emulation route which would have really hurt performance because of the emulation layer and then I stumbled upon this GitHub repository that contains both batch files that you can execute from the command line as well as the underlying PowerShell scripts they invoke that will download and install SQL Server 2019 Express, SQL Server 2019 Developer Edition, SQL Server 2022 Express or SQL Server 2022 Developer Edition on Windows on ARM installations. Just download and appropriate batch file and powershell script, put them in a temporary folder then open a command prompt as the administrator and execute the batch file. It will download the installation media for the desired version of SQL Server for you and also download and install SQL Server Management Studio 2019 as well.

    I wanted to do a clean install to avoid any errors so I removed SQL Server Management Studio v19 that I had previously downloaded so the scripts could download and install it and not run into any errors along the way. Use the links below to download the appropriate batch file and its associated Power Shell script that it invokes for the version of SQL that you want installed. If you're comfortable running Power Shell scripts you don't need the batch file but if you're not then download the batch file and it's matching Power Shell script to the same temporay folder and run the batch file as an administrator and you'll be good to go.

    https://github.com/jimm98y/MSSQLEXPRESS-M1-Install/tree/main/src
     
    PaoloR5, MennoE1 and DyanM like this.
  12. Troy T.

    Troy T. Bit poster

    Messages:
    6
    The above post should have said "x86-x64" and not "x84-x64". I apologize but as soon as I wanted to post this as quickly as possible to let people know there's an easy way to do it without the need for Docker or an emulation solution. The scripts I linked to above worked like a charm for me!
     
  13. Juveria

    Juveria Bit poster

    Messages:
    1
    Is there a way I can access the SQL Server run using Docker on my M1 from Visual Studio on my Windows Virtual Machine( also run on my M1)?
     
  14. Troy T.

    Troy T. Bit poster

    Messages:
    6
    I can't help you with getting it going through Docker but you can get it going using a Parallels VM if you spin one up on your M1 Mac running the ARM version of Windows 11. There are scripts to let you install SQL 2019 or SQL Server 2022, either the Express or Developer Editions, plus SQL Server Management Studio within the VM.

    I'm assuming there's a specific reason why you want to use Docker versus a Windows on ARM VM to host it but if not then why not go the VM route instead? I prefer that to Docker.
     
  15. FrangellV

    FrangellV Bit poster

    Messages:
    2
    Hi there, I hope you are doing well, I saw you talked about this a long time ago but I wanted to ask you how I can install it cause I am so confused, I downloaded the files and I got two folders, scripts and installers, but on there files there is not execute file to install anything like, how can I install it? I am not that pro, I am beginner on collage, I hope your answer, thanks before hand.
     
  16. Troy T.

    Troy T. Bit poster

    Messages:
    6
    So the only thing you need to do is decide which version you want to install then download the appropriate batch file for that version, save it to a new folder that you create with a short folder name off of the root of the C: drive then either open a command prompt and run it as the administrator and then execute the batch file from the command line.

    The batch files for the various version ms of SQL that you can install are here:

    https://github.com/jimm98y/MSSQLEXPRESS-M1-Install/tree/main/src/Scripts

    Instructions for executing a batch file with Administrator privileges can be found here:

    https://www.wikihow.com/Run-a-Batch-File-from-the-Command-Line-on-Windows

    I don't know how much the scripts have been modified but when I ran them after SQL Server installed each script would then install SQL Server Management Studio v19. The latest version today is v20 but v19 works just fine with SQL Server 2022 and 2019 and in v20 it tries to connect by default using security options you won't have setup so if you want a version of SQL Server Management Studio that "just works" without adjusting the default connection options then stick with SQL Server Management Studio v19. v20 was just released back in March so v19 will be just fine for a long time to come and it will be easier for you to connect to SQL server from it using the default connection options.
     

Share This Page