Подключение к базе данных в кластере SQL Server

$ sudo apt update && \
sudo apt install python3-pip python-is-python3 && \
pip3 install mssql-cli && \
source ~/.profile

$ export MSSQL_CLI_TELEMETRY_OPTOUT=True

$ mssql-cli -U <имя пользователя> \
          -d <имя базы данных> \
          -S <FQDN хоста>,1433 \
          -N

SELECT @@version;

$ sudo apt update && \
sudo apt install mono-complete nuget && \
sudo nuget update -self && \
nuget install System.Data.SqlClient

using System;
using System.Data.SqlClient;

namespace ConsoleApp1
{
    class Program
    {
        static void Main(string[] args)
        {
            var server = "<FQDN хоста>";
            var database = "<имя базы данных>";
            var uid = "<имя пользователя>";
            var pwd = "<пароль пользователя>";

            var connectionString = String.Format("Server={0},1433;Database={1};Uid={2};Pwd={3};Trusted_Connection=no;Encrypt=no;", server, database, uid, pwd);
            SqlConnection connection = new SqlConnection(connectionString);
            try
            {
                SqlCommand command = new SqlCommand("SELECT @@version;", connection);
                connection.Open();
                using (SqlDataReader reader = command.ExecuteReader())
                {
                    while (reader.Read())
                    {
                        Console.WriteLine(reader[0]);
                    }
                }
            }
            catch (Exception e)
            {
                Console.WriteLine(e);
                throw;
            }
            finally
            {
                connection.Close();
            }
        }
    }
}

$ mcs connect.cs -r:System.Data.dll && \
mono connect.exe

$ sudo apt update && \
sudo apt install mono-complete nuget && \
sudo nuget update -self && \
nuget install System.Data.SqlClient

using System;
using System.Data.SqlClient;

namespace ConsoleApp1
{
    class Program
    {
        static void Main(string[] args)
        {
            var server = "<FQDN хоста>";
            var database = "<имя базы данных>";
            var uid = "<имя пользователя>";
            var pwd = "<пароль пользователя>";

            var connectionString = String.Format("Server={0},1433;Database={1};Uid={2};Pwd={3};Trusted_Connection=no;Encrypt=yes;", server, database, uid, pwd);
            SqlConnection connection = new SqlConnection(connectionString);
            try
            {
                SqlCommand command = new SqlCommand("SELECT @@version;", connection);
                connection.Open();
                using (SqlDataReader reader = command.ExecuteReader())
                {
                    while (reader.Read())
                    {
                        Console.WriteLine(reader[0]);
                    }
                }
            }
            catch (Exception e)
            {
                Console.WriteLine(e);
                throw;
            }
            finally
            {
                connection.Close();
            }
        }
    }
}

$ mcs connect.cs -r:System.Data.dll && \
mono connect.exe

$ sudo apt install default-jdk maven

$ cd ~/ && mkdir -p project/src/java/com/example && cd project/

package com.example;

import java.sql.*;

public class App {

    public static void main(String[] args) {
        String server = "<FQDN хоста>";
        String database = "<имя базы данных>";
        String user = "<имя пользователя>";
        String password = "<пароль пользователя>";

        String connectionString = String.format(
                "jdbc:sqlserver://%s:1433;" +
                "database=%s;" +
                "user=%s;" +
                "password=%s;" +
                "encrypt=false;" +
                "trustServerCertificate=false;" +
                "loginTimeout=30;",
                server, database, user, password);
        try {
            Connection connection = DriverManager.getConnection(connectionString);
            ResultSet q = connection.createStatement().executeQuery("SELECT @@version;");
            if(q.next()) {System.out.println(q.getString(1));}
            connection.close();
        } catch (SQLException throwables) {
            throwables.printStackTrace();
        }
    }
}

$ mvn clean package && \
java -jar target/app-0.1.0-jar-with-dependencies.jar

$ sudo apt install default-jdk maven

$ cd /etc/security && \
sudo keytool -importcert -alias YandexCA -file /usr/local/share/ca-certificates/Yandex/YandexCA.crt -keystore ssl -storepass <пароль хранилища сертификатов> --noprompt

$ cd ~/ && mkdir -p project/src/java/com/example && cd project/

package com.example;

import java.sql.*;

public class App {

    public static void main(String[] args) {
        String server = "<FQDN хоста>";
        String database = "<имя базы данных>";
        String user = "<имя пользователя>";
        String password = "<пароль пользователя>";

        String connectionString = String.format(
                "jdbc:sqlserver://%s:1433;" +
                "database=%s;" +
                "user=%s;" +
                "password=%s;" +
                "encrypt=true;" +
                "trustServerCertificate=false;" +
                "loginTimeout=30;",
                server, database, user, password);
        try {
            Connection connection = DriverManager.getConnection(connectionString);
            ResultSet q = connection.createStatement().executeQuery("SELECT @@version;");
            if(q.next()) {System.out.println(q.getString(1));}
            connection.close();
        } catch (SQLException throwables) {
            throwables.printStackTrace();
        }
    }
}

$ mvn clean package && \
java -jar target/app-0.1.0-jar-with-dependencies.jar

$ go get github.com/denisenkom/go-mssqldb

import (
    _ "github.com/denisenkom/go-mssqldb"
    "database/sql"
)

connStr := `
        server=<FQDN хоста>;
        port=1433;
        database=<имя базы данных>;
        user id=<имя пользователя>;
        password=<пароль пользователя>
`
conn, err := sql.Open("sqlserver", connStr)

$ go get github.com/denisenkom/go-mssqldb

import (
    _ "github.com/denisenkom/go-mssqldb"
    "database/sql"
)

connStr := `
        server=<FQDN хоста>;
        port=1433;
        database=<имя базы данных>;
        user id=<имя пользователя>;
        password=<пароль пользователя>;
        encrypt=true;
        TrustServerCertificate=false
`
conn, err := sql.Open("sqlserver", connStr)

$ sudo apt install unixodbc unixodbc-dev && \
curl https://packages.microsoft.com/keys/microsoft.asc | sudo apt-key add - && \
curl https://packages.microsoft.com/config/ubuntu/20.04/prod.list | sudo tee /etc/apt/sources.list.d/mssql-release.list && \
sudo apt update && \
sudo ACCEPT_EULA=Y apt install msodbcsql17

[sqlserver]

Driver={ODBC Driver 17 for SQL Server};
Server=<FQDN хоста>,1433;
Database=<имя базы данных>;
Uid=<имя пользователя>;
Pwd=<пароль пользователя>;
Encrypt=no;
TrustServerCertificate=no;
Connection Timeout=30;

$ sudo apt install unixodbc unixodbc-dev && \
curl https://packages.microsoft.com/keys/microsoft.asc | sudo apt-key add - && \
curl https://packages.microsoft.com/config/ubuntu/20.04/prod.list | sudo tee /etc/apt/sources.list.d/mssql-release.list && \
sudo apt update && \
sudo ACCEPT_EULA=Y apt install msodbcsql17

[sqlserver]

Driver={ODBC Driver 17 for SQL Server};
Server=<FQDN хоста>,1433;
Database=<имя базы данных>;
Uid=<имя пользователя>;
Pwd=<пароль пользователя>;
Encrypt=yes;
TrustServerCertificate=no;
Connection Timeout=30;