Enable Linux SQL Server Agent

Short tip this time around. If you are running SQL Server on Linux and connect to it from a Windows system with Management Studio (SSMS), the SQL Agent will  be off. If you right click the Agent in SSMS try to get the properties of it, you will receive a lengthy  error with this included:
SQL Server blocked access to procedure ‘dbo.sp_get_sqlagent_properties’ of component ‘Agent XPs’ because this component is turned off as part of the security configuration for this server.

All good and normal. So how do you turn SQL Agent on?

Continue reading “Enable Linux SQL Server Agent”

Shell Script to control services on Linux Mint (especially SQL Server)

I’ve posted before about how I don’t run certain services on my Linux system all the time, but rather only when I am working with them. For example, Docker, Pentaho applications, and several database servers like MySQL, MariaDB and now Microsoft SQL Server.  The reasons are simple: because I experiment with a variety of technologies, I don’t want to dedicate resources unnecessarily and there may often be conflicts such as web server interfaces using the same ports. So to alleviate some of those problems I generally disable services and start them when necessary.

To do that I usually create Bash scripts to start and stop the services, and save those in a named location in /opt that is associated with the server application. I would have two scripts, one to start and one to stop, but since I’ve had some time lately I’ve worked up a method to do this in one script. Below is a script I drafted to start and stop Microsoft SQL Server on Linux. I saved this to the /opt folder where the SQL Server components are installed and then created a Launcher shortcut to add it to my menu. Now I just select that option in the menu, and I see the current status of the server, and I can start it or shut it down as need be.

Its heavily commented to provide information, so use it as a source for yourself if you are running on Debian based systems.

Continue reading “Shell Script to control services on Linux Mint (especially SQL Server)”

Access a Raspberry Pi with Remote Desktop Protocol (RDP) and REMMINA

    I am a huge proponent of Open Source software, and when I have the choice between a proprietary application or an open source one with similar features, I’ll generally opt for the open source program unless there is a compelling reason not to. In the case of remotely accessing PCs, I prefer to use RDP software over VNC. While RDP is a proprietary protocol developed by Microsoft, and VNC is open source, I find RDP easier to use for remotely accessing GUI based systems. If I need to access a non-GUI system, I do fall back to SSH though.
   Recently I have been experimenting with Raspberry Pi computers. (I am working to setup a Hadoop cluster, and will hopefully write more about that in the future.) The initial setup of the PI’s includes updating the package lists and installing any newer versions of the included software, setting a static IP and then installing xRDP. After that I use my Linux Mint laptop to make any further changes after I have them headless in the rack using REMMINA , which supports SSH, VNC and RDP.
    Installing xRDP on the PIs is pretty straightforward. Here is how to do that:

Continue reading “Access a Raspberry Pi with Remote Desktop Protocol (RDP) and REMMINA”

Map Windows host location to Linux container in Docker

I’ve been working more with Docker on a Windows PC lately. With the more recent versions of Docker, the application runs much better and there is task bar control panel for managing the processes. If you are interested in trying out Docker and don’t have a Linux machine to work with, go download the Windows Stable Community edition which was recently updated to 17.09.0.

Continue reading “Map Windows host location to Linux container in Docker”