jimm98y / mssqlexpress-m1-install Goto Github PK

How do I know what the sa password is ?

I couldn't download the script so I copied the raw text and made a .bat file out of it. However when I open it, it runs for a few seconds, powershell boots up and closes immediately.

Hi Jimmy,

Thanks for the excellent work, it is much appreciated! I just want to mention that I encountered errors when trying to install any of the developer versions. I figured out what the problem was and I think you must just mention it on your guide. It seems like if the file path to the scripts location is too long, the setup fails. So what I did was 'n created a folder on the C drive, and put the scripts in there. After that the install worked like a charm!

I just thought I should mention!

Have a nice day further!

More than an issue, just wanted to confirm I used the install2022Developer script to install SQLServer successfully on VMWare fusion. I could not see any specific Parallels code in the script, so I thought I'd give it a go.

If it helps anyone, I ran the install2022Developer script (as Administrator) on a vanilla Windows 11 VM.

I removed the installation of SSMS install from the script, as I had seen it installed OK (V19.3) from the download install file (SSMS-Setup-ENU) on a previous instance. Indeed I ran the setup file out of the box after the SQLServer installation and it installed with no issues.

So thanks for putting these scripts together, much appreciated. 👍

Sql 2019 express was flawless. Is there a chance to have script for sql 2014?

Hello I am a noob so I hope you can help.

I just installed windows 11 arm via on my Parrells for Mac (using m1 mac mini)

I tried to open your bat file it flashed and went away, so i attempted to use powershell and copy/paste into there
Everything was installing as it should be for sql server, however towards the end i noticed in powershell there were numerous permission denied for hkey
I can attached a screenshot link below

https://imgur.com/a/H9PKvRW

Anyone finds a way to install the CU updates once SQL is installed?

Hi, I just started a fresh Win 11 Pro installation and tried to install SQL Server 2022 Developer version today.

Made some script revise in order to install Traditional Chinese version. Somehow, the installation is finished successfully. The SQL service is unable to launch at all. Restart the OS or reinstall SQL Server did not solve.

Any suggestion? Thanks.

install2022Developer.ps1.txt

I need to create an SQL database instance with a particular instance name and using mixed mode authorization with a particular (sa) password. The original installer allows you to set this parameters upon creation. Your script defaults create a working database but don't have the proper parameters I need.

I see that the instance name is easily changed with one of your parameters in the script but I didn't see how you were setting the authentication mode or how I would enter a password.

Is there anyway you could document the parameters in your script so that others could create new databases with the proper parameters for their needs. In otherwords, could you please document the key variables in the script that need to be changed to change installation parameters.

I have an example png file that I am attaching of the specific installation page from the original setup file that I need to modify.

Thanks

Please see attach image for error detail. Any help will be appreciated.

Hi, as the title suggests when I try to connect using SSMS I get the following error: "The Certificate Chain Was Issued By An Authority That Is Not Trusted" this problem is easily solved by disabling Encrypt connection from the "Connection Properties" section the problem arises when I have to connect a sql server management that is not SSMS where I can not choose to disable encrypt connection.

So I tried disabling force encryption by following this guide:
https://www.alibabacloud.com/blog/enable-ssl-encryption-for-an-mssql-network-transport-layer_595348#:~:text=On%20the%20SQL%20Server%2C%20click,Certificate%20tab %20and%20click%20OK.

the problem is that I don't find any entry in protocols! this prevents me from both installing an ssl certificate and disabling the "force encryption" item

I hope there is a solution to my problem, in any case congratulations for the work done

SQL server can't be reinstalled; it prompts an error when installed.
I installed the SQL server first, then uninstalled it. I tried to install it again but failed.

does only one know how to fix it

I am getting a bunch of errors and its actually not installing but SSMS is installed, and I thought it. has installed but could not login. So I uninstalled and reinstalled and keep getting the error

Directory: C:\Program Files\Microsoft SQL Server\MSSQL16.SQLEXPRESS\MSSQL

Mode LastWriteTime Length Name

