Solved

Terminal Server MS Access RemoteApp

Posted on 2013-06-28
5
703 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

Salesforce Made Easy to Use

On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.

Question has a verified solution.

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

SharePoint Designer 2010 has tools and commands to do everything that can be done with web parts in the browser, and then some – except uploading a web part straight into a page that is edited in SPD. So, can it be done? Scenario For a recent pr…
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…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
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…

820 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