Skip to content

Microsoft SQL Server Installation

Lean's edited this page Oct 18, 2024 · 2 revisions

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

Clone this wiki locally