Follow dba-ninja.com

Subscribe to RSS feed  Follow @jackvamvas - Twitter

*Use the Comments section for questions

dba-ninja.com Links

Dba_db2_button

Sqlserver_dba_button

AWS SCT Global settings - Cannot add Windows Authentication Library

02 February,2023 by Rambler

Question: Since AWS SCT Build 670 - it's not possible to apply the Windows Authentication Library through the Global Settings tab. How can I access the Authentication Library ?

Answser: There are 2 options  

 

Option 1 -  Check the value  associated with mssql_auth_file   variable in  the in the settings.xml file . Even though the value doesn't appear in the Global Settings Windows Authentication will work.

<setting key="mssql_auth_file" value="C:\tools\Microsoft JDBC Driver 7.2 for SQL Server\sqljdbc_7.2\enu\auth\x64\sqljdbc_auth.dll"/>

once the value is applied on the correct settings.xml , restart AWS SCT and the Windows Authentication will work 

Option 2 - If the mssql_auth_file   variable value is not in place , when you go to Add Source - SQL Server and try and configure for a Windows Authentication the File choice option will appear. Choose the file . This will add the value toe the Settings file and then it will be referenced for future requests , 

 

Sct_windows_authentication_library

 

 

Longer term AWS SCT is being integrated through the  AWS DMS tool - read more - AWS DMS Schema Conversion announcement


Author: Rambler (http://www.dba-ninja.com)


Share:

Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Working...
Your comment could not be posted. Error type:
Your comment has been posted. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.

Working...

Post a comment on AWS SCT Global settings - Cannot add Windows Authentication Library


dba-ninja.com