Hello. I'm a second-semester student in computer programming, so I have very little knowledge about hosts file, but we had server issues at school, and my teacher gave me code to replace in my hosts file for my home PC(desktop). I did. A day later he tells me that I don't need to make the changes... problem 1. Already did. problem 2. I was stupid and did not save the original text. The school localhost is the 127.0. etc, but I don't think my localhost is the same. It begins with a 216 number, so I changed the localhost. I still have internet, but I can/could not log into my SQL Server management studio since the change. The teachers don't know what to tell me except uninstall and reinstall the SQL program. I'd rather have my original Vista hosts file back so it all works like it should have before this fiasco. Any advice? Thanks in advance for any help you can provide. Heather

This seems much more network-y than programming-y. second-semester student in computer programming, so I have very little knowledge about hosts file They'll probably never tell you about your hosts file, unless you take some sort of practical application of networking technology class. The school localhost is the 127.0. etc, but I don't think my localhost is the same. Your localhost is 127.0.0.1. It just is. I'd rather have my original Vista hosts file back so it all works like it should have before this fiasco. The default contains your localhost, some comments, and nothing else.

Thank you for your response. I did a ping localhost and it returned 127.0.0.1, just as you said, so I edited my hosts file. I still cannot connect to my sql studio, so I guess I'm stuck with re-installing the program after all then. Again, thank you for trying to help.

hey... just for the record; after re-installing sql I still could not connect to my localhost, so I began wondering if it might be a Vista thing... if I run the program as administrator, I can connect just fine. One more reason why I'm annoyed with Vista. If I turn off my UAC, I don't have to worry about the 'administrator' issue, but then I worry about the UAC being turned off. I'll just put up with the inconvenience of right clicking sql. Thanks again!!!