Loopback address

Question

Post reply

Loopback address

Oracle_91

SSChampion

Points: 14548
More actions
August 13, 2012 at 8:30 am

#260095

Hi,
I wanted to know what is the use of the Loop back address. What importance and when it is used and when it is helpful.
C:\>netstat -ano|find /i "1620"
TCP 0.0.0.0:1485 0.0.0.0:0 LISTENING 1620
TCP 10.xx.xx.xx:1485 10.xxx.xx.xxx:50751 ESTABLISHED 1620
TCP 10.xxx.xx.xx:1485 10.xxx.xx.xxx:61294 ESTABLISHED 1620
TCP 127.0.0.1:63373 0.0.0.0:0 LISTENING 1620
TCP [::]:1485 [::]:0 LISTENING 1620
TCP [::1]:63373 [::]:0 LISTENING 1620
FROM SQL Server ERRORLOG
2012-08-13 19:50:41.97 spid7s Server name is 'xxxxx\SQL2008'. This is an informational message only. No user action is required.
2012-08-13 19:50:42.77 Server The certificate [Cert Hash(sha1) "889C2785E3AFD5C0987E3B69436B6BF589572884"] was successfully loaded for encryption.
2012-08-13 19:50:42.92 Server Server is listening on [ 'any' <ipv6> 1485].
2012-08-13 19:50:42.92 Server Server is listening on [ 'any' <ipv4> 1485].
2012-08-13 19:50:42.92 Server Server local connection provider is ready to accept connection on [ \\.\pipe\SQLLocal\SQL2008 ].
2012-08-13 19:50:42.92 Server Server named pipe provider is ready to accept connection on [ \\.\pipe\MSSQL$SQL2008\sql\query ].
2012-08-13 19:50:42.93 Server Server is listening on [ ::1 <ipv6> 63373].
2012-08-13 19:50:42.93 Server Server is listening on [ 127.0.0.1 <ipv4> 63373].
Thanks in Advance.
August 13, 2012 at 8:49 am

This was removed by the editor as SPAM

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

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

GSquared SSC Guru Points: 260824 More actions · Answer 1

Data on loopback address here: http://www.bing.com/search?q=Loop+back+address&src=ie9tr

The Webopaedia and Wikipedia links are very informative on the subject.

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

Oracle_91 SSChampion Points: 14548 More actions · Answer 2

Thanks for the responses.

Do i need to keep this enabled ? If i disable it, if there any impact on sql server. From sql server perpective, how it is utilized what is impact i dont have it? I can have shared memory if i want to have a local connection to sql server..