Post reply

Connections with multiple instances

  • October 19, 2012 at 7:41 am

    #265948

    I have a Windows 2003 R2 Server with SQL 2008 installed. There are 3 named instances of SQL installed. I am trying to troubleshoot some connection issues coming through our firewall. The connections coming in are just connecting to the IP of the server, so what determines which is the default instance it would connect to when just IP is specified?

  • October 19, 2012 at 8:02 am

    #1550882

    if just the IP, is specified, then the instance that answers is whatever is listening on Port 1433.

    you can see it in SSMS by connecting to each instance and finding the port with this:

    select local_tcp_port from sys.dm_exec_connections where session_id = @@spid

    select port, is_dynamic_port from sys.tcp_endpoints where is_admin_endpoint = 0

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply