Friday, March 31, 2017

Linux for SQL DBA: Access like a Pro.

In all my previous posts about SQL Server on Linux I always connected to Linux box locally, but in production environment it is almost never the case.

So, how Linux gurus connect to their remote servers?

They use small utility called "PUTTY".

It is easy to get it. Just google "putty download" and you'l get it on the top:

 On the download page choose edition you prefer:

After you install that utility and run it you have to get something like this:

IMPORTANT: In order to be able to connect to your Linux box you have to have SSH client installed. for Ubuntu Linux you can use following installation command:
sudo apt-get install openssh-server openssh-client

After successful installation of SSH client you almost can connect to your box, you just have to know your Linux machine IP address.
If you do not know it, just type "ifconfig" in your terminal get it:

If you have more than one adapter as I do, use the one you can ping from your machine.
Enter that ip address in Putty, make sure you have SSH connection type selected and then press "Open" button:

Then you are supposed to get connection prompt like this:

After you enter your credentials and successfully connected you can verify that you are really in by reading SQL Server data catalog and running "sqlcmd -S localhost -U sa" command:
sudo ls -l /var/opt/mssql/data

The only difference connecting with "Putty" that in order to get another terminal window you have to run another instance of "Putty" window:

No comments:

Post a Comment