Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [mssql]

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

2
votes
1answer
108 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
35 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
0answers
192 views

Can't connect to MS SQL Server

I am trying to use Nginx+PHP7.2+MS SQL Server driver but it doesn't work. I have installed packages by this doc but apache2 installation (I need Nginx). And I've added extensions to /etc/php/7.2/fpm/...
0
votes
0answers
79 views

Install revoscalepy pip package

Here, there is an instruction of installing revoscalepy on Ubuntu. In a Linux part here is the following line: For Linux (used in Docker): 'pip install https://rserverdistribution.azureedge.net/...
0
votes
1answer
169 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
0answers
8 views

How do I install MSSQL Server on Linux VM without internet?

I know this question has been asked before, but nowhere have I found a solution to install MSSQL server on Linux VM which has no internet. I need to get this done today itself, so any help is ...
0
votes
0answers
148 views

I'm getting errors after installing MSSQL in Ubuntu 16.04 Error: Microsoft ODBC Driver 17 for SQL Server

sqlcmd -U SA -P admin@1234 -Q 'CREATE DATABASE abc' Sqlcmd: Error: Microsoft ODBC Driver 17 for SQL Server : Can't open lib '/opt/microsoft/msodbcsql17/lib64/libmsodbcsql-17.2.so.0.1' : file not found....
0
votes
1answer
57 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 ...
4
votes
0answers
819 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
16 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 ...
1
vote
1answer
416 views

Cant find pyodbc driver despite install

I have pyodbc installed and I am trying to connect to a server, but I pyodbc cant find the drivers. I did: pip install pyodbc followed the Microsoft instructions here ran a test script: import ...
0
votes
1answer
633 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
619 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 ...
5
votes
4answers
14k 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

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 ...
1
vote
1answer
2k 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?
-1
votes
1answer
416 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
0answers
321 views

DBeaver and accessing mssql server

I installed DBeaver on Ubuntu and wanted to access my MS-Sql server that runs on my Windows machine (for educational purposes). What do I have to do on the server side to access it from the Ubuntu ...
0
votes
2answers
629 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
250 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,...
0
votes
1answer
2k 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
707 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
5k 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
74 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
558 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/...
5
votes
1answer
9k 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
3k 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 ...
4
votes
1answer
10k views

mssql on ubuntu, cant get it install?

So as of recently MS has launched mssql-server for linux. My only problem is I cant manange to get it to do the sudo apt-get install -y mssql-server It says E: Unable to locate package mssql-server ...
1
vote
1answer
6k views

Install ODBC and Sybase on Ubuntu 16.04

I am currently building Ubuntu 16.04 server for our project. Error occurs when I'm trying to install: sudo apt-get install php5-odbc php5-sybase tdsodbc The error says: Unable to locate package ...
0
votes
0answers
462 views

How to connect mssql via Java in ubuntu?

I am trying to connect our DB via Java in ubuntu. I am using VPN to connect out server. VPN is succesfully connected but when I was running program, I have been facing this error message: com....
15
votes
5answers
38k views

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 ...
0
votes
1answer
434 views

Does MSSQL interfere with MySQL on LAMP SERVER?

I'm currently working on a project that requires me to connect remotely to a MSSQL database on a different server. After some research and crawling of this site and google I think one of the ...
0
votes
1answer
199 views

Is it possible to install Microsoft SqlDbLocal instance on Ubuntu 14 LTS?

I have a complete code written in Visual Studio which I have ported to monodevelop in Ubuntu 14 LTS. I was thinking if there is a way to install the Sql localDB instance in Ubuntu 14.
0
votes
0answers
59 views

How to connect a MSSQL database from Ubuntu 14.04? [duplicate]

I am trying to connect a MSSQL database from a Ubuntu 14.04 machine. I am using FreeTDS to connect, by following this tutorial [http://guywyant.info/log/206/connecting-to-ms-sql-server-from-ubuntu/][...