How to connect SQL Server by host IP Address

Question

I'm trying to connect new host in SQL Server using IP address, but I got some trouble when I'm trying to log in SSMS 2017. I'm still relatively newbie about using SQL Server. Here's the error message:

when I'm trying to login:

And here when I check SQLCMD

I've been trying:

1. Restart Service SQL Server

2. Enable all Protocols for MSSQLSERVER (include TCP/IP and Named Pipes)

3. Allow remote connections

4. Enable SQL Server Browser

Answer 1

Check your SQL Server log to ensure that it's listening on the IP address(es) you expect. You should see an entry during startup like:

Server is listening on [ 'any' <ipv4> 1433].