d----- 10/28/2023 5:01 PM Log
d----- 10/28/2023 5:01 PM DATA
Exception calling "SetAccessRule" with "1" argument(s): "Some or all identity references could not be translated."
At C:\Users\christimm\Downloads\MSSQLEXPRESS-M1-Install-main\src\install2022Express.ps1:98 char:1

• $acl.SetAccessRule($accessRule)

•   + CategoryInfo          : NotSpecified: (:) [], MethodInvocationException
    + FullyQualifiedErrorId : IdentityNotMappedException
  
  

Exception calling "SetAccessRule" with "1" argument(s): "Some or all identity references could not be translated."
At C:\Users\christimm\Downloads\MSSQLEXPRESS-M1-Install-main\src\install2022Express.ps1:103 char:1

• $acl.SetAccessRule($accessRule)

•   + CategoryInfo          : NotSpecified: (:) [], MethodInvocationException
    + FullyQualifiedErrorId : IdentityNotMappedException
  
  

Copy-Item : Cannot find path 'C:\Program Files\Microsoft SQL
Server\MSSQL16.SQLEXPRESS\MSSQL\Binn\Templates\master.mdf' because it does not exist.
At C:\Users\christimm\Downloads\MSSQLEXPRESS-M1-Install-main\src\install2022Express.ps1:120 char:1

• Copy-Item -Path "$installedPath\Binn\Templates\master.mdf" -Destinati ...

•   + CategoryInfo          : ObjectNotFound: (C:\Program File...ates\master.mdf:String) [Copy-Item], ItemNotFoundExce
   ption
    + FullyQualifiedErrorId : PathNotFound,Microsoft.PowerShell.Commands.CopyItemCommand
  
  

Copy-Item : Cannot find path 'C:\Program Files\Microsoft SQL
Server\MSSQL16.SQLEXPRESS\MSSQL\Binn\Templates\mastlog.ldf' because it does not exist.
At C:\Users\christimm\Downloads\MSSQLEXPRESS-M1-Install-main\src\install2022Express.ps1:121 char:1

• Copy-Item -Path "$installedPath\Binn\Templates\mastlog.ldf" -Destinat ...

•   + CategoryInfo          : ObjectNotFound: (C:\Program File...tes\mastlog.ldf:String) [Copy-Item], ItemNotFoundExce
   ption
  

