After AD Admin added a SQL server SPN using the setspn tool, the linux server is not able to use the SPN using MS SQL Server ODBC Driver 18 with error “[HY000] [Microsoft][ODBC Driver 18 for SQL Server]SSPI Provider: Server not found in Kerberos database” I have a working kerberos based authentication to one server (dev), and I am trying
Tag: sql-server
Connection to SQL Server from Julia on Ubuntu Linux using ODBC.jl won’t connect
I have tried every permutation I can find on the web but still no luck. I know the connection is possible because it works easily from R, dbeaver, and command line sqlcmd, but I can not get it to work from Julia using ODBC.jl However in Julia 1.7.0 I just get this error: I think it might have something to
.Net Web app SQL Server Connection String Linux Issue
I am having issues with a SQL Server connection string that is being used by a .net core App that is deployed on a Linux environment. The .net core app needs to access a sql server on a different server. My connection string I am using is as follows It works fine when i run locally on my windows pc
Linux bash script: How can I detect an error on a RESTORE DATABASE query on msssql-server?
Syncing a windows app with a linux website, I use a bash script which transfers each day a MS-SQL database from a Windows machine to a Linux installation, and uploads it to the mssql-server with the code below: Most of the times this line works perfectly. But there are instances in which restoration fails with an error like the following:
Why is ODBC Driver 17 for SQL Server converting strings to dates automatically and how can I stop this?
I’m moving an app that was previously running on windows 10 to a docker container with python3.6 linux base image. One of the necessary changes was changing the driver used in sql connection string from “SQL Server” to ODBC Driver 17 for SQL Server, because I have to use unixodbc-dev. I installed msodbcsql17 and mssql-tools via my Dockerfile, and I
How can I install MSSQL Server in a Python Docker image?
I want to install MSSQL Server in a Python docker container to be able to run unit tests in a CI pipeline. The problem is that the installation keeps failing. How can I fix it? What I’ve tried This gives: Try 2 gives Answer The second example should be: Microsoft doesn’t document it anywhere, but this image contains two users
Upgrading SQL Server edition on Linux with a Server/CAL license. How does the license verification works?
I recently purchased a SQL Server 2019 Standard Edition – Server/CAL license which I want to use to upgrade my current installation of SQL Server 2019 Express on a CentOS 7 system. According to the FAQ I just need to re-run the mssql-conf configuration script and change the edition to Standard. It says the setup won’t ask me for the
Unable to bind mount a Windows folder in a Linux SQL Server docker image
I’m trying to run the docker image mcr.microsoft.com/mssql/server:2019-latest on a windows host. When running this command line, everything works fine: When I try to bind mount the /var/opt/mssql/data folder to access it’s content from my windows host, I get the following error: It looks like this issue: https://support.microsoft.com/en-us/help/4212960/fix-sql-server-2017-won-t-start-with-linux-container-image-on-docker Which is supposed to be fixed. But I tried with several version
How do I install a SQL Server Java driver into a linux docker container?
The docker image definition below does not contain according to the documentation a SQL Server driver. How can I install it? Documentation: https://github.com/camunda/docker-camunda-bpm-platform Docker File Answer I was able to make it work after several days. Steps Download JDBC Driver from Microsoft Site, Version 7.2, it will include 2 JAR FILES Uncompress, and copy the file into your docker folder
Getting the sql server default backup folder on Linux with T-SQL
For SQL Server on Windows for getting default backup folder we can use master.dbo.xp_instance_regread: But for Linux it does not work. Can anyone help with T-SQL approach (I only find SSMS solution here)? Answer I’ve never found a non-registry way to get the backup directory reliably in t-sql. I usually just do a replace of /data/ to /backup/ since at