Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1798
  • Last Modified:

ODBC Connections using RemoteApp

Hi

   I have a window server 2008 standard with terminal services roles installed, and i have added a remoteApp program from TS RemoteApp Manager, and then to add RemoteApp program -< create .rdp files to a shared folder, remote desktop user to click on the .rdp file to run the application from the terminal server,  below is the issue

i have added a remoteApp program, a front end application , at the back it has MS sql 2008 as back end database, with ODBC connected, at first remote user will be able to connect to the application by clicking .rdp files, but when it reachs to database, the ODBC error pop up, and then i added another remoteApp program "ODBC" on it, and again save it to a shared folder on terminal server, remote user click in the .rdp file for ODBC, and configure the ODBC inside, this time i can run the application with no problem with the ODBC, is it a must to manually create a .rdp files for ODBC in order to make the front end application work ?

and when remote user trying to gerenate report, there is no response, it looks like that it can not gerenate data from database, but there is no problem at all when i work physically on the server with the application,  just wonder do i need to add another .rdp as well for this issue ?  

also remote desktop user want to use the printer on their local computer, when they are using the application via terminal server, when they click on print button, the printer only show from the server, not the printer on user's computer, is there any chance user can print out from their local printer instead ? Hope anyone can help with my problem , Thx

Keith
0
piaakit
Asked:
piaakit
  • 3
  • 2
2 Solutions
 
marek1712Commented:
- redistribute ODBC connection through Group Policy Preferences. You'll be able to use your application without problems.
- if the client connects from the domain workstation - you can add local printer port pointing to his device. Another way - force them to use remote desktop printing or enable printer capturing in the RemoteApp properties.
0
 
piaakitAuthor Commented:
where do i need change from GPO ? now i need to adding another remoteApp ODBC from terminal server, and remote user click on ODBC .rdp file to setup ODBC, n it works, to aviod to do this, i can modify GPO to do that ?

how do i add local printer port pointing to user device ?
0
 
marek1712Commented:
ODBC in GPP by PeteNetLive: LINK
RDP Easy Print: LINK

Adding sahred printer as a local port may be a hassle if you have more than a few, as you have to add a port for each one of them.
0
 
piaakitAuthor Commented:
how do i change login id if i,m using a remoteapp .rdp file in computer A, once i have login with peter when clicking in a remoteapp, and i can not switch other user to login to this computer


and i have this digital certificate, vaild unitl 2023, how do i publish to remote user ? the current one remote user install is valid until oct 2013,

cert

valid until oct 2013
cert2
0
 
marek1712Commented:
There's, also in the GPMC, snap-in that will let you install the certificate for every account.
More information: HERE.
0

Featured Post

Simplify Active Directory Administration

Administration of Active Directory does not have to be hard.  Too often what should be a simple task is made more difficult than it needs to be.The solution?  Hyena from SystemTools Software.  With ease-of-use as well as powerful importing and bulk updating capabilities.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now