Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Host address showing as loopback address (127.0.0.1) from another server Expand / Collapse
Author
Message
Posted Friday, November 29, 2013 7:25 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Tuesday, October 28, 2014 3:57 AM
Points: 589, Visits: 403
I have an odd situation and nothing myself not the network administrators have done appears to be having an effect.

If I run EXEC sp_who2 or use the monitoring software we have to production SQL Server, everything seems normal except for connections coming from one of the webservers. Instead of seeing the server name as the Host, I am seeing 127.0.0.1. I can trace it to a specific server because the username and databases being requested tie up with the function of that server (and if I kill the connections then the server moans for a short while and reconnects).

The requests are definitely coming in across TCP/IP, but again the network address for these SPIds is showing up as a string of zeros rather than the machine net address. The originating server is a different physical box on the same domain.

Does anyone have any idea why this might be happening? At present we know it is just one server so we can pinpoint the connections, but if another server starts doing the same thing than identifying the server may become an issue

Thanks in advance



---------------------------------------
It is by caffeine alone I set my mind in motion.
It is by the Beans of Java that thoughts acquire speed,
the hands acquire shaking, the shaking becomes a warning.
It is by caffeine alone I set my mind in motion.
Post #1518552
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse