Connect SQL Server from Linux Client using Windows Authentication is supported. Here are the Prerequisites. 1.As Kerberos is the only one supported, the Kerberos authentication needs to… Read more “Connect SQL Server from Linux Client using Windows Authentication and troubleshoot steps”
Category: SQLlinux
An example of SQL Linux Windows Authentication configuration using Managed Service Accounts
Environment === Domain:contoso.com Linux server:red1(Redhat 7.6) MSA:msa01 SQL Server 2017 CU17 Red1 has joined the domain contoso.com(For information on how to join an active directory domain, see… Read more “An example of SQL Linux Windows Authentication configuration using Managed Service Accounts”
An example of Polybase for Oracle(TSQL)
Here is the topology of the environment SQL Server Oracle SQL Server 2019 RTM Oracle 11g Platform:Windows 2016 IP:192.168.1.31 Port:1521 SQL 2019 RTM does not support versions… Read more “An example of Polybase for Oracle(TSQL)”
Use Azure Data Studio to create external table for Oracle server.
Use T-SQL to create external tables for Oracle is cumbersome and error-prone. You may refer the article if you are interested. Today I’m going to show you… Read more “Use Azure Data Studio to create external table for Oracle server.”
Process ID and application name are NULL when you connect SQL Server in Linux
When you run DMV sys.dm_exec_sessions , sys.sysprocesses to check the process id/application, these DMVs return NULL. This is a bug that has been fixed in ODBC 17.4.2.… Read more “Process ID and application name are NULL when you connect SQL Server in Linux”
Use KTPASS instead of adden to configure mssql.keytab
There is a known issue with the krb5 library that is shipped on RHEL(7.3, 7.4, 7.5, or 7.6) and Ubuntu(16.04) where AES keys are incorrectly salted on… Read more “Use KTPASS instead of adden to configure mssql.keytab”
Error 15404 ‘Could not obtain information about Windows NT group/user ‘%ls’, error code 0x80090304′
Your SQL Linux has been joined to domain and you can connect to the SQL Server instance using Windows Authentication. The connection itself is fine, but when… Read more “Error 15404 ‘Could not obtain information about Windows NT group/user ‘%ls’, error code 0x80090304′”
SQL Server 