Microsoft SQL Server Installation - LeandroTheDev/arch_linux GitHub Wiki

Downloading

• sudo pacman -S libatomic_ops libc++ gdb openssl-1.1 sssd
• auracle clone mssql-server
• auracle clone libldap24

Setup

Just learning? select the developer option

• sudo /opt/mssql/bin/mssql-conf setup

Finish

Optional: Changing ports

• sudo vim /var/opt/mssql/mssql.conf

[network]
tcpport=3308

Start the sql server

• sudo systemctl start mssql-server

Run after boot

• sudo systemctl enable mssql-server

Using

• auracle clone msodbcsql
• sqlcmd -S localhost,3308 -U sa -P 'passwordyousetpreviously' -C

Creating database

CREATE DATABASE MYDATABASE;
GO

View all databases

SELECT name FROM sys.databases;
GO

Creating user

CREATE LOGIN username 
WITH PASSWORD = 'secretpassword';
GO

USE MYDATABASE;
GO

CREATE USER username FOR LOGIN username;
GO

EXEC sp_addrolemember 'db_owner', 'username';
GO