I have a small business lan that is composed of a D-link Router, and 2 hubs. Both hubs are plugged directly in the router using their uplink ports.
The computers plugged in hub #1 can connect to SQL Server (using a username and password, not Windows Authentication) just fine, but the ones connected to the second hub can't. I get a "Server doesn't exist or access denied" error. I use the same connection string, username and password.
Of course, the computers on the second hub can access the network, internet and so on. I can even ping the server from them, but for whatever reason, I can't connect to Sql Server!
What could it be? I'm a little lost now...
People succeed in answering Carl Mercier's questions 23% of the time (5 successes in 22 attempts).
Answers by: Don Miguel de los Platanos
It is a rather odd problem. I would try to plug the 2nd hub to the router via one of its regular ports and not its uplink port just for a test. Maybe even unplug the first hub and plug the second one into its port and test. While the hubs do not provide any type of switching function, the router does. I'm wondering if the router is not switching the packets to the proper destination when it recieves the traffic. It seems to defy some normal networking conventions on why the data cannot get to its destination. It appears that the data is getting mangled or out right dropped when it hits the sql server. I would lose the hubs altogether a buy a good quality switch, this can ensure that the data is not being bunched all together like on a hub, since a hub broadcast all packets to every port. Good luck.
It seems that the problem is not directly related to the first hub as I previously tought. I have 4 computers connected to the first one, and only 1 out of 4 can't connect to SQL Server.
Every computer is configurer the same (more or less) and every computer is part of an Active Directory Win 2000 network.