Hello everyone, in this article, we will learn how to install Microsoft SQL Server 2022 on Fedora 37. At this time, Fedora 37 is still in the Beta version but I cannot wait to try it on my VMware Workstation. Microsoft SQL Server does not support Fedora 37 natively. So, we need to install it via Docker. SQL Server is a great RDBMS server that can be used for most GIS purposes. Microsoft SQL Server supports spatial databases which can be used to store our spatial data. ArcGIS and QGIS support SQL Server pretty well. So, if you are ArcGIS or QGIS user, you may try this method to install SQL Server on Fedora 37.
Steps to Install SQL Server 2022 on Fedora 37
As I mentioned earlier, SQL Server 2022 does not support Fedora 37 natively. You may check this with the official announcement.
Step 1. Install Docker on Fedora 37
First, we will need to install Docker on Fedora 37. Let,s update Fedora before we install Docker.
sudo dnf updateAnd then, add the Docker repository to Fedora 37
sudo dnf config-manager \
--add-repo \
https://download.docker.com/linux/fedora/docker-ce.repo
Install Docker with this command
sudo dnf install docker-ce docker-ce-cli containerd.io docker-compose-plugin
Wait until the installation completes.
Run the Docker service and check the status:
sudo service docker start
sudo service docker statusMake sure the Docker status is active as follows
At this point, we have successfully installed Docker on Fedora 37. Now let’s continue to the next step.
Step 2. Run SQL Server Container
We can start the SQL Server 2022 container using the command below.
sudo docker run -e "ACCEPT_EULA=Y" -e "MSSQL_SA_PASSWORD=yourStrong(!)Password" -p 1433:1433 -d mcr.microsoft.com/mssql/server:2022-latestDon’t forget to change the yourStrong(!)Password with your actual password. It will download some files from the internet. Make sure you are connected to the internet while installing. Next, we need to configure SQL Server with this command
Once the installation completes, run this command to check if our SQL Server container is up and running
sudo docker ps
Step 3. Connect to SQL Server 2022
So we have successfully installed or run the SQL Server 2022 on Fedora 37 using Docker. Now, we need to try to connect to this new server and create a new database. I am going to use Azure Data Studio. Create a new connection and enter the server IP address, user name, and password. Choose SQL Login on the Authentication type.
Once connected, we can create a new database in our SQL Server 2022. Click New Query and then type this command to create a new database called gis_database.
CREATE DATABASE gis_database
Run it and now we have a new database.
Now we can connect ArcGIS and QGIS to this new SQL Server 2022.
Connect QGIS to SQL Server 2022
Final Thought
Thanks for reading this article on how to install SQL Server 2022 on Fedora 37. I hope you enjoy it and you may want to try it yourself. See you in the next tutorials.
SEAN DONOVAN
March 30, 2023How do we get the Server’s IP address? And how did we get the username and password setup?
iggnaxios
April 6, 2023the user that i’ve used is “sa” and password is that you set in the command line
Amplified Ge
July 5, 2023thank you for sharing!
When creating connection on Azure Data Studio, it throws this error:
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: TCP Provider, error: 40 – Could not open a connection to SQL Server: Could not open a connection to SQL Server)