31 questions
0 votes
0 answers
269 views
Can't get MSDTC to work from Windows 11 client to SQL Server running on Linux 2022 Server
According to the documentation, it should "just work," but it doesn't. I have a newly built Ubuntu 22.04 minimal server with SQL Server for Linux 2022 installed. I followed the instructions ...
1 vote
1 answer
290 views
Request for the permission of type 'System.Net.WebPermission, System, Version=4.0.0.0,' failed. in SQLCLR UDF in SQL Server on Linux 2019
I have created a SQLCLR UDF and am deploying it (using SSDT) to SQL Server 2019 on Linux. When I try to execute the function it returns the following error: Request for the permission of type 'System....
0 votes
1 answer
1k views
Add Providers to Linux SQL Server 2019
I want add a new linked server in my SQL Server (15.0.4261.1) running on Linux Red Hat Enterprise 8.6, before I add a linked server to other SQL Server database, but now when I want add a linked ...
0 votes
0 answers
868 views
Docker SQL Server image getting large with each docker commit
I have a docker SQL Server image that I configure and then share with team. Each time I update the data the image size increases significantly. I start with the mcr.microsoft.com/mssql/server:2019-...
0 votes
1 answer
897 views
SQL Server 2019 on Linux Time Zone Problem
Why there are different results (offset should be +03:00): SELECT CURRENT_TIMEZONE() as [CURRENT_TIMEZONE()] , SYSDATETIMEOFFSET() as [SYSDATETIMEOFFSET()]; result is : CURRENT_TIMEZONE() ...
0 votes
0 answers
161 views
SQL Server-Python Permission issue on data export using Python in SQL Server
Returns error below command using SQL Server Management Studio and SQL Server is running on Ubuntu 18.04. EXEC sp_execute_external_script @language = N'Python', @script = N'import pandas as pd ...
0 votes
0 answers
443 views
WAITFOR Delay/Time not working properly in Windows Docker (SQL Server Linux)
The time specified in the waitfor delay is not honored in SQL Server Linux on Docker Desktop for Windows. Script: declare @tsstart varchar(100) = CONVERT (VARCHAR(100) , SYSDATETIME() ,121); raiserror(...
5 votes
2 answers
2k views
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 ...
7 votes
1 answer
2k views
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 ...
1 vote
0 answers
411 views
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 ...
1 vote
1 answer
2k views
'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 ...
0 votes
2 answers
1k views
Is there a way to import data from an SQL file to Microsoft SQL Server Express Edition on Linux?
Ok, so I have a .sql file that i exported from MySQL Workbench and now I want to import it into Microsoft SQL Server Express Edition for linux, and I'm not sure how I should go about doing that, any ...
-1 votes
1 answer
849 views
SQL 2017 Linux ag resource not failing over with pacemaker
We've setup a sql2017 cluster on linux following MS Documentation. Replication in the AG works fine but we are unable to failover. If I watch the logs during failover pacemaker is attempting to move ...
0 votes
0 answers
3k views
SA default password SQL Server on Linux
I installed SQL Server 2017 on Linux on a CentOS 7 derivate. Now I want to login with the command: "sqlcmd -S 172.0.0.1 -U SA". But I never set up a password. How am I able to login to the SQL Server? ...
2 votes
1 answer
726 views
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 ...