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
298 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
  • 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
 
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
Complete Microsoft Windows PC® & Mac Backup

Backup and recovery solutions to protect all your PCs & Mac– on-premises or in remote locations. Acronis backs up entire PC or Mac with patented reliable disk imaging technology and you will be able to restore workstations to a new, dissimilar hardware in minutes.

 
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

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

Our Group Policy work started with Small Business Server in 2000. Microsoft gave us an excellent OU and GPO model in subsequent SBS editions that utilized WMI filters, OU linking, and VBS scripts. These are some of experiences plus our spending a lo…
Even if you have implemented a Mobile Device Management solution company wide, it is a good idea to make sure you are taking into account all of the major risks to your electronic protected health information (ePHI).
After creating this article (http://www.experts-exchange.com/articles/23699/Setup-Mikrotik-routers-with-OSPF.html), I decided to make a video (no audio) to show you how to configure the routers and run some trace routes and pings between the 7 sites…
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…

706 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now