Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 importance of loopback ip??

Author  Topic 

frank.svs
Constraint Violating Yak Guru

368 Posts

Posted - 2011-06-21 : 03:33:40
Hi All,

I have a SQL server 2008 installed on my PC.

I opened sql server configuration manager, under SQL Server 200 Network configuration, i have

Protocols for MSSSQLServer. and on the right pane, when i right click on TCP/IP protocol and go to properties.

I have IP1 with my actual IP address, IP2 as 127.0.0.1 and IPAll.

What is this 127.0.0.1 ip address indicate? I came to know that it is a loopback ip address.

I would like to know the importance of this ip?
How it is useful for sql server connectivity while connecting to sql. Basically, when does it come into picture?

Any help would be appreciated.

Thanks in advance.
   

- Advertisement -