Skip to main content

Questions tagged [sqlserver]

The tag has no usage guidance.

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

Why are my strings being truncated including and after an equals sign?

I was writing a shell script for inserting a string value through a Microsoft sqlcmd variable into a Microsoft SQL server database table and noticed some unexpected behavior. It appeared the trailing ...
Mark's user avatar
  • 101
0 votes
1 answer
369 views

Install failed when installing PDO sqlsrv on debian 12 with PHP 8.3

I want to install pdo_sqlsrv on a Debian 12 server with PHP 8.3. I'm following the documentation available here. The latest version seems to be perfect (5.12.0), but I can't install it. After doing ...
Elikill58's user avatar
  • 133
2 votes
0 answers
434 views

mssql service cannot start, after setup

After installing mssql-server, it successfully installs then on setting up it fails with the error below Step one - on setup it fails with the error below sudo /opt/mssql/bin/mssql-conf setup > ...
skeeper's user avatar
  • 21
0 votes
0 answers
176 views

How to Fix "MySQL error message was : DBI connect failed : Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) ?"

I upgraded my VPS with the provider Contabo, and since then, I have been experiencing issues. Unfortunately, they have not been responsive or provided any support. when i do command : service mysql ...
MD.Favaz's user avatar
2 votes
2 answers
2k views

LDAP 2.5 breaks SQL Server on Debian 12

Resterted due to power cut and now SQL Server isn't starting because /opt/mssql/bin/sqlservr: error while loading shared libraries: liblber-2.4.so.2: cannot open shared object file: No such file or ...
Richard Barraclough's user avatar
0 votes
0 answers
377 views

What is causing the error when trying to start mssql-server on Linux Mint using sudo /opt/mssql/bin/mssql-conf setup, and how can it be resolved?

This is the error that is popping up! I am trying to install sql server 2019. I read in one github question that this isn't an mssql-server error but something that has to do with the linux itself, or ...
rtoxis's user avatar
  • 1
3 votes
1 answer
879 views

Installing MS SQL Server on Debian 11 -- Repo Signature Problem

trying install MS SQL Server 2022 on Debian 11 is driving me crazy, as I'm not being able to add MS repo properly. First of all, step-by-step guide by Microsoft -just for Ubuntu- in this page: https://...
NetRunner77's user avatar
0 votes
1 answer
903 views

Cannot install Microsoft SQL Server to Ubuntu AWS /lib/x86_64-linux-gnu/libc.so.6: version 'GLIBC_2.30' not found

I am trying to install SQL server onto a Ubuntu machine on AWS and it has been nothing but trouble. I get stuck on the last step, configuring the server after selecting edition and setting an ...
Aguso1133's user avatar
1 vote
0 answers
699 views

Ubuntu - Microsoft SQLCMD - Error Locating Server/Instance Specified

So, I have this issue that I can't connect to an MS SQL Server from an Ubuntu VM. The situation: One Windows Server with multiple MS SQL Instances Two Ubuntu 20.04 LTS VMs One of the two Ubuntu VMs ...
RS Finance's user avatar
0 votes
0 answers
314 views

Help to configure SSH tunnel to access to a remote server

Here my scenario: 192.168.2.222 --- VPN ---> 192.168.2.200 / 192.168.0.10 --- LAN ---> 192.168.0.50 My local machine My remote machine Target server Due to the ...
Mark's user avatar
  • 733
1 vote
1 answer
3k views

connect mssql database on Centos 8 using php 7.4

I cannot figure out the way to connect MSSQL 2014 database on centos 8 using PhP 7.4. I found GitHub link and downloaded CentOS8-7.4.tar and extracted the php_sqlsrv_72_ts.so and php_pdo_sqlsrv_72_ts....
Ratan Thapa's user avatar
0 votes
1 answer
76 views

Resetting Debian Password without restarting at all? [duplicate]

My company has a Debian server that holds and runs some important stuff that cannot be shut down... The previous Joe before me, didn't seem to have a password logged or even passed on the information ...
jon compton's user avatar
1 vote
0 answers
226 views

SQL SERVER (LINUX) – syspolicy_purge_history job failing step 3: Erase Phantom System Health Records