` Exception calling "SetAccessRule" with "1" argument(s): "Some or all identity references could not be translated."
At C:\Users\ngallen\AppData\Local\Temp\Temp1_MSSQLEXPRESS-M1-Install-main.zip\MSSQLEXPRESS-M1-Install-main\src\install2
022Developer.ps1:98 char:1

• $acl.SetAccessRule($accessRule)

•   + CategoryInfo          : NotSpecified: (:) [], MethodInvocationException
    + FullyQualifiedErrorId : IdentityNotMappedException
  
  

Exception calling "SetAccessRule" with "1" argument(s): "Some or all identity references could not be translated."
At C:\Users\ngallen\AppData\Local\Temp\Temp1_MSSQLEXPRESS-M1-Install-main.zip\MSSQLEXPRESS-M1-Install-main\src\install2
022Developer.ps1:103 char:1

• $acl.SetAccessRule($accessRule)

•   + CategoryInfo          : NotSpecified: (:) [], MethodInvocationException
    + FullyQualifiedErrorId : IdentityNotMappedException
  
  

Copy-Item : Cannot find path 'C:\Program Files\Microsoft SQL
Server\MSSQL16.MSSQLSERVER\MSSQL\Binn\Templates\master.mdf' because it does not exist.
At C:\Users\ngallen\AppData\Local\Temp\Temp1_MSSQLEXPRESS-M1-Install-main.zip\MSSQLEXPRESS-M1-Install-main\src\install2
022Developer.ps1:120 char:1

• Copy-Item -Path "$installedPath\Binn\Templates\master.mdf" -Destinati ...

•   + CategoryInfo          : ObjectNotFound: (C:\Program File...ates\master.mdf:String) [Copy-Item], ItemNotFoundExce
   ption
    + FullyQualifiedErrorId : PathNotFound,Microsoft.PowerShell.Commands.CopyItemCommand                                 Writing web request                                                                                                                                  (Number of bytes written: 86Copy-Item : Cannot find path 'C:\Program Files\Microsoft SQL                                                                                         Server\MSSQL16.MSSQLSERVER\MSSQL\Binn\Templates\mastlog.ldf' because it does not exist.                                 ESS-M1-Install-main\src\install2
  

022Developer.ps1:121 char:1

• Copy-Item -Path "$installedPath\Binn\Templates\mastlog.ldf" -Destinat ...

•   + CategoryInfo          : ObjectNotFound: (C:\Program File...tes\mastlog.ldf:String) [Copy-Item], ItemNotFoundExce
   ption
    + FullyQualifiedErrorId : PathNotFound,Microsoft.PowerShell.Commands.CopyItemCommand
  
  

New-ItemProperty : Cannot find path 'HKLM:\SOFTWARE\Microsoft\Microsoft SQL
Server\MSSQL16.MSSQLSERVER\MSSQLServer\Parameters' because it does not exist.
At C:\Users\ngallen\AppData\Local\Temp\Temp1_MSSQLEXPRESS-M1-Install-main.zip\MSSQLEXPRESS-M1-Install-main\src\install2
022Developer.ps1:126 char:1

• New-ItemProperty -Path $registryPath -Name $name -Value $value -Force

•   + CategoryInfo          : ObjectNotFound: (HKLM:\SOFTWARE\...rver\Parameters:String) [New-ItemProperty], ItemNotFo
   undException
    + FullyQualifiedErrorId : PathNotFound,Microsoft.PowerShell.Commands.NewItemPropertyCommand
  
  

New-ItemProperty : Cannot find path 'HKLM:\SOFTWARE\Microsoft\Microsoft SQL
Server\MSSQL16.MSSQLSERVER\MSSQLServer\Parameters' because it does not exist.
At C:\Users\ngallen\AppData\Local\Temp\Temp1_MSSQLEXPRESS-M1-Install-main.zip\MSSQLEXPRESS-M1-Install-main\src\install2
022Developer.ps1:129 char:1

• New-ItemProperty -Path $registryPath -Name $name -Value $value -Force

•   + CategoryInfo          : ObjectNotFound: (HKLM:\SOFTWARE\...rver\Parameters:String) [New-ItemProperty], ItemNotFo
   undException
    + FullyQualifiedErrorId : PathNotFound,Microsoft.PowerShell.Commands.NewItemPropertyCommand
  
  

New-ItemProperty : Cannot find path 'HKLM:\SOFTWARE\Microsoft\Microsoft SQL
Server\MSSQL16.MSSQLSERVER\MSSQLServer\Parameters' because it does not exist.
At C:\Users\ngallen\AppData\Local\Temp\Temp1_MSSQLEXPRESS-M1-Install-main.zip\MSSQLEXPRESS-M1-Install-main\src\install2
022Developer.ps1:132 char:1

• New-ItemProperty -Path $registryPath -Name $name -Value $value -Force

•   + CategoryInfo          : ObjectNotFound: (HKLM:\SOFTWARE\...rver\Parameters:String) [New-ItemProperty], ItemNotFo
   undException
    + FullyQualifiedErrorId : PathNotFound,Microsoft.PowerShell.Commands.NewItemPropertyCommand`
  

I use the script and I am be able to install SQL Developer 2022 on my MacbookPRO M2 MAX, and it works ok.

I am not be able to install the FEATURES REPLICATION, it is possible ?

SQL Agent is not installed with the Developer version of the SQL Server.

The download that you've placed in your scripts depends on my language, for example: I'm from Italy, and if I go on that link that you placed in the ps1 script, it will automatically download the _ITA version and not the _ENU.

I suggest to specify that users need to specify their language, instead the installer will not work because it cannot find the directory.

Mac Mini M1 on Ventura 13.1
Parallels Desktop 18.1.1
Windows11_InsiderPreview_Client_ARM64_en-us_25267
Updated

Double click on any .bat file of the src, CMD is opened and closed in half second.

Here the failures I get when running the script:

Operation finished with result: Success Download erfolgreich! Download Directory
C:\MSSQLEXPRESS-M1-Install-main\src\Temp

