1. Windows Authentication 2. Mixed Authentication
Mixed Authentication is very much like the apples available in the Progress DataDirect kitchen in Morrisville, NC. Sometimes they’re good, and sometimes they’re risky.
Microsoft strongly recommends the default mode, Windows Authentication, when possible. This is consistent with conversations I have had with DBAs and Application Teams that consider Mixed Authentication to be a security risk. Many of the conversations are with the Federal Government and Universities; and it's comforting to know they do not compromise when it comes to security. And this is when Progress DataDirect gets engaged since we have the best in class security features (both data encryption and authentication) across our full suite of data access solutions.
One of the reasons application teams are still using SQL Server Authentication is to support ODBC or JDBC drivers that do not support Windows Authentication. And these drivers are connecting critical applications such as Informatica, DataStage, SAS, DG4ODBC, IBM Cognos, Ab Initio, etc., running on AIX, Solaris, HP-UX, Linux servers. And if you are using SQL Server Authentication, it's quite possible your DBA is holding a major grudge against you and your application team. To get back on the DBA's good side, I recommend the following solutions to connect applications to SQL Server using Windows Authentication:
Technology researcher, thought leader and speaker working to enable enterprises to rapidly adopt new technologies that are adaptive, connected and cognitive. Sumit has been working in the data access infrastructure field for over 10 years servicing web/mobile developers, data engineers and data scientists. His primary areas of focus include cross platform app development, serverless architectures, and hybrid enterprise data management that supports open standards such as ODBC, JDBC, ADO.NET, GraphQL, OData/REST. He has presented dozens of technology sessions at conferences such as Dreamforce, Oracle OpenWorld, Strata Hadoop World, API World, Microstrategy World, MongoDB World, etc.
Let our experts teach you how to use Sitefinity's best-in-class features to deliver compelling digital experiences.Learn More
Subscribe to get all the news, info and tutorials you need to build better business apps and sites
You can also ask us not to share your Personal Information to third parties here: Do Not Sell or Share My Info
We see that you have already chosen to receive marketing materials from us. If you wish to change this at any time you may do so by clicking here.
Thank you for your continued interest in Progress. Based on either your previous activity on our websites or our ongoing relationship, we will keep you updated on our products, solutions, services, company news and events. If you decide that you want to be removed from our mailing lists at any time, you can change your contact preferences by clicking here.