Can I connect with Windows Authentication Mode

Can I connect with Windows Authentication Mode

Postby magixxfactory » Fri 11 Mar 2016 12:20

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
magixxfactory
 
Posts: 11
Joined: Fri 27 Aug 2010 18:24

Re: Can I connect with Windows Authentication Mode

Postby Pinturiccio » Fri 11 Mar 2016 15:27

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/library/system.data.sqlclient.sqlconnection.connectionstring%28v=vs.110%29.aspx
Pinturiccio
Devart Team
 
Posts: 1978
Joined: Wed 02 Nov 2011 09:44

Re: Can I connect with Windows Authentication Mode

Postby magixxfactory » Tue 15 Mar 2016 15:13

Thanks alot.
One more question.

What DLL's do I need to deploy for using SQLServer ?
Thanks and regards
Uwe
magixxfactory
 
Posts: 11
Joined: Fri 27 Aug 2010 18:24

Re: Can I connect with Windows Authentication Mode

Postby Pinturiccio » Wed 16 Mar 2016 15:33

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/universal/docs/?Deployment.html
https://www.devart.com/dotconnect/universal/docs/?Licensing.html
Pinturiccio
Devart Team
 
Posts: 1978
Joined: Wed 02 Nov 2011 09:44


Return to dotConnect Universal