After installing Crystal Report in Windows Server 2003 Terminal Server, I can stand in front of the server (as administrator) AND/OR Terminal into the machine as administrator and create reports.
Once I log off my TS session, I can stand in front of the server (as administrator) and create reports BUT NOT Terminal into the machine as administrator and create reports.
When I Terminal in, I select my ODBC source, log into it, then I go to add table via Data Explorer. I see them get added, but once I close the Data explorer POOOF, the tables disappear.
I also get a "Dos error." when trying to open an already written report that uses the same ODBC source.
I have absolute full permissions to every single file on the server (and the data source server for that matter). I'm thinking that the ODBC source (a MAS server) likes me for a while, especially after I do the install, but after I log back into the server via a Terminal Session, it dislikes me for some reason.
On a side note, the ODBC connection tests good either way I go into the server.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!