Correct,

I was creating my template that way but when tried to tie it to my SQL2012 database, it wouldn't save the template for me to use it when I got in the next time. I always have to manually set it up.

I am thinking maybe I can't save it because I don't have SQL2012 client utilities on my machine. I only have the 2008r2 but I can use 2008r2 to access 2012 database and query it.