Return
-
Title
Unable to map tables from a Microsoft SQL Database in TIC using Windows Integrated authentication -
Description
If user selects 'Users can access this data source with this shared authentication' with 'Use Windows integrated security'
During mapping table, will encounter Data Validation Error with message : ‘A user name must be entered’. But user will not be able to enter username and password as the field are both disabled.
-
Cause
TIC currently only has limited support for SQL Server “Windows Integrated Security” authentication option. -
Resolution
- Right click on the SQL datasource. Click 'Show Properties...'
- Uncheck 'Use Windows integrated security'.
- Provide the Username and Password.
- Click 'Ok'