Last call to make your voice heard! Our 2022 Developer Survey closes in less than a week. Take survey.

Questions tagged [mssql]

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

Filter by
Sorted by
Tagged with
0 votes
0 answers
11 views

Cannot start MS SQL Server on Ubuntu 20.04 LTS virtual machine after rebooting

I'm having a hard time trying to start SQL Server on Ubuntu 20.04 LTS after rebooting the virtual machine. When I first downloaded and installed the MS SQL Server, I could access the SQL Server (I ...
user avatar
0 votes
0 answers
25 views

Install mssql-tools on ubuntu agent

For publishing our applications we are using an agent which has always the latest ubuntu version. Therefor we don't know the exact version. One of the steps is for example installing the Azure CLI ...
user avatar
0 votes
0 answers
27 views

on Ubuntu 18.04.5 LTS trying to install mssql using sudo apt-get install -y mssql-server but Depends: libatomic1 but it is not going to be installed

sudo apt-get install -y mssql-server Output: Reading package lists... Done Building dependency tree Reading state information... Done Some packages could not be installed. This may mean that you have ...
user avatar
0 votes
1 answer
24 views

I've created a file, "sqlKill.shutdown", in ~/lib/systemd/system-shutdown, was this the correct way to stop MSSQL at shutdown?

My mssql-server service has a bad habit of not being stopped at shutdown. To remedy this, I've navigated to ~/lib/systemd/system-shutdown and created the file sqlKill.shutdown containing exactly the ...
user avatar
  • 83
1 vote
1 answer
2k views

SQLSTATE[08001]: [Microsoft][ODBC Driver 17 for SQL Server]TCP Provider: Error code 0x2746

I'm using PHP Laravel 7.4 on Ubuntu 20.04 and trying to get data from SQL Server located on a Windows server in another cloud. This method was tested on my PC (Windows) and it successfully retrieved ...
user avatar
0 votes
1 answer
55 views

Crontab to Restart SQL Server Services ubuntu 18.04

please how to add task to crontab to restart mssql systemctl restart mssql-server.service * */1 * * * systemctl restart mssql-server.service
user avatar
  • 3
0 votes
0 answers
947 views

Error while loading shared libraries: libodbc.so.2:

Hi i am trying to run sqlcmd in linux by this sqlcmd -S localhost -U SA -P '123' and i get this error sqlcmd: error while loading shared libraries: libodbc.so.2: cannot open shared object file: No ...
user avatar
0 votes
0 answers
61 views

My installed mssql extension visual studio code is not running in Ubuntu?

MSSQL extension part of Microsoft. I used in WIndows 10 2 years ago. it worked good. But i can't run the database in Ubuntu. What should i do?
user avatar
0 votes
1 answer
311 views

Connecting to remote SQL Server database over SSH

I am trying to connect to a remote SQL Server over SSH. How can I do this via the terminal?
user avatar
1 vote
1 answer
4k views

0x2746 Error msodbcsql connection to SQL Server 2016

I am getting a error when trying to use sqlcmd against my SQL Server 2016 database. I can successfully get a connection to on port 1433 (venv) xxxx@ip-xxx-xx-xx-xxx:/etc$ telnet xx.xxx.xxx.202 1433 ...
user avatar
0 votes
2 answers
235 views

Why was MS-Sql Server uninstalled from my ubuntu 20.04 desktop?

I just went out to use ms-sql server and I discovered that it was completely uninstalled from my Ubuntu 20.04 desktop. Why would the software be uninstalled without my knowledge? It also uninstalled ...
user avatar
  • 1,048
0 votes
2 answers
56 views

LXD command is executed on host instead of container

I am using this command: lxc exec container -- sh -c 'sqlcmd -S localhost -U SA -P <..> -i <...>', but it will get executed on the host instead of the container. But when I lxc shell ...
user avatar
  • 141
0 votes
1 answer
128 views

Disk Partitioning for Ubuntu server with SQL server

