Can I connect with Windows Authentication Mode

[magixxfactory]

Hello,
ist it possible to connect with Windows Authentication Mode to a SQLServer database witrh dotConnect Universal and if so - how ?
Thanks and regards
Uwe

[Pinturiccio]

dotConnect Universal support for Windows Authentication depends on the underlying provider used by dotConnect Universal. For SQL Server it uses the System.Data.SqlClient provider, which allows connecting with Windows Authentication. For this, you need to set the Integrated Security or Trusted_Connection connection string parameter to true. For example, the connection string will look like the following:

Code: Select all

"provider=SQL Server;Server=<SERVER>;Integrated security=true"

For more information, please refer to https://msdn.microsoft.com/en-us/librar ... 10%29.aspx

[magixxfactory]

Thanks alot.
One more question.

What DLL's do I need to deploy for using SQLServer ?
Thanks and regards
Uwe

[Pinturiccio]

You need to deploy Devart.Data.dll and Devart.Data.Universal.dll assemblies. If your application uses the Devart.Data.Universal.Web.dll assembly, you need to deploy it with your application too. Additionally you need to add the technical licensing resource. For more information, please refer to
https://www.devart.com/dotconnect/unive ... yment.html
https://www.devart.com/dotconnect/unive ... nsing.html