Share via

Two Azure SQL Managed Instances created has same Ip address

Prem Gokull 1 Reputation point
2022-03-01T01:40:44.67+00:00

When I created two Azure SQL Managed Instances ( same vnet/subnet) both have the same Ip address, when I tried to nslookup with host details, How to fix this, ideally it should be different ?

Azure SQL Database

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. GeethaThatipatri-MSFT 29,597 Reputation points Microsoft Employee Moderator
    2022-03-07T13:56:05.943+00:00

    Hi, @Prem Gokull As per the support your query has been resolved here is the resolution to get the IP address(in SSMS):

    select

    @@servername as [Server Name],

    @@servicename as [Instance Name],

    client_net_address as [Client Machine IP],

    local_net_address as [SQL Server IP],

    local_tcp_port as [SQL Server Port],

    auth_scheme as [Authentication Mode],

    net_transport as [Physical Transport Portocol],

    protocol_type as [Payload Portocol Type]

    FROM sys.dm_exec_connections

    where session_id=@@SPID

    Please do not forget to "Accept the answer" wherever the information provided helps you to help others in the community

    Regards
    Geetha

    Was this answer helpful?

    1 person found this answer helpful.

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.