Questions tagged [mssql]

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

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

Unable to Locate package: Installing MS SQL server on ubuntu 20.04 [duplicate]

I am following the official documentation to install mssqlserver in ubuntu. I have already set up the mssql server and the system service is loaded and is running. However, after this step, I have to ...
0
votes
1answer
112 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
46 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
66 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
63 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.
0
votes
0answers
21 views

UFW - to MSSQL server - port forward

I have a gateway node with UFW running. (public ip and internal ip_ I have set up the DNAT to forward port 1433 to the ip address of my database machine (which is behind this gateway node) I still ...
1
vote
0answers
338 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
45 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/...
0
votes
0answers
30 views

Cannot connect to MsSQL Enable TCP connections

I'm trying to enable TCP connections. I'm making an app and I'm using mssql with node. The message I'm getting is: ConnectionError: Failed to connect to hostname:1433 - getaddrinfo ENOTFOUND ...
0
votes
0answers
346 views

How to set up pyodbc driver for python 3.6 superset docker

I followed the guide on https://superset.incubator.apache.org/installation.html to install the docker. Now i need to install pyodbc driver for SQL server connection. Driver installed successful: ...
1
vote
1answer
209 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
209 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 ...
0
votes
0answers
10 views

MSSQL server Installation Malformed in line 1 [duplicate]

I am trying to install mssql server on Ubuntu Server 16.04. While running apt-get update I am getting: E: Malformed entry 1 in list file /etc/apt/sources.list.d/mssql-server.list (type). Can you ...
1
vote
1answer
2k 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-...
0
votes
0answers
49 views

php on ubuntu 18.04 on hyper-v, with MSSQL on WMWare very slow compared to XAMPP (100 times slower!)

I've been struggling with this problem for months now, I need help... Google searches haven't helped as much as they normally do. So... We have a php web server (Ubuntu linux server on hyper-v) ...
9
votes
1answer
4k 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
706 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
90 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'...
7
votes
4answers
9k 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
28 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 ...
4
votes
1answer
2k 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
3k 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
826 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
114 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 ...
6
votes
2answers
5k 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
216 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
2k 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
649 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 ...
10
votes
2answers
27k views

Can I install SQL Server Management Studio on Ubuntu 16.04?

Can I install SQL Server Management Studio on Ubuntu 16.04?
5
votes
1answer
11k 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 ...
5
votes
1answer
5k 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
3k 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
788 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
23k 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?
0
votes
1answer
2k views

How to set Service mssql-server to start on boot? [duplicate]

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

Unknown locale UTF-8 when installing MsSQL server on ubuntu

I'm trying to install Ms SQL Server on ubuntu 17.10, I run commands step by step: wget -qO- https://packages.microsoft.com/keys/microsoft.asc | sudo apt-key add - sudo add-apt-repository "$(wget -qO-...
1
vote
1answer
513 views

How to install Microsoft.ACE.OLEDB.12.0?

How do i install Microsoft.ACE.OLEDB.12.0 on ubuntu 16.04? I have installed SQL Server 2017 Express. insert into EPI_NDC_Product SELECT PRODUCTID,PRODUCTNDC,PRODUCTTYPENAME,PROPRIETARYNAME,...
1
vote
1answer
7k views

Freetds can't connect to MSSQL

I had to upgrade to php 7.1 and then my connection to mssql via freetds aren't working PHP 7.1.12-1+ubuntu16.04.1+deb.sury.org+1 Ubuntu 16.04.3 LTS SQL Server 2008 r2 The tsql -C tsql -C Compile-...
0
votes
1answer
1k views

Problem with pdo_sqlsrv and sqlsrv driver for mssql

I need to connect to a MS SQL server. I use PHP 7.1.12-1+ubuntu16.04.1+deb.sury.org+1 on Ubuntu 16.04.3 LTS I've followed the official documentation but i get this error tryn to execute the script ...
0
votes
2answers
12k views

SQLSRV driver installation problem in Ubuntu 16.04 32-bit system

I'm trying to install sqlsrv driver in my Ubuntu 16.04 os system, but I get this error running: make /bin/bash /tmp/pear/temp/pear-build-rootliPAYQ/sqlsrv-4.3.0/libtool --mode=compile g++ -std=c++...
0
votes
1answer
93 views

Ubuntu Virtual Host cant connect to MS-SQL Server

Scenario: Running laravel to connect to sql server. It connects and works fine when the application is run from the terminal. (using php artisan serve) But when its put up in a virtual host (test....
-1
votes
1answer
1k views

mssql connection via odic

i have an issue connecting an mssql database via odbc in ubuntu 16.04 LTS. I have installed unix odbc and mussel driver. mssql driver is declared in odbcinst.ini : statadmin@dsc-stat:~$ cat /etc/...
6
votes
2answers
13k views

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

connect to mssql server from php7

I installed mssql and I have a mssql database. I want to connect to this database through php7. I'm using PDO $dbh = new PDO ("dblib:host=hostname:portnum;dbname=dbname" , "username" , "password"); ...
2
votes
1answer
4k views

MSSQL : SQLCMD not found [duplicate]

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?
2
votes
5answers
4k views

Getting error code(1) when installing MSSQL server in Ubuntu 16.04

Getting error code(1) in installing MSSQL Server in ubuntu 16.04 ERROR: This machine must have at least 3.25 gigabytes of memory to install Microsoft(R) SQL Server(R). But I have 283.4 gigabytes ...
9
votes
2answers
19k views

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 ...