Multiple IP addresses but same SQL Server instance?!

  • We have a SQL Server instance that I can access by logging into 3 different servers. I don't really understand how this is possible?

    Is it just SQL Server listening on different ports? I'm confused.

    ---------------------------------------------------------

    It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
    David Edwards - Media lens[/url]

    Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
    Howard Zinn

  • sounds like aliases have been set up

    ---------------------------------------------------------------------

  • Thanks George, makes sense now.

    ---------------------------------------------------------

    It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
    David Edwards - Media lens[/url]

    Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
    Howard Zinn

  • How exactly are you connecting to SQL on the different servers?

    Yes, SQL can be configured to listed on multiple IPs, ports and protocols.

    Joie Andrew
    "Since 1982"

  • I'm using SSMS, Connect -> Database Engine -> then using SQL Server Authentication to connect. Was just confused that I could use 3 IPs and still connect to the same instance.

    ---------------------------------------------------------

    It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
    David Edwards - Media lens[/url]

    Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
    Howard Zinn

  • I'm using SSMS, Connect -> Database Engine -> then using SQL Server Authentication to connect. Was just confused that I could use 3 IPs and still connect to the same instance.

    Are you putting the IP in the "Server name:" field in SSMS when you are trying to connect to the SQL instance, or are you just connecting to the same instance name from three different servers?

    Joie Andrew
    "Since 1982"

  • I'm using the IP.

    ---------------------------------------------------------

    It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
    David Edwards - Media lens[/url]

    Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
    Howard Zinn

  • If you log onto the server hosting the SQL instance, open up SQL Server Configuration Manager you should be able to see what protocols are enabled for the instance. If you go to the properties of TCP/IP you can see what IPs and ports that SQL is listening on.

    Joie Andrew
    "Since 1982"

Viewing 8 posts - 1 through 7 (of 7 total)

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