MS SQL: Let Ebase use Windows authentication

[Vircos]

Our new MS SQL-cluster uses Windows authentication instead of SQL authentication.

Does anyone know if it is possible to let Ebase server authenticate itself with Windows authentication at the MS SQL server?

[Ben]

Are you using the jTDS JDBC driver?

If so there's a paragraph in the jTDS faq about it. http://jtds.sourceforge.net/faq.html

In addition to the user and password properties, it looks like you also need to provide a value for 'domain'.

[Vircos]

Whaaa, why didn't I noticed that.
Many thanks to you, Ben.

This seems to be the solution. I will test this later this week.

[Vircos]

It is almost the solution.

You have to add the property domain with the corresponding value tot the JDBC URL.

For the UFSrepository you can add the domain property to the SQL JDBC datasource in the file ../UfsServer/tomcat/conf/Catalina/localhost/ufs.xml

In my case we have a second SQL JDBC datasource in the file ufs.xml.
This datasource calls a database named UFSDATA. We have also added this database to the databases in Ebase designer with JDBC driver type 2. When we test the database connection within Ebase designer it says that all is working fine. But when we actually start a form that uses the UFSDATA database we get a SQL error (user unknown).