Questions tagged [mssql]
Questions regarding the Microsoft SQL database server, its tools and services.
85
questions
0
votes
0
answers
35
views
+50
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
48
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
171
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
165
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 ...
0
votes
0
answers
157
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 ...
0
votes
1
answer
315
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
89
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
159
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-...
-2
votes
1
answer
726
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 ...
- 97
0
votes
0
answers
165
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
1k
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 ...
1
vote
0
answers
2k
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/...
- 111
0
votes
1
answer
37
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
0
votes
0
answers
2k
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: ...
- 33
1
vote
1
answer
68
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 ...
- 140
0
votes
1
answer
29
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 ...
- 140
2
votes
1
answer
9k
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
164
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
681
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
13k
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
407
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,737
0
votes
2
answers
175
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
275
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
46
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
341
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
277
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
166
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
996
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
1k
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
768
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
1k
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
5k
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
36k
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
106
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
123
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 ...
1
vote
0
answers
2k
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
947
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
554
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
945
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
332
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
1
answer
1k
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 -...
- 11
2
votes
0
answers
1k
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 ...
- 21
1
vote
1
answer
4k
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-...
- 111
11
votes
1
answer
6k
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: ...
- 580
1
vote
0
answers
2k
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
0
answers
241
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'...
20
votes
5
answers
45k
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 ...
- 303
0
votes
0
answers
86
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 ...
- 171
5
votes
1
answer
5k
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 ...
- 1,792