G
Guest
I have a small wireless network with a copy of SQL Server 2000 SP 4 running
on a Windows 2000 machine. I also have a copy of SQL Server 2000 SP 4
running on a Windows XP machine on the same network.
Each server can see the other and I can access databases on the one from the
other.
I have set up my router to listen on port 1433 and pass all such traffic to
the Win2000 server. When I connect from an MDB FE using the real IP address
of the router, the traffic goes to the correct server.
However, when I change the port mapping on the router to send the 1433
traffic to the winXP server, I get an error saying "Server does not exist or
access denied".
As far as I can tell, both servers are set up correctly and the same. They
both have correct aliases in the Client Network settings. they are both
listening on TCP/IP. They both use the sa login and the password is the same
on both, so the MDB does not need to do anything different. I should only
have to change the port mapping on the router to change the connection.
What could I be missing?
on a Windows 2000 machine. I also have a copy of SQL Server 2000 SP 4
running on a Windows XP machine on the same network.
Each server can see the other and I can access databases on the one from the
other.
I have set up my router to listen on port 1433 and pass all such traffic to
the Win2000 server. When I connect from an MDB FE using the real IP address
of the router, the traffic goes to the correct server.
However, when I change the port mapping on the router to send the 1433
traffic to the winXP server, I get an error saying "Server does not exist or
access denied".
As far as I can tell, both servers are set up correctly and the same. They
both have correct aliases in the Client Network settings. they are both
listening on TCP/IP. They both use the sa login and the password is the same
on both, so the MDB does not need to do anything different. I should only
have to change the port mapping on the router to change the connection.
What could I be missing?