Solved

ODBC Connections using RemoteApp

Posted on 2013-05-23
5
1,505 Views
Last Modified: 2013-06-07
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
Comment
Question by:piaakit
  • 3
  • 2
5 Comments
 
LVL 11

Assisted Solution

by:marek1712
marek1712 earned 500 total points
ID: 39191806
- 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
 

Author Comment

by:piaakit
ID: 39194896
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
 
LVL 11

Accepted Solution

by:
marek1712 earned 500 total points
ID: 39194925
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
 

Author Comment

by:piaakit
ID: 39195215
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
 
LVL 11

Expert Comment

by:marek1712
ID: 39229671
There's, also in the GPMC, snap-in that will let you install the certificate for every account.
More information: HERE.
0

Featured Post

Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

Join & Write a Comment

Scenario:  You do full backups to a internal hard drive in either product (SBS or Server 2008).  All goes well for a very long time.  One day, backups begin to fail with a message that the disk is full.  Your disk contains many, many more backups th…
Possible fixes for Windows 7 and Windows Server 2008 updating problem. Solutions mentioned are from Microsoft themselves. I started a case with them from our Microsoft Silver Partner option to open a case and get direct support from Microsoft. If s…
This tutorial will give a an overview on how to deploy remote agents in Backup Exec 2012 to new servers. Click on the Backup Exec button in the upper left corner. From here, are global settings for the application such as connecting to a remote Back…
This tutorial will walk an individual through the steps necessary to enable the VMware\Hyper-V licensed feature of Backup Exec 2012. In addition, how to add a VMware server and configure a backup job. The first step is to acquire the necessary licen…

757 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now