SQL Server on Windows 11 - M1 MACS

K

Karthikeyan1

Bit poster
Hi Guys,

I have M1 Mac with Windows 11 installed on Parallels desktop. I have tried to install SQL Server 2019, 2017 & 2014. But, the Database engine services is failing to install. I have attached the screenshots.

Kindly let me know how to solve this issue.

Thanks,
Karthik.
 

Attachments

  • SQL Server firewall warning.png
    SQL Server firewall warning.png
    23.1 KB · Views: 269
  • SQL Server install failure 2.png
    SQL Server install failure 2.png
    28 KB · Views: 286
  • SQL Server install failure.png
    SQL Server install failure.png
    22.7 KB · Views: 267
Sort by date Sort by votes
Karthikeyan1 said:
Hi Guys,

I have M1 Mac with Windows 11 installed on Parallels desktop. I have tried to install SQL Server 2019, 2017 & 2014. But, the Database engine services is failing to install. I have attached the screenshots.

Kindly let me know how to solve this issue.

Thanks,
Karthik.
Click to expand...

Hola, lo que realicé fue instalar el SQL 2014, solo la BD y de 32bits y funciono correctamente. Las otras versiones. no me funcionaron, aunque todas las tenía en 64 bits
 
Upvote 0 Downvote
Is there are any way to install sql server 2019 on windows 11 on mac ?
some vides on youtube say you can install it on docker on mac but I don't know is available to connect to it from parallels ?
 
Upvote 0 Downvote
Hello all, I came across this thread after finding that I could not install SQL 2022 developer edition on M1 Mac and started searching for solution.

I wasn't able to find anything online but I managed to work out a way of doing it so I though I would share that with you now.

The issue appears to be related to Parallels disabling Windows Update which the SQL setup program tries to check before installing.

This can be bypassed as follows;

Create a new windows user to use as the sql service account (make sure to create a local account - this might take a few clicks to get past Microsoft trying to force an online account on you)

Call the account SQLSVC and make sure to give it a secure password.

Download the full SQL Server iso and mount it by double clicking on it in the file explorer.

Open an admin terminal and navigate to the mounted DVD iso. On my system "cd E:"

Then update the following command with details from your individual setup with your Windows host name, your Windows account name and the details of the SQLSVC account you created in to the terminal.

PS E:\> ./setup.exe /Q /IACCEPTSQLSERVERLICENSETERMS /ACTION="install" /FEATURES=SQL,AS,IS /INSTANCENAME=MSSQLSERVER /SQLSVCPASSWORD="SVCACCOUNTPASSWORDHERE" /updatesource="E:" /SQLSVCACCOUNT="WINDOWSHOSTNAME\sqlsvc" /SQLSYSADMINACCOUNTS="WINDOWSHOSTNAME\YOURACCOUNT" /ASSYSADMINACCOUNTS="WINDOWSHOSTNAME\YOURACCOUNT"
 
Upvote 0 Downvote
I tried your suggestion above twice. Each time when the install had finished without any apparent error messages I was left with a system which did not appear to work. When I went into the SQL Server config tool it appeared that no network protocols were listed in the client and or server sections.

Can you elaborate on what your config looks like. I'm using Windows 11 ARM.

Dave
 
Upvote 0 Downvote
I think there are some crucial steps missing in the solutions described here. I've spent this weekend trying to make it work and I've been able to create a script that will install SQL Express on Windows 11 in the Parallels VM. I've verified it works by connecting from the MS SQL Management Studio as well as from an ASP.NET Core application. You can find the script here: https://github.com/jimm98y/MSSQLEXPRESS-M1-Install. Just run the bat file and wait until it completes.
 
Upvote 0 Downvote
Question - if I wanted to use the 2022 Developer version of SQL server what would I need to change the url to which is referenced in the .ps file. I suppose I could manually download it and comment out the download bit in your script but that seems rather untidy when you have created such a slick script.
 
Upvote 0 Downvote
LukasV2 said:
I think there are some crucial steps missing in the solutions described here. I've spent this weekend trying to make it work and I've been able to create a script that will install SQL Express on Windows 11 in the Parallels VM. I've verified it works by connecting from the MS SQL Management Studio as well as from an ASP.NET Core application. You can find the script here: https://github.com/jimm98y/MSSQLEXPRESS-M1-Install. Just run the bat file and wait until it completes.
Click to expand...

Thank you so much for this! It's been so frustrating to have this issue, and this is such an elegant solution. Thank you for your time putting this together!
 
Upvote 0 Downvote
I've just updated the script to fix an issue with the admin account not being able to sign into SQL after the script changes last night.

As for SQL Server Agent, I don't have a clue. I've never used it as all I ever needed was SQL Express which does not even come with the Agent. I've been able to modify the script to include the Developer edition, but I did not play with it yet.
 
Upvote 0 Downvote
You must log in or register to reply here.
Back
Top