I solved the problem by going to impersonation tab of my data source and providing my windows login username and password.