All Questions
Tagged with sql-server-2017 linux
40 questions
10
votes
2
answers
2k
views
Is it possible to restore a SQL Server Linux Backup on SQL Server Windows
I am running SQL Server in docker on a mac. I have taken a SQL Server backup from windows and restored it in the mac SQL Server docker instance. Now I want to take a backup from the SQL Server docker ...
- 333
0
votes
1
answer
69
views
SQL Server 2017 on RHEL Linux with IDM for AD authentication
We are using Red Hat IDM to authenticate AD users to SQL Server. Users can login successfully to SQL Server with SSMS and SQL CMD with AD Authentication. But running some elevated commands from SSMS ...
0
votes
0
answers
1k
views
Setup certification for SQL Server running on Debian
I have successfully setup an instance of a SQL Server 2017 instance on the latest Debian release, and a domain that points to that server, and I have gotten the respective certificates by using ...
- 166
0
votes
1
answer
1k
views
Unable to attach SQL Server database with shared folder in docker on Linux
The problem I'm having is that my SQL Server 2017 Linux container is not able to read my database files. I guess it has something to do with permissions and I'm sure I've overlooked something but I ...
- 366
3
votes
1
answer
495
views
Solution for the deletion of old Database Backups for Linux SQL Server 2017 after Backups created with Ola Hallengren scripts?
I have a problem when I want to delete older backups, I've created with Ola Halengreen scripts.
USE Maintenance
EXECUTE dbo.DatabaseBackup
@Databases = 'USER_DATABASES',
@Directory ='/mssql/backup/'...
- 31
6
votes
1
answer
491
views
Permissions issue in Docker SQL Server 2017 while restoring certificate
Docker SQL Server 2017 container @latest. Using master database.
The error I am facing is the following:
[S00019][15208] The certificate, asymmetric key, or private key file is not valid or does not ...
- 123
0
votes
2
answers
303
views
Issue migrating from SQL Server 2008 R2 to SQL Server 2017 Standard (on Linux)
I am currently trying to carry out a database migration from SQL Server 2008 to SQL Server 2017 (Linux) using the DMA tool.
I get the all green after running the assessment, however I get hit with ...
- 11
3
votes
1
answer
373
views
How to lock a MSSQL (2017 Linux) account after N unsuccessful login attempts
I have to configure account lock after N unsuccessful login attempts on MSSQL 2017 Linux. That is standalone server and is not in AD.
I couln'd find any valuable information so far unfortunately. ...
- 31
-1
votes
1
answer
6k
views
Restore database - Operating system error 5(Access is denied.) on Linux
I try to restore SQL Server 2017 Express database using sqlcmd tool on Ubuntu 16 Server.
My SQL command is:
RESTORE DATABASE [xxxxx] FROM DISK = N'/home/xxxxxx/DBBackups/xxxx.bak' WITH NORECOVERY, ...
- 101
3
votes
1
answer
7k
views
How to format the output of SQL queries on SQLCMD for SQL Server 2017 on RHEL Linux 7.3?
I have installed SQL Server 2017 on RHEL Linux 7.3, and using SQLCMD utility for querying the SQL Server.
When I try to query for example: 'SELECT * FROM SYS.DATABASES'. I get output like the ...
- 397
3
votes
2
answers
14k
views
Unable to join secondary replica to the availability group by SQL Server error 47106
We were trying to create availability group with 3 synchronous replicas, where we couldn't give the names specified in /etc/hosts as node specifiers in the create availability group in the primary ...
- 61
4
votes
1
answer
545
views
Why is my database restore being aborted?
I'm trying to restore a SQL Server 2016 database into a SQL Server 2017 docker instance (microsoft/mssql-server-linux:latest). The process seems to be:
Create docker container: docker run -e ‘...
- 143
2
votes
0
answers
335
views
SQL Server 2017 Failover Cluster on RHEL Linux
I am trying to create Failover Cluster on SQL Server 2017 on RHEL 7.3 Linux, following this document from Microsoft:
https://learn.microsoft.com/en-us/sql/linux/sql-server-linux-shared-disk-cluster-...
- 397
1
vote
1
answer
480
views
SQLServer Linux: Error restoring backup of DB from Windows w/ full-text data file
I'm trying to move a Windows SQL Server database from Windows 10 to Linux.
For this, I'm following the instructions in
https://learn.microsoft.com/es-es/sql/linux/sql-server-linux-migrate-restore-...
user155183
2
votes
1
answer
164
views
How to ensure security with SQL Server Restore
I'm building a shared hosting SQL Server tool for linux, where users only receive access to their own database, with a SQL Login and SQL Database User that has db_datareader, db_datawriter and ...
- 131
2
votes
1
answer
3k
views
SQL Server 2017 on Linux: SSMS connection attempt throws error 10054
I have just installed SQL Server 2017 on a Linux machine, when I connect locally it is working. But on trying to connect from SSMS it says:
Error 10054: A connection was successfully established ...
- 29
1
vote
1
answer
495
views
Machine login for Microsoft SQL Server for Linux
-- old question --
I'm building a multi-tenant SQL Server for Linux solution for hosting companies. Basically end-users will get access to SQL server with their own user account.
Now, I want to be ...
- 131
1
vote
1
answer
981
views
SQL Server crash with Reason 0x00000006 after a while on linux
Environment
OS
Ubuntu 16.04 x86_64 (also happening on Windows)
DB
SQL Server 2017 with FullText Search module (mssql-server and mssql-server-fts packages)
Problem
The issue that I'm facing is ...
- 121
1
vote
1
answer
342
views
Stack trace in SQL Server for Linux
Does somebody know what´s the reason of this stacktrace?
Microsoft SQL Server 2017 (RTM-CU3-GDR) (KB4052987) - 14.0.3015.40 (X64)
Dec 22 2017 16:13:22
Copyright (C) 2017 Microsoft Corporation
...
1
vote
0
answers
906
views
LDAP Authentication - SQL Server 2017 on Linux
We have installed SQL Server 2017 on Linux server. I am able to connect SQL Server locally as well remotely but with local user access.
I have my AD account created and have AD server information. ...
- 11
4
votes
0
answers
4k
views
Getting: Possible index corruption detected. Run DBCC CHECKDB
When I connect to the database and run a command on some catalogs, I get Msg 9100, Level 23
1> SELECT * FROM sys.databases;
2> GO
Msg 9100, Level 23, State 2, Server x230, Line 1
Possible index ...
- 64.7k
3
votes
1
answer
6k
views
Installing SQL Server 2017, I get E: Unable to locate package mssql-server
I'm using Ubuntu 17.10, but after adding the Microsoft repo for 17.10
sudo add-apt-repository "$(curl https://packages.microsoft.com/config/ubuntu/$(lsb_release -sr)/prod.list)"
and trying to ...
- 64.7k
11
votes
1
answer
3k
views
bcp command Incorrect syntax near '�'. Character is actually: "ä"
I have mssql-server and mssql-tools installed on Ubuntu (Linux). When I try to export data with the bcp command using the following command-line:
bcp DBname.dbo.Täble_Name out Täble_Name -c -k -...
- 113
2
votes
1
answer
4k
views
Can I get shell access through SQL Server 2017 on Linux?
There is a stored proc called xp_cmdshell that is supposed to give you shell access on SQL Server, to the server. I am wondering if that works on Linux?
- 64.7k
2
votes
3
answers
3k
views
Why does sqlcmd truncate varbinary(max)?
Inside of the sys.assembly_files catalog, I can see a field named content
1> SELECT assembly_id, LEFT(name, 50), file_id, content FROM sys.assembly_files;
2> GO
assembly_id ...
- 64.7k
2
votes
1
answer
564
views
What differences are there with SQL Server 2017's packaging of `Binn` on Linux and Windows?
Knowing that the Binn is packaged differently on Windows and Linux, I'm wondering what differences there are between the two? Do they come with different utilities? On Linux Binn is distributed in a ...
- 64.7k
5
votes
1
answer
482
views
On SQL Server 2017 (Linux), where is the Resource Database persisted (located on disk)?
In my default install of SQL Server 2017 on Linux, under /var/opt/mssql/data I see the following databases,
master.mdf - master Database - Records all the system-level information for an instance of ...
- 64.7k
7
votes
2
answers
16k
views
How do you directly modify the system catalogs in SQL Server 2017?
NOTE: I understand the risks involved, and the possibility of destroying a production system by doing this. I'm interested in doing it anyway.
Whenever I try to play with system catalogs, I gets ...
- 64.7k
2
votes
2
answers
9k
views
Where does SQL Server store the SA password and SQL Server password policy?
On Linux, where does SQL Server store the "SQL Server password policy" and the SA user's password? I get it, "password" isn't secure.
ERROR: Unable to set system administrator password: Password ...
- 64.7k
4
votes
2
answers
7k
views
How do I reset the SQL Server password on Linux?
The instructions on technet say that I either have to reset the SQL Server configuration with mssql-conf setup or run a proc which I can not run because I do not have access.
What the simplest way to ...
- 64.7k
0
votes
1
answer
814
views
SQL Server's `mssql-conf setup`, error Aborted sudo
When I run sudo /opt/mssql/bin/mssql-conf setup to configure SQL Server 2017 I get the following error,
/opt/mssql/lib/mssql-conf/invokesqlservr.sh: line 15: 12710 Aborted sudo -EH -u ...
- 64.7k
3
votes
2
answers
2k
views
Replication feature in SQL Server 2017 on Linux
We have a running production using SQL-Server 2014 in production. It has replication running and partial subscribers in several data centers.
I had a request to evaluate SQL Server 2017 on Linux so it ...
- 344
2
votes
0
answers
762
views
Can't install SQL SERVER 2017 on Centos 7.4 - mssql-conf setup error
I'm trying to install the lastest SQL Server 2017 on a Centos 7.4 VM (Vmware). I get the following error when I try running:
sudo /opt/mssql/bin/mssql-conf setup
using Bash shell. The error:
...
5
votes
1
answer
6k
views
SQL Server 2017 Linux CU1 - MODIFY FILE encountered operating system error 31
I have a "VMWare RHEL 7.4" machine that I have installed "SQL Server 2017 Linux CU1" and I created a "Linux Linear Volume", see steps at the bottom, when I try to restore a database backup in the "...
3
votes
2
answers
2k
views
Can I disable the spyware in SQL Server?
There are two titles for the spyware in SQL Server,
Customer Experience Improvement Program (CEIP)
Telemetry
I'm wondering how I disable them. You can see them referenced here,
My SQL Server says ...
- 64.7k
8
votes
3
answers
3k
views
What is causing this error: None of the specified replicas for availability group ag1 maps to the instance of SQL Server to which you are connected
I am configuring Always-on for SQL Server 2017 RC1 (14.0.80.90, dated 2017-7-18) for Linux as per https://learn.microsoft.com/en-us/sql/linux/sql-server-linux-availability-group-configure-ha. This ...
Erik Brandsberg
1
vote
1
answer
1k
views
How do I bypass the typing of `GO` in `sqlcmd`?
sqlcmd has this most annoying this of having to type GO after every command, how can I get around this?
SELECT 1 AS "foo"
2> GO
foo
-----------
1
(1 rows affected)
Can I make ...
- 64.7k
6
votes
2
answers
4k
views
How do I get the Query Timing with sqlcmd?
Running SQL Server 2017, using the interactive REPL client sqlcmd how do I get the time for Query Execution?
You can sp_BlitzErik showing this in his answer here,
SQL Server Execution Times:
CPU ...
- 64.7k
14
votes
1
answer
18k
views
How do I totally remove SQL Server 2017 on Ubuntu?
The docs has instructions about how to remove SQL Server. However, this leaves certain packages behind. How can I remove all traces and uninstall SQL Server 2017?
- 64.7k
1
vote
1
answer
2k
views
SQL Server on Linux: Case Sensitivity
I haven’t yet tried out SQL Server on Linux, but I have a question regarding case sensitivity.
In MySQL and Oracle (as far as I am aware) table names and database names are case insensitive on Mac &...
- 2,919