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
Can I connect with Windows Authentication Mode
-
- Posts: 12
- Joined: Fri 27 Aug 2010 18:24
-
- Devart Team
- Posts: 2420
- Joined: Wed 02 Nov 2011 09:44
Re: Can I connect with Windows Authentication Mode
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:
For more information, please refer to https://msdn.microsoft.com/en-us/librar ... 10%29.aspx
Code: Select all
"provider=SQL Server;Server=<SERVER>;Integrated security=true"
-
- Posts: 12
- Joined: Fri 27 Aug 2010 18:24
Re: Can I connect with Windows Authentication Mode
Thanks alot.
One more question.
What DLL's do I need to deploy for using SQLServer ?
Thanks and regards
Uwe
One more question.
What DLL's do I need to deploy for using SQLServer ?
Thanks and regards
Uwe
-
- Devart Team
- Posts: 2420
- Joined: Wed 02 Nov 2011 09:44
Re: Can I connect with Windows Authentication Mode
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
https://www.devart.com/dotconnect/unive ... yment.html
https://www.devart.com/dotconnect/unive ... nsing.html