IP adrsss for my SQL server

Question

IP adrsss for my SQL server

Edvard Korsbæk

SSCertifiable

Points: 5994
More actions
September 24, 2017 at 1:44 am

#323739

Hi all!
I have tried both Google and seach on this page first...
I have a SQL 2012 server, where one of the DB'a are used for a web server.
I have a static IP adress 'Outside' on my netgear Router.
Now i want to set my Netgear router up with a proper 'Get through ' on port 88, which my webserver uses at the moment.
For that, I need an IP adress of my SQL server.
Where to find it?
Best regards
Edvard Korsbæk

Viewing 4 posts - 1 through 3 (of 3 total)

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

Thom A SSC Guru Points: 99133 More actions · Answer 1

On your SQL Server, open Command prompt or Powershell and type ifconfig. The IP address will be labeled as inet addr (inet6 addr is the IPv6 Address, if you're using that protocol).

Thom~

Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk

Edvard Korsbæk SSCertifiable Points: 5994 More actions · Answer 2

Thanks for your reply!

It was not the most intelligent question, which I could make.
What i should do was to set my router up, so it could make BOTH a connection to my webserver AND to my SQL db, which i can call through the PC's IP adress, and not the IP adress of the sql server.

Enjoy Sunday anyway!

Best regards

Edvard Korsbæk

cyrusbaratt SSC-Addicted Points: 417 More actions · Answer 3

Greetings,

Please try this power shell script:

$colItems = Get-WmiObject Win32_NetworkAdapterConfiguration -Namespace "root\CIMV2" | where{$_.IPEnabled -eq "True"} Write-Host "# --------------------------------------"Write-Host "# Local IP address information"Write-Host "# --------------------------------------"foreach($objItem in $colItems) {  Write-Host "Adapter:" $objItem.Description  Write-Host " DNS Domain:" $objItem.DNSDomain Write-Host " IPv4 Address:" $objItem.IPAddress[0] Write-Host " IPv6 Address:" $objItem.IPAddress[1] Write-Host " " }

I located it in the Web site:
https://www.mssqltips.com/sqlservertip/3127/sql-server-database-connectivity-testing-using-powershell/

Regards

DBASupport