Connecting to SQL Server 2008 DB using Windows-only authentication
1 July, 2017
Updated documentation can now be found via our YF community HERE
With the JTDS driver, you can use "integrated authentication" with the SSO.dll file, which uses the currently logged in user account to connect.
There is a 32 or 64-bit dll available as part of the most recent JTDS driver, available from:
http://jtds.sourceforge.net/
- The JTDS driver also allows you to specify a Windows user by adding the "domain"parameter to the URL.
Example: Connecting with a Windows account
(within 'web.xml file located in YellowfinappserverwebappsROOTWEB-INF)[code]
JDBCDriver: net.sourceforge.jtds.jdbc.Driver
JDBCUrl: jdbc:jtds:sqlserver://localhost/master;domain=nepal
Username: steve
Password: password[/code]
In the above example,the computer's name is 'nepal'.
It was connecting to the local domain, and "steve" is a local user account that has been given access to the database.
- The Microsoft driver only allows Windows authentication using the "integrated authentication" parameter, with the dll file in the JDBC driver package from:
http://msdn.microsoft.com/en-us/sqlserver/aa937724
Once again there are 32-bit and a 64-bit .dll files, and you will need to use the appropriate one based on the JVM you are using.
Example:
(within 'web.xml file located in YellowfinappserverwebappsROOTWEB-INF)[code]
JDBCDriver: com.microsoft.sqlserver.jdbc.SQLServerDriver
JDBCUrl: jdbc:sqlserver://localhost;DatabaseName=master;integratedSecurity=true
Username:
Password: [/code]
If you have issues doing the above, please check the 'related posts' below and email 'support@Yellowfin.com.au' if you are still experiencing issues.
[size="13">Related posts:[/size]
Can YF use windows authentication?
Moved Yellowfin server
Problem with the user name and password
How do I re-encrypt my metadata database password