Server Firewall and Required Services

[JDavis]

Can someone detail which ports are necessary to be open if your servers are using a firewall and what services need to be running for Select and the Servers to communicate successfully.

For instance, we know that on the Select Server, we will need to have any of the ports open that the servers are running on such as 8080, etc. On SQL we will have 1433 and any others typical for SQL Server open. In our testing, it seemed like we had to have Distrubuted Transaction Coordinator running on the servers - can you confirm which servers this is required to have running on? The Select Server or SQL aslo?

All of our servers will be running Windows 2008 R2.

Thanks,
Jake

[JDavis]

Also, regarding MS DTC, do we need to enable such as in the following http://myjemmy.blogspot.com/2010/07/win ... 08-r2.html

For the firewall settings for it in 2008 R2 there are 3 by default set to disabled for DTC - should we enable them?

[JDavis]

Sorry, one more question about DTC. On Server 2008, do we also need to install the Applicaiton Role and select the Distrubted Transactions option? With what options (Incoming, Outgoing, WS-Atomic)? And on what servers will this be needed? SQL, Select Server, and Client terminial server?

[Hadi Chemaly]

Let me first apologize for the delay in replying to your post, I hope you still find this useful.

For Select's back-end, we install 3 services:

• 1. Configuraton service (spscfgsvc) running on port 9292
  2. Hosting service (spshost) on port 9191
  3. Select Server service (spssvr) by default on port 8080

We require MSDTC to be enabled on all three tiers, for both incoming and outgoing transactions (we don't use WS-atomic):

• 1. The machine running SQL Server
  2. The machine running the Select Server
  3. The machine(s) running the Select Client

To enable MSDTC:

• . Launch a command prompt
  . Type msdtc -install
  . Go to Windows Services
  . Right click on Distributed Transaction Coordinator and go to properties
  . Make sure the startup type is set to Automatic
  . Start the service

From our SoftPro Select installation notes:

Lookup tables now require the Select server to communicate with the Select client using the Microsoft Distributed Transaction Coordinator (MSDTC). If any firewalls exist between the Select server and client machine (i.e. Windows firewall), they need to be configured to have MSDTC.exe (located in c:\windows\system32) as a program exception. To do this, go to Start/Control Panel/Windows Firewall. On the Exceptions tab, click Add Program and then browse to MSDTC.exe. Make that selection and save changes.

Let us know if you hit any other problems.