Re: Accessing MS SQLServer from VMS in a JVM language

On 8/26/24 7:44 PM, Arne Vajhøj wrote:

This is surprisingly easy:

No surprise.  It was easy with jTDS 15-20 years ago, but I think that
driver is deprecated now.

1) enable SQLServer authentication (Windows authentication only will not work)

It might be possible using pure-Java Kerberos, but getting that working
sounds like work:
https://learn.microsoft.com/en-us/sql/connect/jdbc/using-kerberos-integrated-authentication-to-connect-to-sql-server?view=sql-server-ver16

2) download official Microsoft JDBC driver and transfer it to VMS
3) make sure TCP port 1433 is open in various firewalls
 And voila - access from Java, Groovy, Kotlin, Scala and more
exotic JVM languages.