Trying to connect through rds box to sql environment. the front end works on the sql2012 and maps using access as a front end. The machines are both of the domain and are using windows authentication.
Odbc works locally on the sql box but not through the rds 2012. What do i need on the rds box to complete the connection? Full sql version pointing to the sql 2012 instance? Just sql manager?
I should also mention that this was converted from access db originally as well.
ps. also want to have one login for users if possible?