locked
How to Connect to a SQL Server Instance From a Different Domain? RRS feed

  • Question

  • Can anyone tell me what I need to do to connect to a SQL Server instance from a different domain using SQL Server Authentication mode?

    Thanks,
    Lijun

    Wednesday, April 8, 2015 6:12 PM

Answers

  • Can anyone tell me what I need to do to connect to a SQL Server instance from a different domain using SQL Server Authentication mode?

    Thanks,
    Lijun

    If you're using SQL Server authentication you just need to be able to connect to the instance on TCP port 1433 - this is on the assumption you're using the default port. Also, open 1434 for the SQL Browser if you're using that for named instances

    Here's a document on configuring windows firewall for sql server:

    https://msdn.microsoft.com/en-us/library/cc646023(v=sql.110).aspx


    Wednesday, April 8, 2015 7:08 PM