No one out there seems to have an answer for this...everything is for windows and no help for those using linux to run SQL Server 2019. Problem is that the 3rd step in this process is to run ...
Kevin Dobson's user avatar
0 votes
1 answer
375 views

SQL Server 2019 (Centos 8) Non-Yielding Scheduler

We are running SQL Server 2019 (Linux) CU4 with the following server specs: OS: Centos 8 RAM: 32GB HDD: 1TB SSD CPU: 8 Core I-7 SQL: Microsoft SQL Server 2019 (RTM-CU4) (KB4548597) - 15.0.4033.1 (X64)...
Kevin Dobson's user avatar
1 vote
0 answers
2k views

How to store value of sqlcmd query into variable in shell scripting

I tried to store the value of my sqlcmd query into variable and display the output. For example cwdusers=$(sqlcmd -S "mydb" -U xxx -P xxxxx -d My_DB -Q "select count(*) from user_table") echo "Total ...
Faraz's user avatar
  • 11
0 votes
1 answer
2k views

How to write data to a csv file with comma in string values

I need to hit a database with basic select queries and write the result output in a file. using sqlcmd I execute the queries and write the results to the output csv file. While trying to open this ...
Venkat's user avatar
  • 3
0 votes
1 answer
589 views

How to use * in shell scripting [duplicate]

I have table in database which stores few queries, Using sqlcmd I am trying to retrieve the queries. While doing so, the select * from abc is getting replaced with 'select from abc' How to overcome ...
Venkat's user avatar
  • 3
0 votes
0 answers
2k views

Installing OpenSSL 1.1.0

I am trying to connect to an instance of SQL Server 17 running on my Ubuntu 18.04 machine, using Azure Data Studio, and after a long session of brainstorming, I discovered that it depends upon OpenSSL ...
CuriousLearner's user avatar
1 vote
1 answer
509 views

mssql-server on debian broken after update?

Time ago I installed mssql-server on my debian VPS and works fine. Now, mssql-server not run and I don't know what is changed. If type /opt/mssql/bin/sqlserver I get 2019-07-07 18:13:19.79 Logon ...
crossmax's user avatar
  • 199
0 votes
3 answers
3k views

Install the PHP drivers for Microsoft SQL Server

I'm using web server nginx, php 7.1 fpm and laravel in Centos 7. I want to install SQL Server following the official installation tutorial for Linux but I'm confused with this command: echo extension=...
Steven Audy's user avatar
2 votes
3 answers
2k views

kdump in CentOS 7

I wanted to migrate to CentOS 7.5 from CentOS 6.9. during installation I saw an option kdump that i could enable or disable. I wonder what is kdump and disabling it has any bad effect on server? I ...
BlackCrystal's user avatar
1 vote
1 answer
511 views

"sqldeveloper-18.1.0.095.1630-no-jre.zip" not found, aborting... error message [closed]

During installation of Debian package builder for Oracle SQL developer in Ubuntu 18.04, I used the following command: make-sqldeveloper-package sqldeveloper-18.1.0.095.1630-no-jre.zip but it is ...
Shivanshu's user avatar
  • 123
3 votes
1 answer
437 views

Can getauxval be used to determine whether or not you're being traced?

Coming off of this question, I patched my kernel in a quest to get SQL Server 2017 on Linux to start up. Now I'm getting further but I'm being shut down, strstr("TracerPid:\t0\n", "TracerPid:") ...
Evan Carroll's user avatar
  • 31.8k
5 votes
2 answers
3k views

How do I hide TracerPID from a process?

