Solved

Terminal Server MS Access RemoteApp

Posted on 2013-06-28
5
674 Views
Last Modified: 2013-09-09
Good Day. I have an app created in Access 2003 on a Windows Server 2008 R2 Terminal Server. It has been published as a RemoteApp. We want our people to access this through an rdp in SharePoint. It works but users are then faced with multiple pop ups for Trust issues, network authentication, certificates, many times 3 or 4 hoops to jump through. Is there any way for their credentials to be passed so as to just launch the RemoteApp? Is TS Web Access via a browser a possible approach? We want this app to be as simple as possible for our people to get at. Appreciate any assistance.
0
Comment
Question by:EMCIT
5 Comments
 
LVL 9

Expert Comment

by:armchair_scouse
ID: 39284265
I know precious little about networking, but from the little that I do know, I would say the following, based on experiences of a similar recent situation (trying to get users in remote offices to be able to access an application hosted in our offices):

- we had to resolve issues with Kerberos authentication (the technology used to pass a user's rights around the network).  You might not use Kerberos, but you might need to check your authentication method to see if it is working/not working
 - we had to ensure there were network 'trusts' in place between our network domain and the network domains for the remote offices
 - we had to ensure the firewalls were configured to allow access for our application

In light of the experiences/time involved trying to get our situation resolved, I sincerely wish you the best of good luck in resolving the issues; unfortunately, ours took months to resolve, and aren't completely fixed even now.
0
 
LVL 57

Accepted Solution

by:
Jim Dettman (Microsoft MVP/ EE MVE) earned 500 total points
ID: 39284699
I'm not sure what your seeing, but I have one client that launches Access apps through Sharepoint and doesn't have issues.

 I think the issues are problably related to the versions your using.  I'm assuming your using a later version of Access, say 2007 and up?

 If so, I'm sure one of the things your bumping into is that the DB is not in a trusted location.

 My suggestion would be to:

1. Logon to the TS Server with admin credentials using RDP and get it to the point where it launches cleanly.

2. Logon to the TS Server as a regular user with RDP and get it to launch cleanly.

3. Setup a link in sharepoint that edits a text file on the TS server using notepad.  Again address any issues.

4. Now test a shortcut to the Access app.

5. Finially, publish it as a remote app.


  By doing that, I think you'll be able to easily isolate the issues to where they are occuring and be able to ask appropriate questions on how to resolve without a whole bunch of other stuff getting mixed in at the same time.

 ie. some of what your seeing may have nothing to do with Access.

Jim.
0
 
LVL 10

Expert Comment

by:Luke Chung
ID: 39286834
Our paper on Using Terminal Services and RemoteApp to Extend Your Microsoft Access and other Windows Applications Over the Internet discusses the issues around using RemoteApp. We've setup RemoteApp for several clients and host the solution in a robust data center with advanced login and firewalls to address security issues.

See the Network Access and Security Issues section for more information. Hope this helps.
0
 
LVL 11

Author Closing Comment

by:EMCIT
ID: 39476459
Sorry for the delay. I forgot about it.
0
 
LVL 57
ID: 39476478
No problems on the delay.   But did we end up finding anything concrete?

Did the troubleshooting steps help?

If not, I'm going to de-index this question so it doesn't appear to searches.

Jim.
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

776 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