Start-Process : Dieser Befehl kann aufgrund des folgenden Fehlers nicht ausgeführt werden: Das System kann die
angegebene Datei nicht finden.
In C:\MSSQLEXPRESS-M1-Install-main\src\install2019Express.ps1:72 Zeichen:5

• Start-Process -FilePath $fullInstallerPath -ArgumentList "/q" -Wa ...
  

• ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
  

  • CategoryInfo : InvalidOperation: (:) [Start-Process], InvalidOperationException
  • FullyQualifiedErrorId : InvalidOperationException,Microsoft.PowerShell.Commands.StartProcessCommand

Start-Process : Dieser Befehl kann aufgrund des folgenden Fehlers nicht ausgeführt werden: Das System kann die
angegebene Datei nicht finden.
In C:\MSSQLEXPRESS-M1-Install-main\src\install2019Express.ps1:79 Zeichen:1

• Start-Process -FilePath "$setupFolderPath/SETUP.EXE" -ArgumentList $s ...

•   + CategoryInfo          : InvalidOperation: (:) [Start-Process], InvalidOperationException
    + FullyQualifiedErrorId : InvalidOperationException,Microsoft.PowerShell.Commands.StartProcessCommand
  
  

Start-Process : Dieser Befehl kann aufgrund des folgenden Fehlers nicht ausgeführt werden: Das System kann die
angegebene Datei nicht finden.
In C:\MSSQLEXPRESS-M1-Install-main\src\install2019Express.ps1:82 Zeichen:1

• Start-Process -FilePath "$setupFolderPath/SETUP.EXE" -ArgumentList $s ...

•   + CategoryInfo          : InvalidOperation: (:) [Start-Process], InvalidOperationException
    + FullyQualifiedErrorId : InvalidOperationException,Microsoft.PowerShell.Commands.StartProcessCommand
  
  

New-Item : Ein Element mit dem angegebenen Namen "C:\Program Files\Microsoft SQL Server\MSSQL15.SQLEXPRESS\MSSQL\Log"
ist bereits vorhanden.
In C:\MSSQLEXPRESS-M1-Install-main\src\install2019Express.ps1:88 Zeichen:1

• New-Item -Path $logDir -ItemType Directory

•   + CategoryInfo          : ResourceExists: (C:\Program File...PRESS\MSSQL\Log:String) [New-Item], IOException
    + FullyQualifiedErrorId : DirectoryExist,Microsoft.PowerShell.Commands.NewItemCommand
  
  

New-Item : Ein Element mit dem angegebenen Namen "C:\Program Files\Microsoft SQL Server\MSSQL15.SQLEXPRESS\MSSQL\DATA"
ist bereits vorhanden.
In C:\MSSQLEXPRESS-M1-Install-main\src\install2019Express.ps1:91 Zeichen:1

• New-Item -Path $dataDir -ItemType Directory

•   + CategoryInfo          : ResourceExists: (C:\Program File...RESS\MSSQL\DATA:String) [New-Item], IOException
    + FullyQualifiedErrorId : DirectoryExist,Microsoft.PowerShell.Commands.NewItemCommand
  
  

Ausnahme beim Aufrufen von "SetAccessRule" mit 1 Argument(en): "Manche oder alle Identitätsverweise konnten nicht
übersetzt werden."
In C:\MSSQLEXPRESS-M1-Install-main\src\install2019Express.ps1:98 Zeichen:1

• $acl.SetAccessRule($accessRule)

•   + CategoryInfo          : NotSpecified: (:) [], MethodInvocationException
    + FullyQualifiedErrorId : IdentityNotMappedException
  
  

Ausnahme beim Aufrufen von "SetAccessRule" mit 1 Argument(en): "Manche oder alle Identitätsverweise konnten nicht
übersetzt werden."
In C:\MSSQLEXPRESS-M1-Install-main\src\install2019Express.ps1:103 Zeichen:1

• $acl.SetAccessRule($accessRule)

