Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I'm attempting to setup log shipping between two differnet domains. When I attempt to connect to the secondary server instance the primary server fails to connect. If I turn off the windows firewall on the secondary server then I'm able to connect.

I have opened up the following tcp ports on the secondary server windows firewall 1433, 1434, 137, 139, 445

I have opened up the following udp ports on the secondary server windows firewall 137, 138

Are there any other ports or firewall settings that I've missed?

share|improve this question

closed as too localized by RolandoMySQLDBA, JNK Oct 4 '12 at 19:10

This question is unlikely to help any future visitors; it is only relevant to a small geographic area, a specific moment in time, or an extraordinarily narrow situation that is not generally applicable to the worldwide audience of the internet. For help making this question more broadly applicable, visit the help center.If this question can be reworded to fit the rules in the help center, please edit the question.

2 Answers 2

up vote 0 down vote accepted

I was trying to connect to a secondary instance on the server. If I use the primary instance this appears to work. Is there a way to use the secondary instance? I have the secondary instance port open but it is not of course using 1433.

share|improve this answer

The server needed to be added to the LMHosts file so that SQL Server could resolve the path to the directory that the Transaction logs were being saved to.

share|improve this answer

Not the answer you're looking for? Browse other questions tagged or ask your own question.
{"cc_re__cc_re__cc_by_sa_3_0": ["        <li><a href=\"http://area51.stackexchange.com\" title=\"proposing new sites in the Stack Exchange network\">Area 51</a></li>\r\n                        <li><a href=\"http://careers.stackoverflow.com\">Stack Overflow Careers</a></li>\r\n                    \r\n                </ol>\r\n            </td>\r\n    </tr>\r\n</table>\r\n                </div>\r\n            </div>\r\n\r\n            <div id=\"copyright\">\r\n                site design / logo &#169; 2014 stack exchange inc; user contributions licensed under <a href=\"http://creativecommons.org/licenses/by-sa/3.0/\" rel=\"license\">cc by-sa 3.0</a> \r\n                with <a href=\"http://blog.stackoverflow.com/2009/06/attribution-required/\" rel=\"license\">attribution required</a>\r\n            </div>\r\n            <div id=\"svnrev\">\r\n                rev 2014.8.20.1790\r\n            </div>\r\n            \r\n        </div>\r\n    </div>\r\n    <noscript>\r\n        <div id=\"noscript-warning\">Database Administrators Stack Exchange works best with JavaScript enabled<img src=\"http://pixel.quantserve.com/pixel/p-c1rF4kxgLUzNc.gif\" alt=\"\" class"], "copyright__copyright__copyright": ["instance on the server. If I use the primary instance this appears to work. Is there a way to use the secondary instance? I have the secondary instance port open but it is not of course using 1433.\n\nshare|improve this answer\n\nThe server needed to be added to the LMHosts file so that SQL Server could resolve the path to the directory that the Transaction logs were being saved to.\n\nshare|improve this answer\n\nNot the answer you're looking for? Browse other questions tagged or ask your own question."]}