Devart Forums

is there any option to support sspi based authentication ?

No, there is no option to support Security Service Provider Interface.

Are there any plans to build in SSPI support?

We will investigate the possibility of implementing this feature in dotConnect for PostgreSQL and notify you about the results as soon as possible.

It has been in available in PostgreSQL for a long time, it sure would be nice to be able to use this feature.

I too would like to be notified if and when this feature were to become available.

Thanks

Patrick

We will post about the results of our investigation in this thread.

As a licensed Devart User, my company need to know the plans for supporting SSPI in the Devart dotConnect for PostgresSQL. This has been a feature of PostgresSQL for a couple of years and pgAdmin has support for it. Npgsql was it implemented in there Open Source .NET Data Provider. Looking at the open source for it, it seem to be pretty easy to implement.

Can Devart provide a clear answer and direction on this feature? I have a 2 weeks to make my decision of leaving Devart and going to Npgsql to meet my company requirements.

Thanks,

Charlie J.

cjbiggs, please contact us and give us your e-mail you have used during product registration. We will send you a test build with this feature. Could you please test it in your environment?

Thanks. The registered user email for my company is [email protected] We will test the build as soon as we get it.

Thanks,

Charlile J.

Have the test build for SSPI been sent so I can test the fix in my environment.

Thanks,

Charlie J.

We have sent our test assemblies to you. Please notify us about the results.

Hi,

Sorry but we have not received the test build for the SSPI. Can you please send it to [email protected] We are all setup and ready to test it out today.


Thanks,

Charlie J. Biggs

cjbiggs wrote: Can you please send it to [email protected]

Done.

Is there a specific version of dotConnect for PostgresSQL I need to have installed to get the assemblies that was emailed to me? I have dotConnect for PostgresSQL 5.30.172 installed. Plus I am using Entity Framework and DBProviderFactory to connect. Are there any issues with using Entity Framework and DBProviderFactory with the special build for SSPI?

Thanks,

Charlie J.

Please uninstall your current version of dotConnect for PostgreSQL and add the references into your project to the assemblies (Devart.Data.dll and Devart.Data.PostgreSql.dll) which we have sent to you. They are the test assemblies and can be used only for opening connection to the server (no other operations). If you confirm that the SSPI connection works, we will add the feature to the next public build of dotConnect for PostgreSQL.