web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics RMS (Archived) / RMS 2.0 - access over VPN
Microsoft Dynamics RMS (Archived)

RMS 2.0 - access over VPN

(0) ShareShare
ReportReport
Posted on by Community Member

i am trying to access rms 2.0 over our vpn, running manager to access reports and post batches to quickbooks. How do i have to set the host windows XP computer so i can access the data?? i can ping the host computer and set up a network drive pointing to a share, but can't get to the files in hte shares. Using sql level authentication.

*This post is locked for comments

I have the same question (0)
  • Ryan Sakry Profile Picture
    Ryan Sakry 3,425 on at
    Re: RMS 2.0 - access over VPN

    All you should need to do is install RMS on the computer you are working on.  Then open RMS Store Operations Administrator, point the connection to wherever the database is located.  You don't need to change your file sharing options (unless you want to share labels or custom reports) to access RMS remotely.  The only other possible issue would be if SQL is not setup to allow remote connections or if the remote computer has a firewall blocking traffic.  I would check these things and try again.

    Just a note when running RMS across a VPN.  RMS is a very 'chatty' program.  It sends information to the server every 1/2 second or so to make sure the server is still alive.  If you have a slow or unstable connection on either end, it could end up being a very frustrating experience from the remote computer.

  • Suggested answer
    Community Member Profile Picture
    Community Member on at
    Re: RMS 2.0 - access over VPN

    Ryan mentioned all these issues, but you might need these details:

    1. To access SQL through firewall, open port TCP 1433

    2. script to allow remote sql control
    EXEC sp_configure 'show advanced options', 1
    RECONFIGURE
    EXEC sp_configure 'xp_cmdshell', 1
    RECONFIGURE

    3. don't try to use SO Manager over a slow VPN connection, remote control a local terminal instead.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics RMS (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans