Create Information link using windows authentication

[siddar tha]

OS: Unix

Version: 7.0.1

DB: MS SQL; Authentication: Windows

Driver: Native

When trying to create an information link using windows authentication, getting an error which says log in failed.

Changed the connection string to this format:

jdbc:tibcosoftwareinc:sqlserver://servername:1433;databaseName=dbname;AuthenticationMethod=ntlm;LoadLibraryPath=c:tibcotss7.0.0tomcatlib;

Still the same error. Can we use windows authentication and create info links I'm guessing that we can. After we create a dxp with this info link, will it have any effect on the web player user authentication

Kindly help. Thanks!

[Varma Nadimpalli]

Hello Siddarth,

Try the JDBC URL as follows

jdbc:sqlserver://example.com:1433;DatabaseName=spotfire_server;integratedSecurity=true