How to Install SQL Server Express Version Automatically through PowerShell

KLCWEB

1. Access the Windows server via RDP

RDP - KLCWEB

2. Open Windows PowerShell ISE

Enter ise in the Search box. And then click Windows PowerShell ISE to open it.

3. Run the script

Copy the following script to the PowerShell ISE command line and then press Enter to run the script.

[Net.ServicePointManager]::SecurityProtocol = [Net.SecurityProtocolType]::Tls12;IEX (New-Object Net.WebClient).DownloadString('https://gitlab.cloudclusters.net/public_package/dbm-script/raw/master/InstallSQLServer_Express.ps1'); 

In the pop-up window, enter the SQL Server sa password and select the SQL ServerVersion you want to install. Then, click OK.

The entire installation process is fully automatic, so you don’t need to do anything else. It may take up to 60 minutes to complete the installation.

4. Check if the installation is successful

Tagged : /