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.
I've moved this post to Server Administration , where your question would probably get more replies.
Here are some articles for your reference.
Impersonation Requirements is quite important.
Please check which meets your situation.