I am working on .NET6 WebApi project on Ubuntu/Windows and the connection to the SQL Server DB is configured to use windows authentication. On windows I can use this connection string Data Source=DB-Name;Initial Catalog=Cat1;Integrated Security=SSPI. On Linux, we have ruled out using Kerboros for authentication and instead, we want to find a connection string similar to jdbc:jtds:sqlserver://DBName:Port;domain=ABC_XYZ;useNTLMv2=true for java apps. Is this possible using SQL client, ODBC, OLEDB or any other supported clients for .net6? Using the JDBC connection string, I can connect to the desired databases in the Jetbrains Rider.
Connection string for SqlClient/OLEDB driver like jdbc:jtds driver?
338 Views Asked by Rohit Singh At
1
There are 1 best solutions below
Related Questions in SQL-SERVER
- SQL server not returning all rows
- Big data with spatial queries/indexing
- Conditional null constraint on Null
- SQL Query - Order by String (which contains number and chars)
- Optimising a slow running SQL Server Stored procedure ordered by calculated fields to return a closest match
- Dynamics CRM Publishing Customizations - Multi Developers
- Is there anyway to set the relationship of many tables from Model?
- Implementation of Rank and Dense Rank in MySQL
- ORM Code First versa Database First in Production
- MVC : Insert data to two tables
- Data streams in case of Merge
- table with multiple IDs but seperate notes need sorting (Tried SQL code to make a union query)
- SQL table Partitioning by Year with ColumnStore index implemented on the table
- Defining which network to use for SQL Server 2012 Management Studio
- Fill a week days in a table with preceding Sundays value
Related Questions in JDBC
- Slick query for one to optional one (zero or one) relationship
- No Suitable Driver Found For My Java Application Code
- How to grant privileges to current user
- Selecting a count from my database using Java and Netbeans
- ActiveMQ offline message transfer on database level
- Not able to update db table from one server to another server in JAVA
- How to use CachedRowSet in Google App Engine?
- Where should ? be placed in a PreparedStatement?
- How to figure out the optimal fetch size for the select query
- Microsoft SQL Server JDBC Driver -SSL issues
- Error in updating records using JDBC
- Retrieving image in a jtable
- Log4jdbc-log4j2 to log OracleTypes.CURSOR
- Cannot initialise HikariCP pooled connection, Failure in loading native library db2jcct2
- How to write an java application that takes a sql query and a number as input and fire it
Related Questions in KERBEROS
- Windows client damage authorization header (Kerberos) => IIS 400 (Bad Request)
- Configure Kerberos auth for TFS 2013
- Single Sign-On in Windows Applications using AD login
- C# RestSharp library and Kerberos authentication
- Hiveserver2 Kerberos
- Passing Kerberos ticket as parameter in SOAP web service call
- Spring security kerberos validate token error
- Hadoop Kerberos security
- Authenticate scripts on HDFS using key.tab file
- Making my own Kerberos Authentication Ticket
- Using Java 8 S4U2Proxy - A good example needed
- Connect to HBase using tunnel
- Hive Server2 ACID transactions not working
- How to specify the TGT kerberos ticket cache in beeline
- Java GSSAPI Credentials with Active Directory
Related Questions in .NET-6.0
- Error when tring to retrieve AuthorizationGroups from Active Directory
- Data protection still works after deleting all keys from the database
- Digital Ocean server is slowed and uses high CPU
- Different Bytes Received under windows and linux when running same .NET 6 application connected to SQL Server
- NETStandard.Library 2.0.3 vs. System.Net.Http 4.3.4 - What should be prefered?
- SignalR. An HTTP/2 connection could not be established
- How to set NeutralResourcesLanguageAttribute in my .NET Core project?
- Run .Net 6 Windows Forms app as a windows service
- How to work with .net 6 web api , where shared business logic across multiple apis/contorllers?
- RabbitMq bus.Publish method fails and not throwing any exception
- How force webapi to listen only HTTPS when host on IIS
- javascript files bundle cashing problem in with .net6
- I'm creating a Xaf application using Devexpress. I am using both windows and blazor. My code works in Windows app but not in Blazor app
- Validate Nullable Enum Values using Fluent Validation
- Process dead letter message in Azure Service Bus Mass Transit
Related Questions in SYSTEM.DATA.SQLCLIENT
- Different Bytes Received under windows and linux when running same .NET 6 application connected to SQL Server
- Could not load type 'SqlGuidCaster' from assembly 'Microsoft.Data.SqlClient, Version=5.0.0.0, Culture=neutral, PublicKeyToken=23ec7fc2d6eaa4a5'
- encrypt=strict key did not work with System.Data.SqlClient to established TLS 1.3 connection
- System.Data.SqlClient.SqlException: 'Invalid column name 'P1000'.'
- Trying to insert SQL row from C#, throws exception: 'System.Data.SqlClient.SqlException'
- "sni.dll" not found while using System.Data.SqlClient using Azure C#
- System.Data.SqlClient.SqlException: 'Incorrect syntax near ')'.' / cmd.ExecuteNonQuery()
- System.Data.SqlClient packagereference does not flow between project references
- Serilog WPF based app works but not when installed as an EXE
- Violation of PRIMARY KEY constraint 'PK_SES'. Cannot insert duplicate key in object 'dbo.SES'. The duplicate key value is (456785)
- Exception thrown: 'System.Data.SqlClient.SqlException' in System.Data.SqlClient.dll
- in T-SQL which error severity level, if any, lets the statement continue but causes SqlClient library to display a message
- Can SQL Server return an informational message to .NET System.Data.SqlClient program in contexts that do not involve any error
- I can’t connect to my database using SqlConnection
- Connection string for SqlClient/OLEDB driver like jdbc:jtds driver?
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
The .Net SqlClient does not support NTLM with provided credentials, there's a tracking issue here. Only Kerberos, SQL Auth, and (for Azure SQL) AAD auth.
JDBC is the only Microsoft driver that supports NTLM on Linux.