From the course: SQL Server Containerization: Modern Deployment Strategies for Data-Driven Organizations
Join today to access over 25,500 courses taught by industry experts.
Accessing a SQL Server on Linux - SQL Server Tutorial
From the course: SQL Server Containerization: Modern Deployment Strategies for Data-Driven Organizations
Accessing a SQL Server on Linux
- [Instructor] When it comes to accessing a SQL Server running on Linux, you should remember that SQL Server on Linux is SQL Server on Windows at its core. So same considerations and restrictions apply. How do you authenticate? Is there a local firewall on your client or the server or even a corporate firewall in between? Which tools do you want to use? Because just as an accessing SQL Server running on Windows, you can use the mssql-cli, sqlcmd, or Azure Data Studio, and all of those even run on Linux, so there isn't even the need for a Windows client. But of course, you can also use Management Studio, for example, which does not run on Linux, but of course can access any SQL Server running on Linux. Let's first access our SQL Server on Linux from the Linux box directly. I will secure share into my box again and add the Microsoft SQL tools to my repo. I'll update my package manager's cache, and I can then install the mssql tools through my package manager. To make sure I can use them…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.