how to use windows authentication while creating a jdbc in server.xml

[sanket nayak]

Hi, 

can you please tell me how to use windows authentication while creating jdbc in server.xml.

Regards

Sanket

[sanket nayak]

Mike,

I already tried that but that's not working for me.

Sanket

[Mike Rathwell]

Sanket,

The only place I've run into this is for a SQL server jdbc datasource behind tomcat (not the Confluence DB which is PostgreSQL; SQL Server is another I have behind Confluence for other purposes). The "username" and "password" values didn't seem to take. I had to bake it into the url:

 url="jdbc:jtds:sqlserver://hostname:<port>;domain=<domain>;user=<username>;password=<password>"

Even if you have another DB that has its auth via AD, the same syntax may work. Hope it helps

mike