Hi there,
I tend to agree with previous answer that the issue is related to how you define the query that R should execute.
From my days using SQL server, the sql you are showing have a lot of MSSQL dialect in them. I would suggest to keep the sql simple and use only plain basic standard sql.
Try to use the query as:
select * from person
The database drivers should take care of the rest for you.
Regards,
jm