You would need to configure the jTDS driver in your userRepositoryJdbc.properties and rdsJdbc.properties to use NTLM.
http://jtds.sourceforge.net/faq.html
Just for total clarity, the property files that Mike mentions are only relevant when you're using SQL Server as the Presto Repository. If the Mashup Server is up, you can also update this configuration directly in the Admin Console (in the GUI), when you configure the URL to connect to the Presto Repository.
If you're using SQL Server for database mashables, simply make sure you add the necessary properties to the URL for the datasource, again in the Admin Console.
Sara, technical writer/jackbe
I can't test this as I don't have an appropriate environment . My understanding of the link that Mike gave you (see http://jtds.sourceforge.net/faq.html#urlFormat) for the JTDS driver was that you could pass the Windows domain in the URL to connect to the database and if you did, that JTDS would use NTLM for authentication. The URL format is (quoting from the JTDS site):
jdbc:jtds:<server_type>://<server>[:<port>][/<database>][;<property>=<value>[;...]]
and one of the property names is "domain" , so my best suggestion is to define a datasource for your SQL Server in the Admin Console. In this screen, enter the URL to your SQL Server with ";domain=<your NT domain name here>" at the end. Then specify the user name/password in the fields provided.
Test this and please let us know if this works -- or if it doesn't.
Sara, technical writer/jackbe
How do you make a Windows Authentication or NTLM connection? Do you alwaays have to have SQL Server authentication?
Thanks,.