Unix and Linux Stack Exchange
Unix and Linux Stack Exchange

Questions tagged [sqlserver]

35 questions
6
votes
4 answers

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 hat)?
LIX
  • 165
  • 2
  • 7
5
votes
2 answers

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(AT_FDCWD, "/proc/self/status", O_RDONLY) = 5 fstat(5,…
Evan Carroll
  • 28,578
  • 45
  • 164
  • 290
4
votes
5 answers

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, %> sqlcmd -S IP Sqlcmd: Error: Microsoft ODBC Driver 13…
daisy
  • 53,527
  • 78
  • 236
  • 383
3
votes
3 answers

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 database command, but I haven't been able to download…
drizzle
  • 31
  • 1
  • 2
3
votes
1 answer

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
  • 28,578
  • 45
  • 164
  • 290
3
votes
1 answer

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/results. However, when I execute statements with…
CamelCamelius
  • 183
  • 8
2
votes
1 answer

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:…
NetRunner77
  • 21
  • 1
2
votes
3 answers

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 want to install database on my server later I just…
BlackCrystal
  • 716
  • 14
  • 39
2
votes
1 answer

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 stuff. It uses file descriptors redirection to…
CamelCamelius
  • 183
  • 8
2
votes
1 answer

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 possible, and what are possible methods to achieve…
Deele
  • 293
  • 1
  • 3
  • 10
2
votes
1 answer

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 working sem_init()... configure: error: in…
Sławomir Kozok
  • 131
  • 1
  • 1
  • 3
1
vote
0 answers

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 was perfectly able to connect to the SQL server…
RS Finance
  • 111
  • 2
1
vote
1 answer

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("myhost") username("myuser") password("mypass") …
kaptan
  • 285
  • 2
  • 12
1
vote
1 answer

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.so. but not sure where to paste the modules…
Ratan Thapa
  • 11
  • 1
  • 4
1
vote
0 answers

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 Powershell...since this is a windows item (not installed…
Kevin Dobson
  • 11
  • 1
1
2 3