Integrated Windows authentication provides a seamless and secure method for users to connect to systems and applications using their existing Windows account credentials. This single sign-on functionality eliminates the need for users to remember or enter separate login information, improving convenience and reducing the risk of password-related security breaches.
By leveraging the user’s established Windows identity, integrated authentication simplifies the login process and ensures consistent access control across the organization’s IT infrastructure. This integration between Windows and application authentication enhances user experience, boosts productivity, and strengthens overall security by centralizing identity management within the familiar Windows environment.
Walkthrough:
Create a folder >> Right click >> properties >> security >> Edit, by clicking that you can see as below.
Next click on Add, you can see as below enter the object name(name) and next Check Names you can see the user and click OK.
Download the MSSQL driver. You can download the relevant driver from https://www.microsoft.com/en-us/download
In my case I will be using the following driver version https://download.microsoft.com/download/4/c/3/4c31fbc1-62cc-4a0b-932a-b38ca31cd410/sqljdbc_9.2.1.0_enu.zip
After extracting, you can see as below.
Then unzip this driver archive. The content will look like something similar to below. From here on I will refer this directory as <Home>\enu\auth\x64
Move the integration studio to the folder created at the starting of the blog.
Open Integration studio as shift + Right click >> Run as different user
Go to Window >> Preferences
By clicking on preference, you can see as below snippet.
Next open java à installed JREs, on right side you can see Installed JREs
Now we need to configure the path so that JDBC driver can find the above dll file add the following line as shown below.
In JRE Definition Add the below path in Default VM arguments as
-Djava.library.path = <downloaded path> \sqljdbc_9.2.1.0_enu.zip\sqljdbc_9.2\enu\auth\x64
Click on Finish >> Apply and Close
Now connect to database through integration studio (i.e. data source and data service) If everything is in place the Integration studio should start without any errors. For more information, please write to [email protected].
