Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Other SQL Server Topics (2005)
 DTC and random TCP ports

Author  Topic 

Chap
Starting Member

30 Posts

Posted - 2009-04-29 : 14:29:09
When using the DTC in SQL Server 2005 in a firewall environment. It seems to work fine till there is a hic-up or failover. At that point we must chase down the port number to get back on line. Is there a way to lock down the random TCP ports?

Thanks

George

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-04-29 : 14:35:14
There's a KB article regarding this. You can't lockdown the port, you must open a range up on the firewall. I'll see if I can find the article.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-04-29 : 14:40:14
Here's the article: http://support.microsoft.com/kb/250367

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."
Go to Top of Page

Chap
Starting Member

30 Posts

Posted - 2009-04-29 : 15:25:00
Thanks Tara, good article. I don't like getting into the registry myself, but i will show this to ous system admin.

Thanks

George



George
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-04-29 : 15:28:03
You're welcome.

I agree with you on the registry stuff, I let the admins take care of that stuff too.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."
Go to Top of Page
   

- Advertisement -