I need help with 'Disk Partitioning'. I want to install an Ubuntu 16 LTS server without a graphical user interface as a virtual machine (ESX 6.5) with MS-SQL Express (3 databases, each max. 10 GB (MS-...
user avatar
1 vote
0 answers
37 views

"SSIS" using up lots of system performance and burning through my battery. How to fix this?

I had my system updated yesterday and I can remember that "SSIS for Linux" (SQL Server Integration Services ) had a huge 200MB update in this. Today I was working on my notebook (Thinkpad ...
user avatar
  • 136
2 votes
0 answers
275 views

Couldn't remove mssql-server on linux

To work with ASP.Net I have wanted to install mssql-server. Unfortunately after at the end of installation, it should some error. So, I wanted to remove this bad installation to try to reinstall again....
user avatar
0 votes
1 answer
184 views

SQL Server 2019 on Ubuntu 20.10 with 4GB of Ram and Low Traffic Keeps Crashing and Needing To Be Restarted To Work Again

I have installed SQL Server 2019 onto a new Ubuntu instance with 4GB of Ram following the fact it would sometimes crash on an older Ubuntu 20.10 instance with 3GB of Ram. However the problem is even ...
user avatar
0 votes
1 answer
139 views

Could not download all repository indexes ppa mssql

when reloading the Synaptic package I face the below popup msg mas
user avatar
0 votes
1 answer
742 views

Can't access SQLCMD on Ubuntu 20.10

after install mssqlserver and when I try to run SQL command through the terminal I face this issue SQL Command sqlcmd -S localhost -U SA -P 'Sa123456#' error sqlcmd: error while loading shared ...
user avatar
0 votes
1 answer
1k views

Install Microsoft SQL Server 2019 Ubuntu 20.10

I have a problem when I follow steps to install ms-SQL-serve on ubuntu the steps in the below link: https://docs.microsoft.com/en-us/sql/linux/quickstart-install-connect-ubuntu?view=sql-server-ver15 I ...
user avatar
0 votes
1 answer
347 views

Run SSRS Report Builder

I was wondering if anyone out there has had success running SSRS's report builder in GNU/Linux? I have recently upgraded to ubuntu 20.04.1 LTS yet I still need to support SSRS Reports. I have been ...
user avatar
1 vote
0 answers
780 views

can't install mssql-server in ubuntu 20.04

few days ago updated from ubuntu 18.04 to ubuntu 20.04 through updates img to update I previously had mssql-server installed, after the update finished I tried to run mssql-server (which did not ...
user avatar
0 votes
2 answers
3k views

How to find SQL Server instance name on Ubuntu

I have linux ubuntu 16.04 and running MSSQL Server express Service is up and running. sudo systemctl status mssql-server result mssql-server.service - Microsoft SQL Server Database Engine Loaded: ...
user avatar
9 votes
1 answer
19k views

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 &...
user avatar
-1 votes
1 answer
52 views

Oracle 17 driver is missing and Cannot access to MS SQL server in Ubuntu 16.04

i have a 16.04 version Ubuntu. I recently installed MSSQL server in the system. The version is SQL express 2019. Everything was ok during the installation . I followed the instructions in this link: ...
user avatar
0 votes
1 answer
57 views

What version of MSSQL gets installed and how to set named instance

I see plenty of sites with instructions on installing mssql server on ubuntu, however, none of them seem to say what version of sql gets installed and the licensing terms. For example, I plan to ...
user avatar
  • 161
0 votes
2 answers
3k views

Package conflict while installing ms-sql in ubuntu. Broken packages [duplicate]

I am trying to install ms sql in Ubuntu 20.04. Even I have got it installed in 20.04 successfully following this guide but I sometime I have this problem multiple time and not sure why is this ...
user avatar
0 votes
0 answers
1k views

MSSQL Linux Problems, port 1433 status opened from ufw, but still cannot remote or even telnet

I have problem with MSSQL in Linux, and i'm installing it on Ubuntu 18.04 linux, im already open port 1433 and 1434 via ufw but still have no luck with remote connection and even from telnet, here my ...
user avatar
0 votes
0 answers
621 views

sqlcmd not found. mssql-tools not found after installation

I followed the instructions here which suggested me to create links. But turns out the mssql-tools is not found in /opt directory even though i had just installed it. What should i do to get sqlcmd ...
user avatar
0 votes
0 answers
402 views

How to install Northwind Database on ubuntu 18.04

I have installed MSSQL server , i tried creating tables and inserting , it worked well but i want to install Northwind Database , so i am asking if i can install it on ubuntu.
user avatar
1 vote
0 answers
693 views

How to bypass Hash Sum check for apt-get update

I have ubuntu 16.04 based vms and dockers using mssqlserver driver 17. Installed the classic way curl https://packages.microsoft.com/keys/microsoft.asc | apt-key add - curl https://packages....
user avatar
0 votes
1 answer
99 views

Cannot find source links in source file but still shows in apt update

I'm new to this, and I was trying to install MS SQL in 18.04. But I faced some issue and wanted to remove everything regarding MS SQL for new. So I purge everything and removed all GPG from /etc/apt/...
user avatar
1 vote
1 answer
917 views

Installing SQL Server command-line tools on Ubuntu 18.04 LTS

I am following this documentation: Install the SQL Server command-line tools and I am getting this: (base) khalid@Khalid:~$ curl https://packages.microsoft.com/keys/microsoft.asc | sudo apt-key add -...
user avatar
  • 11
2 votes
0 answers
1k views

Problem configuring MSSQL client and Kerberos authentication

I have a problem configuring an Ubuntu 18.04. client to connect to MSSQL Server using Windows Authentication. First of all, Kerberos/AD Login works fine using PAM and Winbind, connection using SQL ...
user avatar
  • 21
1 vote
1 answer
4k views

How to install PHP SQL Server drivers in Ubuntu 19?

I have followed the instructions on the tutorial for installation on Linux, but unfortunately the Unix ODBC dependencies are not available in the repos for Ubuntu 19.04. https://docs.microsoft.com/en-...
user avatar
11 votes
1 answer
6k views

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: ...
user avatar
  • 410
1 vote
0 answers
1k views

How to start MSSQL Server

I have installed MSSQl Server on my Ubuntu server 18.04 machine and every time I run it, it runs for about 1 min and stops with (code=exited, status=1/FAILURE). This is what shows when I run systemctl ...
user avatar
1 vote
0 answers
176 views

Installing SSL Certificate onto a MSSQL instance

I'm running Microsoft SQL Server 2017 on a 18.04 LTS Server (AWS Cloud). I'm looking into getting proper SSL security on the server, but I cannot seem to find any guides for Linux, only for windows. I'...
user avatar
18 votes
5 answers
34k views

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 ...
user avatar
0 votes
0 answers
55 views

How to update a string with values from other fields?

I have a table containing a column with a string value, and 3 other columns with data. How do I replace parts of the string, with the value of the other 3 columns? I need to be able to iterate this ...
user avatar
  • 171
5 votes
1 answer
4k views

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 ...
user avatar
  • 1,690
2 votes
3 answers
11k views

Unable to connect Microsoft SQL-Server and Visual Studio code

I just installed MSSQL 2017 for linux and Visual Studio code for linux on my Ubuntu 18.10 machine. Both the installation succeeded, but I cannot connect from visual studio to the DB. I have the ...
user avatar
1 vote
0 answers
1k views

Updating MS SQL Tools/ODBC Driver for Ubuntu 18.04

I've recently updated my MS SQL Server (R) Instance on my Ubuntu 18.04 box with the newest (for Ubuntu) MS SQL Server version 17. That went fine. But as I used the Software Updater to update the ...
user avatar
  • 111
1 vote
1 answer
198 views

cannot install mssql on ubuntu

telecast@telecast-PowerEdge-R210-II:~$ sudo curl -o /etc/apt/sources.list.d/mssql-server.list https://packages.microsoft.com/config/ubuntu/16.04/mssql-server-2017.list % Total % Received % Xferd ...
user avatar
  • 21
8 votes
2 answers
8k views

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, ...
user avatar
  • 311
-1 votes
2 answers
578 views

How to view the MS-SQL server at UI?

How to view the Database MSSQL server database at ui in ubuntu is their any s/w available. I am using ubuntu 16.04
user avatar
0 votes
1 answer
4k views

Failed to start Microsoft SQL Server Database Engine. code=exited, status=217/User

after an apt-get upgrade last week, i have failed to get my server back up and running again. I am running Ubuntu 16.04.5 LTS (GNU/Linux 4.15.18-2-pve x86_64). running systemctl status mssql-server ...
user avatar
0 votes
1 answer
1k views

my sql is not launching

mysql-workbench /usr/lib/mysql-workbench/mysql-workbench-bin: error while loading shared libraries: libgdkmm-2.4.so.1: cannot open shared object file: No such file or directory this error shows up ...
user avatar
15 votes
4 answers
61k views

Can I install SQL Server Management Studio on Ubuntu 16.04?

Can I install SQL Server Management Studio on Ubuntu 16.04?
user avatar
7 votes
1 answer
23k views

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 ...
user avatar
  • 73
0 votes
0 answers
26 views

MSSQL Service 50% Resources

I've been doing some testing on the current version of MSSQL on Linux. I'm using a DigitalOcean droplet to test using Ubuntu V16. Up front, MSSQL for linux recommended memory size is 2GB and that is ...
user avatar
  • 123