Solved

No local (127.0.0.1) TCP/IP access, and stack breaks when I try to use it!

Posted on 2007-03-22
10
312 Views
Last Modified: 2013-12-04
I am running Windows 2003, and do software development with IIS 6.0 as the Web server for local development on 127.0.0.1.  That has worked for years, but maybe because of the Windows 2003 SP2 update, or some parallel Windows 2003 update, suddenly my local development environment does not work.  This hurst when you are a software developer!

In addition, every time I try to use 127.0.0.1, it also kills the remote TCP/IP capability.  I can make that remote capability work again by disabling then re-enabling the Local Adapter.   Standard Internet access works fine, until the very first time I try to use 127.0.0.1, and then the remote Web access breaks immeidately, requiring the disable and enable sequence.  I tried by deleting the network card from Device Manager and letting it re-detect, but no change occurred after all the dust settled.

Any ideas?
0
Comment
Question by:opalcomp
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 4
  • 2
10 Comments
 
LVL 9

Accepted Solution

by:
robjeeves earned 250 total points
ID: 18775652
First thing I'd do mate is reset TCP/IP using netsh

http://support.microsoft.com/kb/317518

Rob
0
 
LVL 38

Assisted Solution

by:younghv
younghv earned 250 total points
ID: 18775659
From a command prompt or Start-Run:

netsh int ip reset c:\resetlog.txt

Vic
0
 
LVL 38

Expert Comment

by:younghv
ID: 18775664
Arghhh!
Too fast for me.

Vic
0
Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

 
LVL 9

Expert Comment

by:robjeeves
ID: 18775725
Annoying isn't it? JayJay just beat me to Dc issues.  So upsetting when you submit and there is something else above your post :)
0
 
LVL 1

Author Comment

by:opalcomp
ID: 18776843
The netsh int ip reset c:\resetlog.txt did give me local access, and I thought all was well.  However, the local access still resulted in the remote access dying.  Since then, I have been cycling through netsh, resetting the TCP/IP setting for the local adapter, disabling and enabling, and rebooting.  Still no stability.

I also removed the line for 127.0.0.1 from the hosts file.  I also notice that if I ping, for example, 127.0.2.2, the echo back comes from 127.0.0.1.  The mask is 255.255.255.0.  Isn't that echo back unexpected?

Does any of this shed more light on the problem?
0
 
LVL 38

Expert Comment

by:younghv
ID: 18778602
opalcomp,
It is unbelievable, but the entire IP range of 127.x.x.x is 'set aside' to always mean 'Local Host'.
Pinging 127.254.254.254 will return local host also.

Check out this post here on EE for some great discussion (and testing): http://www.experts-exchange.com/Networking/Misc/Q_21545829.html

0
 
LVL 1

Author Comment

by:opalcomp
ID: 18778781
Don't know how I missed this - the problem is not with local access, it is a problem with my copy of MS SQL Server 2005, in fact, it is a problem with data access via ODBC.  If I run a local page with just HTML, that is fine.  If I use the SQL Server Manager, that is also fine.  The problem occurs when my ColdFusion page attempts to connect to SQL Server 2005; that is when there is a problem.

This started after the W2003 SP2 update and a security fix for SQL Server, I believe.  I have since tried to re-installed MDAC 2.8, and did that but no help.  Perhaps I need to go to the SQL Server area at this point?
0
 
LVL 1

Author Comment

by:opalcomp
ID: 18779744
Well, it appears the crisis is over.  I isolated the problem to a single SQL Server database, which happened to be the one that I have been working on the most for the last few months.  After running CHKDSK /F on the three hard drives, I still had to delete the entire database, take a backup from the live database and restore it locally, and delete and re-define the ODBC entry as well.  After doing that, it finally appears to be working.

I am going to reward each of you 1/2 the points - what do you think?
0
 
LVL 38

Expert Comment

by:younghv
ID: 18779909
Hi opalcomp,
Great news that you figured it out.
I have a customer with an SQL data base problem and I may have to ask you for some help.

"Askers" can do anything they want with points, but you probably should post a request in http://www.experts-exchange.com/Community_Support/General/ (Free questions) asking that this be "PAQ'ed" with your answer selected.

Glad you solved it.

Vic
0
 
LVL 1

Author Comment

by:opalcomp
ID: 18784598
You two can split the points, since yo answered the original question... I hope I have some left for future problems!
0

Featured Post

Optimize your web performance

What's in the eBook?
- Full list of reasons for poor performance
- Ultimate measures to speed things up
- Primary web monitoring types
- KPIs you should be monitoring in order to increase your ROI

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Short answer to this question: there is no effective WiFi manager in iOS devices as seen in Windows WiFi or Macbook OSx WiFi management, but this article will try and provide some amicable solutions to better suite your needs.
OfficeMate Freezes on login or does not load after login credentials are input.
Internet Business Fax to Email Made Easy - With  eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, f…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…
Suggested Courses

630 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question