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.

0
votes
0answers
51 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
31 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
78 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
7 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
79 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
45 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
548 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
266 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
433 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
520 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
11k 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
270 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
270 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
1answer
529 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
219 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
631 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
72 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
530 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
9k 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
5k 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
434 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....
13
votes
5answers
35k 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
423 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
186 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
57 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/][...