I have a source from Sql Server and i have taken extract with my Server and Database details and i login as "Use Windows Authentication" without any login.
And i am trying to publish the source. While publishing i couldn't see "Allow refresh access" option. And once i publish and run the extract from Server, extract is failing. Not really sure why this is happening!
Can anyone please let me know why this is different with this source.