•   + CategoryInfo          : NotSpecified: (:) [], MethodInvocationException
    + FullyQualifiedErrorId : IdentityNotMappedException                                                                                                                                                                                        Copy-Item : Der Pfad "C:\Program Files\Microsoft SQL Server\MSSQL15.SQLEXPRESS\MSSQL\Binn\Templates\master.mdf" kann    nicht gefunden werden, da er nicht vorhanden ist.                                                                       In C:\MSSQLEXPRESS-M1-Install-main\src\install2019Express.ps1:120 Zeichen:1
  

• Copy-Item -Path "$installedPath\Binn\Templates\master.mdf" -Destinati ...

•   + CategoryInfo          : ObjectNotFound: (C:\Program File...ates\master.mdf:String) [Copy-Item], ItemNotFoundExce
   ption
    + FullyQualifiedErrorId : PathNotFound,Microsoft.PowerShell.Commands.CopyItemCommand
  
  

Copy-Item : Der Pfad "C:\Program Files\Microsoft SQL Server\MSSQL15.SQLEXPRESS\MSSQL\Binn\Templates\mastlog.ldf" kann
nicht gefunden werden, da er nicht vorhanden ist.
In C:\MSSQLEXPRESS-M1-Install-main\src\install2019Express.ps1:121 Zeichen:1

• Copy-Item -Path "$installedPath\Binn\Templates\mastlog.ldf" -Destinat ...

•   + CategoryInfo          : ObjectNotFound: (C:\Program File...tes\mastlog.ldf:String) [Copy-Item], ItemNotFoundExce
   ption
    + FullyQualifiedErrorId : PathNotFound,Microsoft.PowerShell.Commands.CopyItemCommand
  
  

New-ItemProperty : Der Pfad "HKLM:\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL15.SQLEXPRESS\MSSQLServer\Parameters"
kann nicht gefunden werden, da er nicht vorhanden ist.
In C:\MSSQLEXPRESS-M1-Install-main\src\install2019Express.ps1:126 Zeichen:1

• New-ItemProperty -Path $registryPath -Name $name -Value $value -Force

•   + CategoryInfo          : ObjectNotFound: (HKLM:\SOFTWARE\...rver\Parameters:String) [New-ItemProperty], ItemNotFo
   undException
    + FullyQualifiedErrorId : PathNotFound,Microsoft.PowerShell.Commands.NewItemPropertyCommand
  
  

New-ItemProperty : Der Pfad "HKLM:\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL15.SQLEXPRESS\MSSQLServer\Parameters"
kann nicht gefunden werden, da er nicht vorhanden ist.
In C:\MSSQLEXPRESS-M1-Install-main\src\install2019Express.ps1:129 Zeichen:1

• New-ItemProperty -Path $registryPath -Name $name -Value $value -Force

•   + CategoryInfo          : ObjectNotFound: (HKLM:\SOFTWARE\...rver\Parameters:String) [New-ItemProperty], ItemNotFo
   undException
    + FullyQualifiedErrorId : PathNotFound,Microsoft.PowerShell.Commands.NewItemPropertyCommand
  
  

New-ItemProperty : Der Pfad "HKLM:\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL15.SQLEXPRESS\MSSQLServer\Parameters"
kann nicht gefunden werden, da er nicht vorhanden ist.
In C:\MSSQLEXPRESS-M1-Install-main\src\install2019Express.ps1:132 Zeichen:1

• New-ItemProperty -Path $registryPath -Name $name -Value $value -Force

•   + CategoryInfo          : ObjectNotFound: (HKLM:\SOFTWARE\...rver\Parameters:String) [New-ItemProperty], ItemNotFo
   undException
    + FullyQualifiedErrorId : PathNotFound,Microsoft.PowerShell.Commands.NewItemPropertyCommand
  
  

Start-Process : Dieser Befehl kann aufgrund des folgenden Fehlers nicht ausgeführt werden: Das System kann die
angegebene Datei nicht finden.
In C:\MSSQLEXPRESS-M1-Install-main\src\install2019Express.ps1:136 Zeichen:1

• Start-Process -FilePath "$setupFolderPath/SETUP.EXE" -ArgumentList "/ ...

•   + CategoryInfo          : InvalidOperation: (:) [Start-Process], InvalidOperationException
    + FullyQualifiedErrorId : InvalidOperationException,Microsoft.PowerShell.Commands.StartProcessCommand
  
  

