36 articles
Do you want to change SQL Server license key on production server? In this tutorial we’ll walk you through the steps to change product key for any existing SQL Server 2019 / 2017 / 2016 / 2014 installation, without having…
1. Right click on Windows icon then open Windows Powershell(Admin). 2. Run this command to get the hostname of your SQL Server. hostname 3. Run this command to connect to SQL server using single user mode. Replace servername by your…
1. Open a Command Prompt or PowerShell then connect to your SQL Server instance by executing this command: SQLCMD -S server_name\instance_name Note If you’re trying to connect to the default instance, just type SQLCMD. 2. Next, run the following T-SQL…
SSMS 18.11 is the latest general availability (GA) version, you can download it from this link You can download older versions in the below table. VersionBuild numberRelease yearDownload latestSQL Server Management Studio 1818.0.x.x2019DownloadSQL Server Management Studio 1714.0.x.x2017DownloadSQL Server Management Studio…
1. Mount downloaded image file then run the installer (setup.exe). 2. On the left, select install link then install a new SQL Server. 3. Now, you can insert the product key or install free Express edition of SQL Server. You…
Before connecting to a remote SQL Server, you may use SQL Server Management Studio to verify the connections. Take a note of server machine’s IP address. 1. Windows Firewall ->Advanced Settings->Inbound Rules Add a rule to enable TCP port 1433…