Stack Overflow
Stack Overflow

Questions tagged [sql-server-on-linux]

Microsoft SQL Server is a relational database management system (RDBMS). Since SQL Server 2017, there's a specific release for Linux. Use this tag specifically for SQL Server 2017 Linux editions and newer Linux editions. Do not use this tag for any SQL Server on Windows edition.

11 questions
5
votes
4 answers

How to connect SSMS to Linux SqlServer in docker container?

I have installed in my PC Docker. I have installed SQlServer for linux and instance run correctly. I need to connect to Docker instance with SSMS. In the picture you can see my personal config. For installation I have follow this…
daniele3004
  • 13,072
  • 12
  • 67
  • 75
1
vote
2 answers

cannot link other sql server from linux to a named instance

I have successfully added, linked, and queried other sql servers from linux sql server 2017, but only with the default instance name. (no instance name) I cannot connect any other specific instance named servers. (it's ok from windows sql…
jjdesign
  • 344
  • 2
  • 8
1
vote
1 answer

MSSQL Server for Linux Docker Versions

I currently have Microsoft SQL Server 2017 (CTP2.1) - 14.0.600.250 (X64) May 10 2017 12:21:23 Copyright (C) 2017 Microsoft Corporation. All rights reserved. Developer Edition (64-bit) on Linux (Ubuntu 16.04.2 LTS). Are there any earlier…
shammelburg
  • 6,974
  • 7
  • 26
  • 34
1
vote
1 answer

MS SQL Server crashing on Linux

I am running Microsoft SQL server on Ubuntu 16.04.2 LTS in QEMU VM SQL Agent installed as well. 16 GB RAM assigned, and 6 processors. SQL Upper memory limit set to 10 GB I have a single 1.2 GB database. Simple Recovery mode. Single SQL Agent job,…
Skye Bowen
  • 49
  • 7
1
vote
1 answer

Migrate to new SQL Server 2017 on linux

I have SQL CLR functions in my SQL Server 2016, if I'd migrate it to SQL Server 2017 on Linux. How to handle those functions? As I know that SQL CLR relies on .NET framework and AFAIK that .NET is not that well cross-platformed.
Eric_Zhang
  • 85
  • 5
0
votes
1 answer

Operating system error code 3(The system cannot find the path specified.) MSSQL running on linux server

I am getting the following Operating system error: code 3(The system cannot find the path specified.) The client machine is windows 10 and the MSSQL server is running on Ubuntu 20.04. The query is Declare @JSON varchar(max) SELECT…
pundip
  • 27
  • 5
0
votes
1 answer

SQL Error: Only a SQL server provider is allowed on this instance

While connected to a local sql server database, I can make queries to retrieve and write data. However, this query fails: SELECT * INTO #tmp_table FROM OPENROWSET ( 'MSDASQL' ,'Driver={Microsoft Access Text Driver…
Rutwik Kharkar
  • 45
  • 7
0
votes
0 answers

MySQL to MSSQL migration got failed result

I have 2 databases: MySQL and MsSQL. Inside of MySQL I have a lot of data, but I need to migrate this data to MsSQL. I tried to do this migration with mysqldump -u root -p --compatible=mssql --database my_db > dump.sql Then I faced an issue:…
Artsom
  • 161
  • 3
  • 11
0
votes
0 answers

How to configure SQL Server in Manjaro linux?

It's my first days in Manjaro and I am having problem with configuring SQL Server. When I enter sudo ./mssql-conf setup in lib folder of SQL Server, it says I should enter admin password. After I enter the password it says : …
Saeed Pournejad
  • 1
  • 3
0
votes
1 answer

SQL SERVER USER PERMISSION ON LINUX

I am planning to install SQL SERVER 2017 on Redhat Linux with least privilege account without using a root account. What is the linux permission I need for the account to be able to do the setup as well as the folder permission I need on the SQL…
Flock
  • 21
  • 3
0
votes
1 answer

Connect to Remote MSSQL db from Linux Docker container

I have a linux docker container built on microsoft/mssql-server-linux/ image. The container doesn't have anything at this moment, I am trying to connect to remote MSSQL db hosted on windows server somewhere. I am not sure exactly how can I do that.…
Aj1
  • 953
  • 2
  • 15
  • 42