Questions tagged [mssql]
Questions regarding the Microsoft SQL database server, its tools and services.
94
questions
0
votes
0
answers
28
views
"find: ‘/proc/780/map_files’: Operation not permitted" While Configuring MS SQL Server on Ubuntu 20.04 via package manager
Configuring SQL Server...
This program has encountered a fatal error and cannot continue running at Thu Jul 18 12:26:58 2024
The following diagnostic information is available:
Reason: 0x00000001
...
0
votes
1
answer
383
views
Manual install sqlsrv and pdo_sqlsrv
For an upcoming web project I am testing 24.04 server with MSSQL connectivity.
It's a LAMP environment with PHP 8.3.
So far I have managed to install (with a few tricks) msodbc driver and tools (V18). ...
0
votes
0
answers
206
views
mssq server failed to active after upgrade from 22.04 to 23.10
sudo systemctl status mssql-server
× mssql-server.service - Microsoft SQL Server Database Engine
Loaded: loaded (/lib/systemd/system/mssql-server.service; enabled; preset: enabled)
Drop-In: /etc/...
- 1
0
votes
0
answers
2k
views
SQL Server fails to start on Ubuntu 22.04
I created a new instance of Azure VM running Ubuntu 22.04 just to reproduce this issue.
I'm following this guide to install the SQL server on my freshly deployed VM. There should be definitely enough ...
0
votes
0
answers
140
views
Mount file system which is a SQL Server filestream
We've got a web app (.NET 8.0) which uses the File API to save and load files from a SQL Server's FileTable. In practice, this means that the web app can rely on a "virtual" share to load ...
- 177
1
vote
1
answer
2k
views
/opt/mssql/bin/sqlservr: error while loading shared libraries: libssl.so.1.1: wrong ELF class: ELFCLASS32
I am trying to install mssql-server and when running the setup I get the following error at the end:
/opt/mssql/bin/sqlservr: error while loading shared libraries: libssl.so.1.1: wrong ELF class: ...
- 524
0
votes
2
answers
3k
views
Problems installing MS SQL Server and MySQL on Ubuntu 22.04
I wanted to download and install the SQL server and MySQL to execute my queries in Ubuntu Linux 22.04. I faced many problems but now I was stuck in the major issue. When I run
dpkg -l | grep -i mysql
...
0
votes
0
answers
33
views
ubuntu 22.4 close mssql express 16.0.4085.2-1 by force
Ubuntu version:
No LSB modules are available.
Distributor ID: Ubuntu
Description: mleUbuntu 22.04.3 LTS
Release: 22.04
Codename: jammy
MSSQL version:
ii mssql-server 16.0.4085.2-1 ...
-2
votes
1
answer
318
views
How to install mssql server in ubuntu 22.04
Please How do I Install SQL server in Ubuntu 22.04 LTS
0
votes
0
answers
57
views
Ubuntu, Node.js, sqlcmd, sqlcmd-runner component: work locally (windows 10), restart (pm2) app.js on Ubuntu server, Why?
I code backend in Windows 10, vs-code, and upload code to Ubuntu server, node.js, MsSQL express.
In my case, I need to make a new database for every customer, then dynamically create a database ( no ...
1
vote
0
answers
393
views
How do I install MSSQL Server on Ubuntu
I am 74 years old and an old Windows user (dating back to MS-DOS 3.0 days) I am dumping Windows 10 and moving over to a Linux OS. I have chosen Ubuntu for my migration.
Here is my situation. I am ...
- 11
0
votes
0
answers
909
views
ODBC connection to MS SQL Server only works woth SECLEVEL 0
I am trying to connect to an MS SQL Server from Ubuntu 22.04. I installed the ODBC driver for the MS SQL server, created the DSN, and when I tested the connection using isql, I got the error:
Sqlcmd: ...
- 101
0
votes
1
answer
358
views
Cannot connect to remote mysql server 2012 from ubuntu 22.04 using frets or ms sql driver
I recently installed ubuntu 22.04.
I then installed openssl, unixodbc-dev, freetds, and mssqlodbc18 using apt.
When I try to connect to a remote SQL Server I get an error. It is SQL Server Express ...
- 101
1
vote
0
answers
583
views
error when installing sql server on ubuntu 20.04
I am trying to install sql server on ubuntu 20.04 as described here. In my understanding I don't have to install docker to run sql server on ubuntu 20.04. When executing
sudo /opt/mssql/bin/mssql-conf ...
- 11
0
votes
1
answer
1k
views
Error installing Microsoft ODBC 17 driver
I'm trying to install the Microsoft ODBC Driver 17 in Ubuntu 20.04 following the instructions from here.
However, when I type
sudo ACCEPT_EULA=Y apt-get install -y msodbcsql17
I get the following ...
- 183
0
votes
0
answers
370
views
Connecting from Linux to an SQL database server?
Regarding some troubles connecting from Linux to an SQL Database Server. I read a variety of topics on this community and some DBA forums, but couldn't get it working.
Some background information:
...
- 31
0
votes
1
answer
467
views
how to fix " You are currently not seeing messages from other users and the system. Users in groups 'adm', 'systemd-journal' can see all messages."
I am trying to install ms sql sudo /opt/mssql/bin/mssql-conf setup on ubuntu but gwtting this messsage i have tried it the following sudo usermod -aG adm <username> and sudo usermod -aG systemd-...
-1
votes
1
answer
2k
views
Error establishing a connection to SQL Server
Welcome, After installing MS SQL Server on Ubuntu and trying to connect it shows the following:
~$ sqlcmd -S .\SQLEXPRESS -Q "SELECT GETDATE();"
Sqlcmd: Error: Microsoft ODBC Driver 17 for ...
- 107
0
votes
0
answers
690
views
Ubuntu 20.04 High RAM usage
I have a Linux VM that has 8 GB RAM. This is a screenshot of htop which includes all system information (tasks,services). There's no application using too much RAM when looking at the PIDs, but the ...
- 1
0
votes
2
answers
3k
views
ubuntu 22.04 sqlcmd can not connect to ms sql server 2016
I have spent several days on google search to find a solution, but no right one. so I post it here.
I have 3 VM machines.
VM 1:
windows server 2012 R2 sp1, 192.168.1.10
sql server 2016, port 1432
sql ...
2
votes
0
answers
3k
views
[08001][Microsoft][ODBC Driver 18 for SQL Server]TCP Provider: Error code 0x2746 - Ubuntu 22.04
I'm trying to connect to an MS SQL Server 2016 from my ubuntu server 22.04.
I've installed the odbc driver following the official MS documentation: https://learn.microsoft.com/en-us/sql/connect/odbc/...
- 121
0
votes
1
answer
73
views
Recommend a tool for managing bak files?
I have an ubuntu-server running MS SQL Server Express and a bash script running backups of the databases every 24 hours.
I could spend a lot of time scripting something to manage the files, but if ...
- 151
1
vote
0
answers
3k
views
mssql-server suddenly crashes on startup
I've recently noticed that my MSSQL server doesn't start anymore. It just throws the error:
sqlservr: Unable to read instance id from /var/opt/mssql/.system/instance_id: File: pal.cpp:438 [Status: ...
- 53
1
vote
1
answer
74
views
Why do MS-SQL and RStudio have users on my log-in screen?
I attempted to log in today and discovered that I had more users than I thought. It seems that both MS-SQL and RStudio users exist on my PC and are visible on my log-in screen. I've ran SQL on my ...
- 160
0
votes
1
answer
42
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 ...
- 160
2
votes
1
answer
13k
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 ...
- 21
0
votes
1
answer
294
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
- 3
0
votes
1
answer
843
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?
1
vote
1
answer
15k
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
...
- 131
0
votes
2
answers
473
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 ...
- 1,868
0
votes
2
answers
294
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 ...
- 141
0
votes
1
answer
367
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
0
answers
47
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 ...
- 136
2
votes
0
answers
389
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
1
answer
374
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 ...
- 211
0
votes
1
answer
183
views
Could not download all repository indexes ppa mssql
when reloading the Synaptic package I face the below popup msg
mas
1
vote
1
answer
1k
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
1
answer
2k
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
1
answer
1k
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
0
answers
2k
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 ...
- 11
0
votes
2
answers
6k
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: ...
11
votes
1
answer
44k
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 &...
- 223
-1
votes
1
answer
144
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
1
answer
192
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 ...
- 161
0
votes
2
answers
4k
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 ...
- 155
1
vote
0
answers
3k
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 ...
- 11
0
votes
0
answers
1k
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
0
answers
669
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
0
answers
1k
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....
- 119
0
votes
1
answer
505
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/...
- 155