I'm not sure I understand the problem here.
Downloading a file should not normally make you lose your connection and it doesn't sound as if you have lost your connection if you are getting a message saying you are already connected.
We need more information;
1] How do you connect to the internet? Is it by dial-up or by cable?
2] If by dial-up, how do you physically connect when you want to go surfing? Do you have a shortcut of your dial-up-network (DUN) connection on your desktop that you have to double click then click "Connect"? Or do you just open Internet Explorer which then automatically dials your connection for you, and you start surfing when the connection is established?
3] What is your ISP's policy on downloading? Some ISP's limit the amount of data a person downloads to a certain number of MB's or GB's a month. When that limit is reached, no more downloading is permitted for the rest of that month.
4] What do you mean when you say "nothing shows up" in Network Connections? Are you saying that your ISP connection has disappeared? If so, does it re-appear at a later time? I have never heard of a connection disappearing from Network Connections before, to reappear at a later date.
5] What do you mean when you say you have to uninstall SP2 in order to re-establish access to your ISP? Does that mean you have completed the download of the SP2 file, then have installed it, then have to uninstall it? Does the connection type re-appear in Network Connections when you have uninstalled SP2?
6] Why do you have to re-download SP2 each time? Once it is downloaded and saved on your hard disk, if install fails and you have to uninstall SP2, you just reinstall from the saved file.
7] Is this the problem? Are you downloading SP2 and "Opening" it each time without saving it? What you should be doing is downloading it, and "Saving" it to your hard disk, (to any suitable temporary location), then you can double click on it to install it at your leisure.
Mark
Every time I try to download Service Pack II for Windows XP I lose my ISP. If I go to Start, Setting, Network Connections, nothing shows up. If I try to create a new connection for my ISP I get a message that the connection is already established, but I can't find it and I can't connect. I have to uninstall Service Pack II in order to re-establish access to my ISP. Help!!!!

Chowhound
Comic Vine
GameFAQs
GameSpot
Giant Bomb
TechRepublic