Stack Overflow
Stack Overflow

Questions tagged [sql-server-linux]

29 questions
9
votes
1 answer

How to view execution plans in SQL Server on Linux

I have SQL Server installed on Linux. It was installed from Microsoft's repos as described here: https://learn.microsoft.com/en-us/sql/linux/quickstart-install-connect-ubuntu In MySql I used to write EXPLAIN in front of my query to see the execution…
Gherman
  • 6,768
  • 10
  • 48
  • 75
8
votes
3 answers

Failed Start for Microsoft SQL Server Database Engine on Linux

I have installed mssql on Ubuntu 16.04. following are the details of sql server. ms sql (14.0.3015.40-1) i.e SQL server 2017. when I run the configuration command #sudo /opt/mssql/bin/sqlservr-setup I got error sudo: /opt/mssql/bin/sqlservr-setup:…
chetan
  • 953
  • 3
  • 12
  • 20
6
votes
1 answer

MSDTC configuration issues with SQL Server in Docker (Linux) and Windows Host

I'm migrating a local SQL Server development database to run in a Linux docker container (on the same dev machine). When running my integration tests in Visual Studio 2019 on Windows, I receive MSDTC errors: Exception…
Chris Klepeis
  • 9,783
  • 16
  • 83
  • 149
6
votes
2 answers

SQL Server in Docker CREATE INDEX failed because the following SET options have incorrect settings: ‘QUOTED_IDENTIFIER’

I have a SQL Server Dockerfile with my import-data.sh importing *.sql files from a sql-data folder. Everything works if I run the *.sql files from a tool like Datagrip but the import fails with this error message when it's ran automatically. Error…
Nick
  • 978
  • 1
  • 12
  • 28
5
votes
1 answer

docker-compose restore database in sql-server-linux

I'm following https://learn.microsoft.com/en-us/sql/linux/sql-server-linux-configure-docker?view=sql-server-2017 to config and run standalone sqlserver container in macos with persistent data successfully. Now I want to create a docker-compose file…
Steve Lam
  • 979
  • 1
  • 17
  • 40
5
votes
1 answer

How can I restore a bacpac file to SQL Server linux docker container?

I am trying to setup an integration testing environment for Docker. We need to restore a bacpac to our mssql-server-linux:latest image so we can run tests based on the dataset. My compose file looks like: version: '3' services: projectweb: …
GraemeMiller
  • 11,973
  • 8
  • 57
  • 111
4
votes
1 answer

How can I access more than 251GB in a Docker named volume in WSL2?

I've created a named volume for my SQL Linux data files but the default size of 251G was too small. I followed the instructions to expand the size of a WSL2 VHD and then use resize2fs to increase to about 900GB. sudo resize2fs /dev/sdb…
stucampbell
  • 6,383
  • 5
  • 26
  • 25
4
votes
0 answers

T-SQL Backup/Restore to/from URL does not work on SQL Server 2017 Web Edition on Ubuntu Linux 16.04 LTS

I tried, without success, to run a T-SQL script to Backup to URL and another one to Restore to URL on SQL Server 2017 Web Edition, which is running on Ubuntu 16.04 LTS. The credential was successfully created. Here's an example of the T-SQL for…
João Bentes
  • 71
  • 1
2
votes
1 answer

mssql-cli connect to local server server container error occurred during the pre-login handshake

I just run sql server via docker on CentOS 7 sudo docker run -e 'ACCEPT_EULA=Y' -e 'SA_PASSWORD=Admin@2019' -p 1433:1433 --name sql2017 -d mcr.microsoft.com/mssql/server:2017-latest then, I try to connect via mssql-cli got error: A connection…
Hamid
  • 1,099
  • 3
  • 22
  • 37
2
votes
1 answer

Docker run and sqlcmd together errors

Putting together a script to quickly add a SQL Server Linux instance inside a docker container, then immediately connecting to it to test. Seems like the run command and sqlcmd can't be run in the same script. Say you run this in a .ps1 file: …
Knightwisp
  • 315
  • 1
  • 13
1
vote
0 answers

Kubernetes Microsoft SqlServer unstable

I followed an official documentation on how to deploy Microsoft SqlServer in Kubernetes as a container on Azure Kubernetes Service. There is a couple things I'm noticing and it's concerning: Two containers in Kubernetes When I execute kubectl get…
Andrei
  • 42,814
  • 35
  • 154
  • 218
1
vote
1 answer

'Windows NT user or group not found' when creating Windows logins on SQL Server 2019 on Linux

I need to enable Active Directory authentication on SQL Server 2019 running on CentOS 7. The server centos-1 alresdy has sssd pre-configured to us AD authentication. However, I followed the official Microsoft guide on how to enable Windows…
chpong-chpang
  • 11
  • 4
1
vote
0 answers

Connect to SQL Server instance running on playwithdocker with a local Management Studio

I'm able to run a SQL Server (for linux) instance in playwith docker docker run -e "ACCEPT_EULA=Y" -e "SA_PASSWORD=Password_01!" -p 1433:1433 --name sql1 --hostname ciccio -d microsoft/mssql-server-linux:2017-latest and issue some commands from…
pinale
  • 2,060
  • 6
  • 38
  • 72
1
vote
1 answer

Can SQL Server run over SCO SantaCruz Operations SO (Linux)?

I wanna know if Microsoft SQL Server can run over the SO of Santa Cruz Operations SCO, Linux based SO, I already looked into the documentation available in it's web page but isn't specified, does anyone here knows if it's posible, due the fact than…
little m
  • 115
  • 1
  • 2
  • 14
1
vote
1 answer

cant connect to sqlserver docker image

running the container docker run -e "ACCEPT_EULA=Y" -e "SA_PASSWORD=Password_01!" -p 1433:1433 --name sql1 -d microsoft/mssql-server-linux:2017-latest the container status is UP trying to connect docker exec -it sql1 /opt/mssql-tools/bin/sqlcmd -S…
pinale
  • 2,060
  • 6
  • 38
  • 72
1
2