Ask Ubuntu
Ask Ubuntu

Questions tagged [mssql]

Questions regarding the Microsoft SQL database server, its tools and services.

Microsoft SQL Server is a relational database management system developed by Microsoft. SQL Server uses as its primary query languages T-SQL and ANSI SQL.

Source: Wikipedia

Links :

  1. Official page
  2. Wikipedia
96 questions
40
votes
8 answers

Graphical MS-SQL Clients for a Ubuntu Desktop

I occasionally need to do minor edits to a MS-SQL database running on one of our servers... I'm using an evaluation of DbVisualizer at the moment to do this (it's Java based and uses something called the jTDS JDBC driver to talk to MS-SQL)...…
Lantizia
  • 443
21
votes
4 answers

Can I install SQL Server Management Studio on Ubuntu 16.04?

Can I install SQL Server Management Studio on Ubuntu 16.04?
Anas Shamsi
  • 313
20
votes
5 answers

Unable to install msodbcsql17 on Ubuntu 18.04

I installed the sqlserver based on the Microsoft Documentation. The following commands are executed correctly. wget -qO- https://packages.microsoft.com/keys/microsoft.asc | sudo apt-key add - sudo add-apt-repository "$(wget -qO-…
Hossein Bajan
  • 303
17
votes
3 answers

How do I install MSSQL Server and/or Tools for Linux on 16.04?

This post was created to try and be a 'catch all' canonical question/answer pair for 'How do I Install MSSQL Server' and 'How Do I Install MSSQL Server Tools' questions. I am looking to set up MS SQL Server for Linux, and quite possibly its tools…
Thomas Ward
  • 78,878
16
votes
2 answers

MSSQL on Ubuntu, can't get it to install?

Recently MS launched mssql-server for Linux. I'd like to use it but I can't manange to run sudo apt-get install -y mssql-server It says E: Unable to locate package mssql-server Current Ubuntu is 16.04.1 LTS. I tried to follow [these instructions…
DocPanic
  • 161
11
votes
2 answers

How to fix Microsoft ODBC Driver 17 for SQL Server : SSL Provider ssl_choose_client_version:unsupported protocol

I have installed Sql Server 2019 Developer Edition and mssql-tools on my Ubuntu 20.04 minimal. I can connect to my localhost with no issue, but when I want to remote to another sql server: sqlcmd -S -U -P I face this…
Amirali Samiei
  • 223
  • 1
  • 3
  • 8
11
votes
1 answer

How to install mssql-server in Ubuntu 19.04?

While following this tutorial when executing sudo apt-get install -y mssql-server I get in the output the next error: The following packages have unmet dependencies: mssql-server : Depends: libjemalloc1 but it is not installable …
Fito
  • 700
8
votes
2 answers

mssql-server: Depends on libjemalloc1 which is a virtual package and is not provided by any available package

I'm trying to install SQL Server 2017 on Ubuntu 18.10 and encountering an error that libjemalloc1 isnt available. I've seen another answer that says that libjemalloc1 should be in universe for 18.04, but it doesnt look like it's available for 18.10…
Joshua K
  • 313
8
votes
5 answers

How do I install MS SQL for ubuntu 18.04 LTS?

I looked up on the internet but all those steps to install were regarding 16.04 version. Is it available yet on 18.04 ? If yes,how?
Siddharth Pandey
  • 121
7
votes
2 answers

sqlcmd not available after installing mssql-tools

I'm trying to access sql server database so i need sqlcmd but after following microsoft docs here and here. Running sqlcmd returns: sqlcmd: command not found and I do have mssql-tools installed: amir@amir-pc:~$ sudo apt-get install…
Amir Heshmati
  • 243
7
votes
1 answer

Sqlcmd: Error: Microsoft ODBC Driver 17 for SQL Server

I am not able to run sqlcmd command My OS (18.04) is $ uname -a Linux Linux 4.15.0-23-generic #25-Ubuntu SMP Wed May 23 18:02:16 UTC 2018 x86_64 x86_64 x86_64 GNU/Linux $ sqlcmd -S localhost -U SA -P 'password' Sqlcmd: Error: Microsoft ODBC…
Raakh
  • 103
7
votes
1 answer

Cant find pyodbc driver despite install

I have pyodbc installed and I am trying to connect to a server, but pyodbc can't find the drivers. I did the following: Installed pyodbc using pip: pip install pyodbc Followed the Microsoft instructions. Ran a test script: import pyodbc…
Rilcon42
  • 251
5
votes
1 answer

How to remove stop-jobs?

I have installed Microsoft SQL-Server on my ubuntu machine. Now it works fine, but every time I shutdown the machine, shutdown halts at A stop job is running for microsoft sql server database engine ( x/30min ) Now if you wait 30 minutes, then it…
WitchCraft
  • 1,904
3
votes
1 answer

MSSQL : SQLCMD not found

I am unable to install mssql-tools sudo apt-get install mssql-tools It gives the error: E: unable to locate How can I fix this?
chandra sekhar madepalli
  • 31
  • 1
  • 2
3
votes
1 answer

How to set Service mssql-server to start on boot?

How can i set Service mssql-server to start on boot root@ubuntu-s-1vcpu-2gb-lon1-01:/etc/init.d# update-rc.d mssql-server enable update-rc.d: error: cannot find a LSB script for mssql-server root@ubuntu-s-1vcpu-2gb-lon1-01:/etc/init.d#…
Amadeu Antunes
  • 211
1
2 3 4 5 6 7