Questions tagged [mssql]

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

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

Using sqlcmd and bcp throws error: For bcp it's “Unable to load BCP resource DLL” and for sqlcmd it's “Unable to load SQLCMD resource files”

I'm using ubuntu 20.04, it was completely clear new installation before the attemp to put ms sql on it. And I need to install SQL server and it's tools, so I followed these instructions. https://docs....
0
votes
2answers
32 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 ...
0
votes
1answer
44 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-...
1
vote
0answers
20 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 ...
1
vote
0answers
199 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....
0
votes
1answer
55 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 ...
0
votes
1answer
56 views

Could not download all repository indexes ppa mssql

when reloading the Synaptic package I face the below popup msg mas
0
votes
1answer
394 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 ...
0
votes
1answer
594 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 ...
0
votes
1answer
72 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 ...
1
vote
0answers
371 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 ...
0
votes
0answers
256 views

Ubuntu 18.04: Cannot connect to MSSQL 2014 [ssl_choose_client_version:unsupported protocol]

I'm trying to connect to a Microsoft SQL Server 2014 from my Ubuntu 18.04 LTS system. I first installed the required ODBC Driver following the instructions on https://docs.microsoft.com/en-us/sql/...
0
votes
2answers
890 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: ...
5
votes
1answer
5k 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 &...
-1
votes
1answer
39 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: ...
0
votes
0answers
47 views

Error during installing SQL Server 2019 in Linux server Ubuntu 16.04

I tried to install SQL Server 2019 in my Linux server Ubuntu 16.04 LTS. I just followed the steps that were given by Microsoft Linux Sql Server Installation, but I got an error when I tried to do the ...
0
votes
1answer
33 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 ...
0
votes
0answers
167 views

sqlcmd not working with MS SQL 2012

I have Ubntu 20.04 LTS (Focal Fossa) with ODBC Driver for Microsoft(R) SQL Server(R) 17.5.2.1-1 installed. I try to connect to MS SQL 2012 database without luck. sqlcmd -S tcp:IPADDRESS,PORT -U user -...
0
votes
0answers
386 views

Can't access SQLCMD on Ubuntu 20.04

I have been trying to access SQLCMD, but due to the following error I could not: sqlcmd: error while loading shared libraries: libodbc.so.2: cannot open shared object file: No such file or directory ...
0
votes
2answers
1k views

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

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 ...
0
votes
0answers
897 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 ...
0
votes
0answers
382 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 ...
0
votes
0answers
238 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.
1
vote
0answers
558 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....
0
votes
1answer
61 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/...
1
vote
1answer
699 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 -...
1
vote
0answers
572 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 ...
1
vote
1answer
3k 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-...
9
votes
1answer
5k 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: ...
1
vote
0answers
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 ...
1
vote
0answers
133 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'...
14
votes
5answers
22k 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 ...
0
votes
0answers
42 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 ...
5
votes
1answer
3k 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 ...
2
votes
3answers
8k 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 ...
1
vote
0answers
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 ...
1
vote
1answer
172 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 ...
7
votes
2answers
6k 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, ...
-1
votes
2answers
382 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
0
votes
1answer
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 ...
0
votes
1answer
848 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 ...
14
votes
4answers
45k views

Can I install SQL Server Management Studio on Ubuntu 16.04?

Can I install SQL Server Management Studio on Ubuntu 16.04?
6
votes
1answer
18k 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 ...
0
votes
0answers
24 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 ...
6
votes
1answer
8k views

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 ...
0
votes
3answers
4k views

Is there a way to install SSDT (SQL Server Data Tools) on Ubuntu?

Well, I don't know if it is a valid question or not but, I need to install three SQL Server services on my laptop namely: Analysis services, Integration services, and Reporting services. Windows ...
0
votes
1answer
840 views

PHP7.0-curl and MSSQL Tools Incompatibility

I'm trying to install Moodle on Ubuntu 18.04 and connect it to a MSSQL server. But when i try to install php7.0-curl extension, so moodle can work, the MSSQL Tools and other libs are being deleted ...
8
votes
5answers
24k views

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?
0
votes
0answers
1k views

can't install sql server on ubuntu 18.4 due to openssl [duplicate]

i'm trying to install ms sql server on ubuntu desktop 18.4 but i get what follows: luca@SQUARE:~$ sudo apt-get install mssql-server Reading package lists... Done Building dependency tree ...
2
votes
1answer
3k views

Ubuntu 18.04 MSSQL Repos

I'm excited to see the release of 18.04. My build needs the ability to connect to a MSSQL server running on Ubuntu 18.04 via PHP. Has a repo been released for mssql-server on this version of Ubuntu?