>>>>>>>
>>>>>
>>>>>If the Server has static IP, you can use this site
http://www.whatismyip.com/ to find the IP of it.
>>>>
>>>>When I run this URL on my PC I get message "Service Unavailable"
>>>
>>>Strange, worked fine for me... There are any other ways to find the IP of the server.
>>>
>>>Actually, I understand now. Sure, you don't have IE (or other browsers) installed on the server. That was dumb of me.
>>>
>>>Try running ipconfig in the cmd window.
>>
>>No, IPCONFIG just tells me the IP of my PC. I am trying to find out (if it is possible) what IP is assigned to the SQL Server running on my PC.
>
>I've tried in the command window
>PING MyServerName
>
>Found this also
http://stackoverflow.com/questions/142142/sql-query-to-get-servers-ip-address, but it refers to IP Address of the computer as it invokes IPConfig
PING MyServername works. However my SQL Server name is the same as the computer. But this is what I was looking for. Thank you.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham