SQL Server : Windows authentication with Tomcat

Share on facebook
Share on twitter
Share on linkedin
Share on reddit
Share on email

By default SQL server 2008 is not enabled for remote connection

First you need to enable SQL server for remote connection to avoid the “SQL server connection refused: connect” error.

Assuming your SQLserver is enabled for windows authentication and remote connection we can proceed as below.

1. Install Tomcat as service under the desired login account.

Run the service.bat file as below

Image

Image

 

2. Once installed, go to services and add the login account

Image

 

3. Copy the ntlmauth.dll file to any directory that is in the system path. We can put it in the windows/system32 directory

This is needed for windows SSO authentication.

You can go to the infocaptor/dash/system/jtds../x64/sso directory. Choose the appropriate file based on your operating system. (e.g x86 for 32 bit and x64 for 64bit)

Image

 

4. Create connection within infocaptor

When you define a new connection to use as single signon windows authentication, leave the database user and password blank (empty)

Image

 

5. Test the connection

Now, go to infocaptor, drag a grid , right click and select data source.

Next, pick the sql_2008_sso connection and click “show tables” in the SQL tab

Image

 

Success!. The list of tables indicate that infocaptor connected to SQLserver using windows authentication.

Background: InfoCaptor connects to sqlserver via tomcat and tomcat passes the windows credentials to sql server. Make sure you create a windows service account if you decide to use this in any production environment.

Custom Reports and Dashboards

We will build you a set of custom reports and dashboards
Best Offer

The Core Tools

Create dashboard for any Database

Data Visualizer and Dashboard Application
SALE
This is the best dashboard software for its price. One good thing we did was to hire their consulting services to build few dashboard prototypes and provide some quick dashboard training.
- Terry Seal, IL
We evaluated Xcelsius and Qlikview and the cost for organization to implement dashboards was quoted over 10,000 USD. For fraction of the above quoted price, we were able to buy the licenses for the web based dashboard software and get some free training. This is truly a dashboard software for small businesses like us.
IT Manager of a Trucking company, OH