I'm conjecturing SQL Server on Linux is checking /proc/self/status for TracerPID and then dying if it's not 0. I want to test that. Playing around, here is the strace, ... lots of stuff openat(...
Evan Carroll's user avatar
  • 31.8k
0 votes
1 answer
50 views

Is it needed for the server daemon to running so that it could be included as a dependency while building some other package?

I'm making the postfix MTA which depends on some database packages(mariadb, postgresql,...). I'm building on the instructions of Beyond Linux Form Scratch (BLFS) but I fear if it is needed for the ...
Rajnish kumar's user avatar
1 vote
0 answers
70 views

SQL-Server for Linux WORKGROUP authentication handling

I installed SQL-Server for Linux on a linux Centos 7 distro, it works fine, but I need a workgroup authentication. It's required by the client (SAGE Ligne 100) which runs on a Windows workstation. ...
Zebu1er's user avatar
  • 51
0 votes
1 answer
7k views

Increase Ram Provided to docker container

I'm trying to run the docker mssql container on a Linux host. In the tutorial it is described how you should increase the RAM size allocated to the container and how you do that on Windows and Mac ...
Philippe's user avatar
  • 479
4 votes
5 answers
9k views

sqlcmd does not work: Can't open lib libmsodbcsql.13.dylib

I've installed mssql-tools and msodbcsql, And I've symlinked /usr/local/homebrew/lib/libmsodbcsql.13.dylib to /usr/local/lib/libmsodbcsql.13.dylib But sqlcmd still complains about missing lib, %>...
daisy's user avatar
  • 54.9k
3 votes
1 answer
936 views

BCP neither gives results nor outputs anything when using valid statements but it does throw errors when passing invalid parameters

I have to use bcp command-line tool to export data from an SQL Server database to a file in a Red Hat server. I am (apparently) using valid statements but bcp is not producing any kind of output/...
CamelCamelius's user avatar
2 votes
1 answer
353 views

Unexpected behavior of file descriptor and/or I/O streams after running sqlcmd with -i option (read sql from file) in ksh creates infinite loop

Is there a way to use sqlcmd with -i input_file option without creating an infinite loop in my ksh script? The code reads lines from $file and parses it line-by-line to extract data and process other ...
CamelCamelius's user avatar
2 votes
1 answer
12k views

Cannot run test program while cross compiling - cross compiling Firebird

I've tried to compile firebird server for arm linux, with cross-compiler (it's choosen - it's working properly). When using: ./autogen.sh --host=arm-linux-gnu I get this error: checking for ...
Sławomir Kozok's user avatar
1 vote
1 answer
117 views

ODBC connection from a Linux box to MS SQLServer

I need to connect to MS SQLServer from a Linux box using ODBC from a Qt application I am developing. So far I have installed the ODBC MS SQLServer driver and Kerberos on the Linux box. Using kinit I ...
Michael Vincent's user avatar
0 votes
4 answers
2k views

Find a server IP on LAN from a script

I am looking for a way to have a script on a client machine automatically find the servers IP on the same network. I have several media extender clients running ubuntu 14.04.1 and a server running ...
JpaytonWPD's user avatar
1 vote
2 answers
10k views

Can't Install php-mssql or freetds on Centos7

My goal is to connect to MS SQL Server 2005 using PHP. I have installed PHP and ODBC. I am running CentOS7. PHP Version => 5.4.16 .... (from php -i) .... odbc ODBC Support => enabled I am ...
DylanH's user avatar
  • 113
1 vote
1 answer
690 views

syslog-ng ignores MSSQL database name

syslog-ng ignores the database defined in syslog-ng.conf and instead uses the default database of the user when logging to MSSQL destination. destination d_mssql { sql(type(mssql) host("...
kaptan's user avatar
  • 307
1 vote
1 answer
104 views

Apostrophe appearing as space

I am trying to insert the following message: friend's mobile number from a file over redhat server into sql server 2005. this message is appearing in the sql server as below: friend s mobile ...
WAEL's user avatar
  • 1,599
2 votes
1 answer
301 views

MSSQL database server on UNIX

I have heard rumors, but did not manage to find anything more, about some sort of MSSQL serving on UNIX machine, or MSSQL/MySQL server, that can handle MSSQL storage. I would like to know, if it is ...
Deele's user avatar
  • 293
3 votes
3 answers
3k views

backup MSSQL database to a client's local disk over network

I'm trying to backup a MSSQL server from linux. I'm able to connect to the server using tsql (from the freetds project), and I'm even able to backup the database on the server using the backup ...
drizzle's user avatar
  • 31
6 votes
4 answers
6k views

Can I work with Sql Server, Office and C# using Linux?

I want to start working with linux, and I know I should work in that regularly to improve myself. I work with sql server, office, c# at the company. can I install and do my tasks in linux (i.e. red ...
LIX's user avatar
  • 165