On the server I use, this was not a permissions issue. WA data assist was putting  around data fields on only certain fields. Once I put the  brackets around all fields the error disappeared. Server administrator said it was because of reserved words. Hope this helps someone else.