Our company had several hubs, and recently got rid of the hubs and put a level 3 switch. We have about 100 computers that connects to a Windows NT 4.0(SQL Server 7.0) server. When we had hubs they were connecting fine. But after we put the switch they could't connect. An outside company installed the switch for us, so none of us know what they did. Since production was down for a while we tried putting lmhosts file on a machine and it worked. So we installed lmhosts file on every machine. But I don't see why you need lmhosts file on a LAN. The problem we have now is the PC's cannot be rebooted or shut down because it about 3 - 5 reboots to connect to the NT Server. On some machines thats about 30 minutes. Does anybody know what the problem is?
I am a programmer and know nothing about NT or switches. But I am directly affected by this change, and all my programs access the SQL Server.