probably yes... make sure under database that user has connect permission. Right Click on database and go to permission page and make sure the user is listed there and has...

probably the user credentials you are typing are incorrect , or the user doesn't exist, or the given user doesn't have select permissions.

i was in a project in which we had the same issue but with excel.. what we did was all the sql code validation or operations that we had in...

I think there is not way to do that. it exports everything.