Der Name für den Dienst ist ungültig.

Sie erhalten weitere Hilfe, wenn Sie NET HELPMSG 2185 eingeben.

SQL Installation completed, press any key to exit

Hi,

Does this work with the Macbook Pro 2023 M2 chip?

The ps1 file is located in the downloads folder of my Mac, but I get this error:

Start-Process : This command cannot be run due to the error: The system cannot find the file specified.
At \Mac\Home\Downloads\install2022Express.ps1:136 char:1

• Start-Process -FilePath "$setupFolderPath/SETUP.EXE" -ArgumentList "/ ...

•   + CategoryInfo          : InvalidOperation: (:) [Start-Process], InvalidOperationException
    + FullyQualifiedErrorId : InvalidOperationException,Microsoft.PowerShell.Commands.StartProcessCommand
  

jimm98y - I have used your scripts to try to install all versions except 2022 Express, and I have been unable to get TCPIP on 1433 to work. When researching - it looks like the registry entries for the instance are missing (I do see them on my Windows 10 Intel VM) - Have you seen this issue (Everything else seems to install correctly)?

If you get path errors like:
Invalid value 'Microsoft.PowerShell.Core\FileSystem::\\Mac\Hnstall-main\src\Temp' for setting 'MediaPath': The specified directory path, "Microsoft.PowerShell.Core\FileSystem::\\Ma1-Install-main\src\Temp", is a relative path. However, the directory path must be an absolute path. Specify an absolute

then you need to move the downloaded script to a location where the path looks like a normal Windows path such as
C:\Users\YOUR_USER\Downloads
If I go to This PC -> Downloads in parallels the path is like this \\Mac\Hnstall-main ... if I go to This PC -> Local Disk (C:) -> Users -> Your Username -> Downloads then the path is like this C:\Users\YOUR_USER\Downloads

Huge thank you to @jimm98y for creating this script and sharing it.
I installed SQL Server successfully on Mac with M1 chip

Hi, first of all thank you very much for putting these script together, it's absolutely fantastic work.
Everything is good, except I cannot turn on filestream. I've tried all the usual options, and I'm just wondering why this might not be working. I'm sure there are limits to what is achieveable here, but do you have any ideas even it's even a reasonable ask to try and get it working?

New-Item : 具有指定名称 C:\Program Files\Microsoft SQL Server\MSSQL16.MSSQLSERVER\MSSQL\Log 的项已存在。
所在位置 C:\Soft\MSSQLEXPRESS-M1-Install\src\install2022Developer.ps1:88 字符: 1

• New-Item -Path $logDir -ItemType Directory

•   + CategoryInfo          : ResourceExists: (C:\Program File...ERVER\MSSQL\Log:String) [New-Item], IOException
    + FullyQualifiedErrorId : DirectoryExist,Microsoft.PowerShell.Commands.NewItemCommand
  
  

New-Item : 具有指定名称 C:\Program Files\Microsoft SQL Server\MSSQL16.MSSQLSERVER\MSSQL\DATA 的项已存在。
所在位置 C:\Soft\MSSQLEXPRESS-M1-Install\src\install2022Developer.ps1:91 字符: 1

• New-Item -Path $dataDir -ItemType Directory

•   + CategoryInfo          : ResourceExists: (C:\Program File...RVER\MSSQL\DATA:String) [New-Item], IOException
    + FullyQualifiedErrorId : DirectoryExist,Microsoft.PowerShell.Commands.NewItemCommand
  
  

Copy-Item : 找不到路径“C:\Program Files\Microsoft SQL Server\MSSQL16.MSSQLSERVER\MSSQL\Binn\Templates\master.mdf”，因为
该路径不存在。
所在位置 C:\Soft\MSSQLEXPRESS-M1-Install\src\install2022Developer.ps1:120 字符: 1

• Copy-Item -Path "$installedPath\Binn\Templates\master.mdf" -Destinati ...

•   + CategoryInfo          : ObjectNotFound: (C:\Program File...ates\master.mdf:String) [Copy-Item], ItemNotFoundExce
   ption
    + FullyQualifiedErrorId : PathNotFound,Microsoft.PowerShell.Commands.CopyItemCommand
  
  

