Sql-server – SQL Server Configuration manager doesn’t show the IP

sql server

Sorry for stupid question.
I'm trying to set up the remote connection to the SQL Server.
In all tutorials I watched people have their IPs shown in the TCP/IP properties window(under SQL Server Network Configuration–>Protocols for MSSQLSERVER). Please see the picture.
But I have only the port.
Where can I see the IP? What should I do to see it?

Best Answer

What the version of SQL Server are you using?

Please make sure you open the same version of SQL Server Configuration Manager if you have multiple different version SQL Server instances.

You can use the following query to view the raw data with your network protocols:

SELECT registry_key, value_name, value_data 
FROM sys.dm_server_registry
WHERE registry_key LIKE '%SuperSocketNetLib%'

See this for more details.

Regards,

Amelia

Related Solutions

Sql-server – SQL Server is started but didn’t listen on any port

What made my SQL server listen for TCP connections on port 1433 was the following...

Configuration Tools / SQL Server Configuration Manager
click the instance name in SQL Server Network Configuration
enable TCP communication
Right-click the TCP communication entry, choose Properties
Click the IP addresses tab
Enable all non-VMnet IP addresses and enter 1433 in the Port entry for "IPAll".
Restart the SQL Server on SQL Server Services tab

Check your configuration with netstat -an:

C:\>netstat -an | find "1433"
  TCP    0.0.0.0:1433           0.0.0.0:0              LISTENING
  TCP    [::]:1433              [::]:0                 LISTENING

Sql-server – SQL Server Configuration Manager 2012 – unable to set IP All = No

You cannot set IPAll to "no" on a failover cluster instance (as mentioned before), see:

How to configure SQL server to listen on different ports on different IP addresses?

More than likely, though, you are wondering how to secure your failover cluster instance of SQL Server to a certain IP address, or to verify that it isn't indeed listening on all IP addresses registered.

The failover cluster instance will be listening on the IP address(es) registered for the virtual network name in the cluster resource group with the Windows failover cluster.

But you want to verify which IP addresses SQL Server is listening on?

select
    ip_address,
    port,
    is_ipv4,
    type_desc,
    state_desc
from sys.dm_tcp_listener_states;

That will give you the real-time snapshot of what IP addresses SQL Server is listening on. That'll be your verification.

Best Answer

Related Solutions

Sql-server – SQL Server is started but didn’t listen on any port

Sql-server – SQL Server Configuration Manager 2012 – unable to set IP All = No

Related Question