RE: Accessing SQL Server Accross Domain

From: Baisong Wei[MSFT] (v-baiwei_at_online.microsoft.com)
Date: 12/19/03

  • Next message: Tibor Karaszi: "Re: Terminating this procedure. Cannot have an open transaction when this is run." 
    Date: Fri, 19 Dec 2003 06:43:17 GMT

    Hi JT,

    Thank you for using MSDN Newsgroup! It's my pleasure to assist you with
    your issue.

    As my understanding of your question, you want to know if you client
    application in their domain could access the SQL Server in another domain,
    right. If I misunderstood, please feel free to let me know.

    To access the SQL Server across domain is possible.

    At first, make sure the connection between this two computers is OK.

    Please refer to this article:
    http://support.microsoft.com/?id=238949

    You can test the application environment by the following steps to test
    the connectivity:

    To test general connectivity:
        PING < SQL_Server ip>

    To test we can connect to default SQL Server port 1433:
        TELNET < SQL_Server ip> 1433

    If we can connect, the screen will go blank. The server is awaiting more
    commands. Hit any key to return.
    If we CANNOT connect, you will get an error:
    "Connecting To < ip > ..Could not open connection to the host, on port 1433
      No connection could be made because the target machine actively refused
    it."

    NOTE:
    Port 1433 is the default port number for SQL Server. You can check the
    actual port number by Server Network Utility. You can get the actual port
    number in use by check the properties of TCP/IP (which should be in the
    "Enabled Protocols").

    Then, use your Query Analyzer to check if it can access the database from
    one domain to another.

    For information you could refer to or ADO.NET programming, you can refer
    to the following materials or ask questions in related newsgroup:
    http://support.microsoft.com/?id=216415
    http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnauth/html
    /dnauth_security.asp
    http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:
    80/support/kb/articles/Q193/1/35.ASP&NoWebContent=1
    http://support.microsoft.com/default.aspx?scid=kb;en-us;q176379

    Hope this answered your questions. If you still have questions, please feel
    free to post new message here and I am ready to help.

    Best regards

    Baisong Wei
    Microsoft Online Support
    ----------------------------------------------------
    Get Secure! - www.microsoft.com/security
    This posting is provided "as is" with no warranties and confers no rights.
    Please reply to newsgroups only. Thanks.

  • Next message: Tibor Karaszi: "Re: Terminating this procedure. Cannot have an open transaction when this is run."

    Relevant Pages

    • Re: Accessing sql server
      ... port, select All ports, in Remote port, select Fixed port and input 1433 ... Microsoft CSS Online Newsgroup Support ... This newsgroup only focuses on SBS technical issues. ... | I have now checked and I can access the sql server when creating an ODBC ...
      (microsoft.public.windows.server.sbs)
    • Re: SQL2005: Cannot connect error 11001
      ... I believe the complete Windows auth user access is too complicate, ... which trusted connection is meant? ... it would still be listening on the old port. ... Microsoft, SQL Server Books Online ...
      (microsoft.public.sqlserver.connect)
    • Re: Installing Sql Server Express on Vista Home Premium
      ... It seems that your SQL Server instances are Named Instances, ... Default Instances uses 1433 TCP port by default as a Static Port but not the ... If you change your Connection String as following, ...
      (microsoft.public.sqlserver.setup)
    • Re: SQL Server 2005 Connection Problems
      ... - it is't completely clear what the SQL Server Browser is for. ... connection reqest was being rejected. ... I think the problem is still likely the the port is blocked by some ... firewall between the server and that client. ...
      (microsoft.public.sqlserver.setup)
    • Re: Cannot connect to SQL Express on 2003 Machine from XP machine
      ... enable network communication ... make sure that the port isn't blocked ... "An error has occurred while establishing connection to the server. ... When connecting to SQL Server 2005, this failure may be caused by the ...
      (microsoft.public.sqlserver)