A while ago, I published a post to slipstream the SQL Server 2008 media. It is time to update it for SQL Server 2019. Fortunately the setup.exe hasn’t changed much, so it is still a matter of: Copying the RTM ISO on a read-write filesystem Unpack the Cumulative update of […]
While trying to install new instance of SQL Server using command line and the ConfigurationFile.ini unattended answer file, you may receive the following error message : MEDIALAYOUT in SQL Server ConfigurationFile.Ini Don’t waste your time searching in different documentations about the allowed keywords for the configuration file. This error means […]
Although the Remote Management is enabled by default starting with Windows Server 2012, the RDP access isn’t. To enable RDP with Powershell, you have two steps to perform: Enable the RDP Access Enable the inbound firewall rules Here’s the code:
|
1 2 3 4 5 6 |
# 1. Enable Remote Desktop (Get-WmiObject Win32_TerminalServiceSetting -Namespace root\cimv2\TerminalServices).SetAllowTsConnections(1,1) (Get-WmiObject -Class "Win32_TSGeneralSetting" -Namespace root\cimv2\TerminalServices -Filter "TerminalName='RDP-tcp'").SetUserAuthenticationRequired(0) # 2. Enable the firewall rule Enable-NetFirewallRule -DisplayGroup "Remote Desktop" |
The second line allows you to specify if you […]
Usually you set up the regional settings at installation time by using localized OS Version or unattended.xml. However sometimes you discover after installation that some script from your customer run under the system context needs different settings. In this case changing the system regional settings after installation using the command-line […]
