This guide will help you install Microsoft SQL Server on your VPS server running Debian 12.
Prerequisites
- A VPS server with Debian 12 installed.
- Root access to the server.
Step 1: Update Your System
Before installing SQL Server, ensure your system is up to date. Run the following commands:
sudo apt update
sudo apt upgrade -y
Step 2: Install Required Packages
Install the necessary packages for SQL Server:
sudo apt install curl apt-transport-https software-properties-common -y
Step 3: Import the Public Repository GPG Keys
Run the following command to import the GPG keys:
curl https://packages.microsoft.com/keys/microsoft.asc | sudo apt-key add -
Step 4: Register the Microsoft SQL Server Ubuntu Repository
Add the SQL Server repository:
curl https://packages.microsoft.com/config/debian/12/prod.list | sudo tee /etc/apt/sources.list.d/mssql-release.list
Step 5: Install SQL Server
Update the package list and install SQL Server:
sudo apt update
sudo ACCEPT_EULA=Y apt install -y mssql-server
Step 6: Configure SQL Server
After the installation, run the setup script to configure SQL Server:
sudo /opt/mssql/bin/mssql-conf setup
Follow the prompts to set your SQL Server edition and password.
Step 7: Install SQL Server Command-Line Tools (Optional)
If you want to manage SQL Server from the command line, install the SQL Server tools:
sudo apt install -y mssql-tools unixodbc-dev
To use the tools, add them to your PATH by running:
echo 'export PATH="$PATH:/opt/mssql-tools/bin"' >> ~/.bash_profile
source ~/.bash_profile
Step 8: Verify the Installation
To check if SQL Server is running, use:
systemctl status mssql-server
Conclusion
You have successfully installed Microsoft SQL Server on your VPS server running Debian 12. You can now start using SQL Server for your database needs.
RDS CAL (Client Access License)
Keywords: windows vps uk, windows vps, uk windows vps, windows vps hosting uk, vps windows server, uk vps windows, vps windows, servidor vps windows, vps uk windows, vps with windows, virtual private server windows, windows virtual private server, windows vps server uk, vps for windows, servidores vps windows, vps windows uk, windows vps hosting, vps windows hosting, windows vps server, windows virtual private servers, vps on windows, vps windows servers, cheap windows vps uk, windowsvps, windows desktop vps, buy vps windows, windows server vps, windows 10 vps uk, rds services, rds cal, remote desktop services, remote desktop hosting
#windowsvps #vpshosting #ukvps #virtualserver #windowsvpsuk #vpsserver #hostingvps #cloudvps #windowsvpshosting #cheapvps #vpswithwindows #windowsserver #servervps #vpssolutions #vpswindows #rdscal #remotedesktop #remotedesktopvps #rds #windowsrds