we have a sql server connected to our network, but only one computer accesses it. There is a lot of traffic on this network so we were thinking of moving the sql server off the network and directly connecting it to the computer that uses it by installing another card in it and using a crossover cable.
How should we set up the new network card?
should I use a 192.168.0.1 for the sql server and 192.168.0.2 for the new network card? If I do that only those 2 cards that are connected can see eachother right?
do I have to mess with the routing tables?
this is NT 4 computers