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 v2 with SQL Server...
Microsoft Dynamics RMS (Archived)

RMS v2 with SQL Server 2008 R2 Express behind firewall, what ports to allow?

(0) ShareShare
ReportReport
Posted on by Community Member

Folks,

We are about to put our SO RMS v2 servers running SQL Server 2008 R2 Express behind the firewall due to PCI compliance (network segmentation).

Could you comment what ports besides TCP 1433 I should allow on the firewall for the POS registers to connect to the SO SQL server?

Your support is appreciated.

Thanks,

...Alex

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Community Member Profile Picture
    Community Member on at
    RE: RMS v2 with SQL Server 2008 R2 Express behind firewall, what ports to allow?

    TCP 1433 - which is the default and should probably be changed.  

    see below article for a more detailed explanation.

    support.microsoft.com/.../287932

  • Verified answer
    Gerald Rothaus Profile Picture
    Gerald Rothaus 2,934 on at
    RE: RMS v2 with SQL Server 2008 R2 Express behind firewall, what ports to allow?

    1433 and for HQ check your config's for HQ Client & HQ Server

  • Verified answer
    Community Member Profile Picture
    Community Member on at
    RE: RMS v2 with SQL Server 2008 R2 Express behind firewall, what ports to allow?

    Hello Alex,

    Thank you for your post.

    As noted, 1433 is the default SQL port you will want open, unless you change this per the link Ed provided.

    You will also want to check the configuration takes in Headquarters Server, Voucher Server, Headquarters Client and Voucher Client to make sure the listed ports are open, if you are using Headquarters.

    Thank you,

    Scott Wardzinski

    Microsoft Dynamics RMS & POS Support Engineer

  • Community Member Profile Picture
    Community Member on at
    RE: RMS v2 with SQL Server 2008 R2 Express behind firewall, what ports to allow?

    Scott,

    I am not familiar with Voucher Server or Voucher Client, we run HQServer and HQClient, are you referring to these?

    Thanks,

    ...Alex

  • Community Member Profile Picture
    Community Member on at
    RE: RMS v2 with SQL Server 2008 R2 Express behind firewall, what ports to allow?

    Alex,

    Voucher Server and Voucher Client are features included with Feature Pack 1 to allow RMS to use and process Global Vouchers: vouchers that can be sold at one store and redeemed at all stores in your environment.

    For more information, please view the following page:

    mbs.microsoft.com/.../rms-20-fp1

    Thank you,

    Scott Wardzinski

    Microsoft Dynamics RMS & POS Support Engineer

  • Gerald Rothaus Profile Picture
    Gerald Rothaus 2,934 on at
    RE: RMS v2 with SQL Server 2008 R2 Express behind firewall, what ports to allow?

    Hi, Scott.

    Everyone wants to answer the easy ones, but how come I can't get anyone to weigh in on my pinpad question?

    -Jerry

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

Quick Links

Responsible AI policies

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

Pallavi Phade – Community Spotlight

We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…

Congratulations to the October 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