MSDTC Port 135 open bi-directionally

Posted by Stephen Lacy on Server Fault See other posts from Server Fault or by Stephen Lacy
Published on 2010-07-05T12:50:26Z Indexed on 2012/07/06 21:19 UTC
Read the original article Hit count: 311

Filed under:

sql-server

|

msdtc

I have two servers, a web application server and an SQL Server database running on its own server.

I have a firewall between these two servers.

Do I have to open port 135 on both the SQL Server and the Web Application Server.

Does the SQL Server open its own connection to the Web Application Server on port 135 or any other port?

Do I have to in component services point the Web Application Server MSDTC at the SQL Database Server?

If the firewall is completely open, the settings in component services set to allow remote connections, remote administration etc is there any other settings that need to be changed in order to allow remote connections to the SQL Server MSDTC?

© Server Fault or respective owner

Related posts about sql-server

SQL SERVER – Beginning SQL Server: One Step at a Time – SQL Server Magazine

as seen on SQL Authority - Search for 'SQL Authority'
I am glad to announce that along with SQLAuthority.com, I will be blogging on the prominent site of SQL Server Magazine. My very first blog post there is already live; read here: Beginning SQL Server: One Step at a Time. My association with SQL Server Magazine has been quite long, I have written nearly… >>> More
How to install SQL Server 2005 Configuration Manager without installing SQL Server Management Studio

as seen on Server Fault - Search for 'Server Fault'
Hi, I need to configure SQL Server aliases on a public-facing production server. To do that, I need to install SQL Server Configuration Manager. I was not able to find a standalone installer for that, so I am having to install SQL Server 2005 Client Components. This approach is not ideal as we don't… >>> More
[MAJ] SQL Server 2005 Express Edition - La version gratuite de SQL Server 2005

as seen on ASP-PHP.net - Search for 'ASP-PHP.net'
Modification technique pour le site de l'article. >>> More
How to create SQL Server Express DB from SQL Server DB

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a SQL Server 2008 DB. I want to extract SOME tables (and associated schema, constraints, indexes, etc) and create a SQL Server Express DB. It isn't a sync of the target, we stomp on it. We ONLY need to do this in the file system (not across the wire). We are not fond of the synchronization… >>> More
sql server 2000 error, error trying to connect to sql server 2005

as seen on Stack Overflow - Search for 'Stack Overflow'
i am connecting to sql server 2000 on a remote computer with a dotnet application, but when i try to open the connection it gives the following error: When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections What… >>> More

Related posts about msdtc

MSDTC - Communication with the underlying transaction manager has failed (Firewall open, MSDTC netwo

as seen on Server Fault - Search for 'Server Fault'
I'm having problems with my ASP.NET web forms system. It worked on our test server but now we are putting it live one of the servers is within a DMZ and the SQL server is outside of that (on our network still though - although a different subnet) I have open up the firewall completely between these… >>> More
MSDTC - Communication with the underlying transaction manager has failed (Firewall open, MSDTC network access on)

as seen on Server Fault - Search for 'Server Fault'
I'm having problems with my ASP.NET web forms system. It worked on our test server but now we are putting it live one of the servers is within a DMZ and the SQL server is outside of that (on our network still though - although a different subnet) I have open up the firewall completely between these… >>> More
MSDTC - Communication with the underlying transaction manager has failed (Firewall open, MSDTC netwo

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm having problems with my ASP.NET web forms system. It worked on our test server but now we are putting it live one of the servers is within a DMZ and the SQL server is outside of that (on our network still though - although a different subnet) I have open up the firewall completely between these… >>> More
Do MSDTC and disaster recovery go together?

as seen on Stack Overflow - Search for 'Stack Overflow'
Our application writes to multiple Sql Server databases within a distributed transaction. The Ops guys are saying that this messes up their disaster recovery plan because while the transactions on the live tables may commit at the same time, the log shipping on the separate databases happen at slightly… >>> More
confusion about transactions and msdtc

as seen on Stack Overflow - Search for 'Stack Overflow'
I have some basic confusion about how transactions and msdtc work together. I have a basic server/client winforms app. The app uses transactionscope to encapsulate several sql commands that are executed on the sql server. The app seemed to work fine when I enabled msdtc network access on the server… >>> More