Copy-Item : 找不到路径“C:\Program Files\Microsoft SQL Server\MSSQL16.MSSQLSERVER\MSSQL\Binn\Templates\mastlog.ldf”，因为该路径不存在。
所在位置 C:\Soft\MSSQLEXPRESS-M1-Install\src\install2022Developer.ps1:121 字符: 1

• Copy-Item -Path "$installedPath\Binn\Templates\mastlog.ldf" -Destinat ...

•   + CategoryInfo          : ObjectNotFound: (C:\Program File...tes\mastlog.ldf:String) [Copy-Item], ItemNotFoundExce
   ption
    + FullyQualifiedErrorId : PathNotFound,Microsoft.PowerShell.Commands.CopyItemCommand
  
  

New-ItemProperty : 找不到路径“HKLM:\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL16.MSSQLSERVER\MSSQLServer\Parameters”
，因为该路
径不存在。
所在位置 C:\Soft\MSSQLEXPRESS-M1-Install\src\install2022Developer.ps1:126 字符: 1

• New-ItemProperty -Path $registryPath -Name $name -Value $value -Force

•   + CategoryInfo          : ObjectNotFound: (HKLM:\SOFTWARE\...rver\Parameters:String) [New-ItemProperty], ItemNotFo
   undException
    + FullyQualifiedErrorId : PathNotFound,Microsoft.PowerShell.Commands.NewItemPropertyCommand                                                                                                                                                 New-ItemProperty : 找找不不到到路路径径“HKLM:\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL16.MSSQLSERVER\MSSQLServer\Parameters” ，，因因为为该该路路                                                                                          
  

所在位置 C:\Soft\MSSQLEXPRESS-M1-Install\src\install2022Developer.ps1:129 字符: 1

• New-ItemProperty -Path $registryPath -Name $name -Value $value -Force

•   + CategoryInfo          : ObjectNotFound: (HKLM:\SOFTWARE\...rver\Parameters:String) [New-ItemProperty], ItemNotFo
   undException
    + FullyQualifiedErrorId : PathNotFound,Microsoft.PowerShell.Commands.NewItemPropertyCommand
  
  

New-ItemProperty : 找不到路径“HKLM:\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL16.MSSQLSERVER\MSSQLServer\Parameters”
，因为该路
径不存在。
所在位置 C:\Soft\MSSQLEXPRESS-M1-Install\src\install2022Developer.ps1:132 字符: 1

• New-ItemProperty -Path $registryPath -Name $name -Value $value -Force

•   + CategoryInfo          : ObjectNotFound: (HKLM:\SOFTWARE\...rver\Parameters:String) [New-ItemProperty], ItemNotFo
   undException
    + FullyQualifiedErrorId : PathNotFound,Microsoft.PowerShell.Commands.NewItemPropertyCommand
  

Hello and thanks for the work you are doing!
Although the installation of sql server ends successfully I can't access any database I'm not an expert but I think it's due to the fact that "sql server browser" crashes.
even if I try to run it forcibly after a while it crashes.

I'll paste the response of your script at the end of the installation:

