Ever wanted to be able to access a client’s backend data source using Windows Authentication, but your machine wasn’t a member of their domain?
For example – you might be working with a client that can’t provide you with a client machine that has Excel or InfoPath, but you need to access data in SQL.
The usual problem I’ve run into is this – If I’m using my local Excel or InfoPath client, when attempting to add a new data connection, you get prompted with a screen such as that below. Selecting Windows Authentication will use your local machine credentials and won’t work. The Username and Password box as we all know are for SQL authentication.