`Microsoft (R) SQL Server Installer
Copyright (c) 2022 Microsoft. All rights reserved.
Operation finished with result: Success Download successful! Download Directory
C:\Users\giuseppe\Music\src\Temp

Directory: C:\Program Files\Microsoft SQL Server\MSSQL16.SQLEXPRESS\MSSQL

Mode LastWriteTime Length Name

d----- 01/02/2023 13:16 Log
d----- 01/02/2023 13:16 DATA
VERBOSE: Performing the operation "Copy File" on target "Item: C:\Program Files\Microsoft SQL
Server\MSSQL16.SQLEXPRESS\MSSQL\Binn\Templates\master.mdf Destination: C:\Program Files\Microsoft SQL
Server\MSSQL16.SQLEXPRESS\MSSQL\DATA\master.mdf".
VERBOSE: Performing the operation "Copy File" on target "Item: C:\Program Files\Microsoft SQL
Server\MSSQL16.SQLEXPRESS\MSSQL\Binn\Templates\mastlog.ldf Destination: C:\Program Files\Microsoft SQL
Server\MSSQL16.SQLEXPRESS\MSSQL\DATA\mastlog.ldf".

SQLArg0 : -dC:\Program Files\Microsoft SQL Server\MSSQL16.SQLEXPRESS\MSSQL\DATA\master.mdf
PSPath : Microsoft.PowerShell.Core\Registry::HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL
Server\MSSQL16.SQLEXPRESS\MSSQLServer\Parameters
PSParentPath : Microsoft.PowerShell.Core\Registry::HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL
Server\MSSQL16.SQLEXPRESS\MSSQLServer
PSChildName : Parameters
PSDrive : HKLM
PSProvider : Microsoft.PowerShell.Core\Registry

SQLArg1 : -eC:\Program Files\Microsoft SQL Server\MSSQL16.SQLEXPRESS\MSSQL\Log\ERRORLOG
PSPath : Microsoft.PowerShell.Core\Registry::HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL
Server\MSSQL16.SQLEXPRESS\MSSQLServer\Parameters
PSParentPath : Microsoft.PowerShell.Core\Registry::HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL
Server\MSSQL16.SQLEXPRESS\MSSQLServer
PSChildName : Parameters
PSDrive : HKLM
PSProvider : Microsoft.PowerShell.Core\Registry

SQLArg2 : -lC:\Program Files\Microsoft SQL Server\MSSQL16.SQLEXPRESS\MSSQL\DATA\mastlog.ldf
PSPath : Microsoft.PowerShell.Core\Registry::HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL
Server\MSSQL16.SQLEXPRESS\MSSQLServer\Parameters
PSParentPath : Microsoft.PowerShell.Core\Registry::HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL
Server\MSSQL16.SQLEXPRESS\MSSQLServer
PSChildName : Parameters
PSDrive : HKLM
PSProvider : Microsoft.PowerShell.Core\Registry

Servizio SQL Server (SQLEXPRESS) in fase di avvio .
Avvio del servizio SQL Server (SQLEXPRESS) riuscito.

SQL Installation completed, press any key to exit`

This part ist solved. See my last comment

Installed 2022 Developer successfully on a MBP M3. SSMS installed too without issue. I was able to use the Window Authentication account to enable mixed mode auth with sa and pw.

My primary issue is that SQL Server Configuration Manager only shows the 32bit entries (64bit missing). This may be expected in this environment but prevents access to the server configuration such as changing from the default port. Apologies if this is expected and thus not an issue.

My secondary issue now is that Red-Gate SQL Compare v14.10 will not connect to a cloud (AWS) server. It fails with a failed "named pipes" connection even though I am clearly using an alias that uses TCP. SSMS can connect to the same cloud server with the same alias without issue. Again, I worry that the SQL Compare product is requiring the missing 64bit Alias in SSCM definition but I cannot set it. Not smart enough to know of these are related but just suspect.

I was able to use each of the scripts here to install SQL Server 2019 Express, 2019 Developer, 2022 Express and 2022 Developer successfully on Windows 11 on ARM in Parallels Desktop on a new M3 MacBook Pro. I went the batch file route to run the scripts and everything downloaded and installed without any issues. Uninstallation from the Control Panel was easy for each of the components that get installed as well including SSMS as well as individual components that make up a SQL Server Express or Developer installation.

I don't have an M1 or M2 Mac to test with but have this new M3 Mac and a lot of experience working with SQL Server on Windows and everything I've tested so far with SQL installed on Windows on x64 hardware works with Windows on ARM when SQL Server is installed using these scripts. These scripts were life savers for those like me who need SQL Server working on Windows on ARM to use their Mac to get SQL development related work done on Mac's with Apple Silicon.

Hi,

Is it possible add support to install SQL Server 2022/2019 Developer version?
It fail to install via simply rename SQLExpr to SQLDev in the .ps file. Especially when the process comes to copy master.mdf, there is no existing path to find any .mdf file. =(

Thanks.

Attached file is the modified version. However, it looks like something is missing here.
install2022.ps1.txt