Dual Netwok

Posted on 2004-08-31
Medium Priority
Last Modified: 2010-04-11
Hi experts

I want to build a live SQL SERVER 2000 ENTERPRISE database for stock prices.  

I receive "broadcast ticker" on one machine on network XXX.XXX.XXX.XXX

I have the SQL SERVER on another connected to network YYY.YYY.YYY.YYY

I cannot ping from one PC to the other.  However, they are physically adjacent.  

How can I get the ticker PC to update the SQL Server on the other machine?

I was hoping maybe I could put in another network card and assign the "broadcast ticker" machine to both networks?

Question by:OptionsMM

Expert Comment

ID: 11948654
another network card in each is a good option, if they are physically close enough, otherwise you'd have slot a router in there, or change an existing router to support what you are trying todo.

Accepted Solution

jonnietexas earned 2000 total points
ID: 11948773
Yes, you can put another NIC in the server.  You need to decide if there is a reason to have the rest of the two networks talk to each other or not.  Also, do both network connect to the Internet or other networks?  Or are they islands to themselves?  If all you want is for the one box to talk to the SQLServer then rockon.  If they go to other places then you'll have issues if you want other boxes to converse on both networks also.  The distance isn't an issue as far as whether you use another NIC or not.

Author Comment

ID: 11949226
Great.  Yes all I want is just to pull the feed and update the database. As far as I can tell the only box that will be on both networks is the one whose only purpose is to update this database.


Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

This program is used to assist in finding and resolving common problems with wireless connections.
This article is in regards to the Cisco QSFP-4SFP10G-CU1M cables, which are designed to uplink/downlink 40GB ports to 10GB SFP ports. I recently experienced this and found very little configuration documentation on how these are supposed to be confi…
Viewers will learn how to connect to a wireless network using the network security key. They will also learn how to access the IP address and DNS server for connections that must be done manually. After setting up a router, find the network security…
NetCrunch network monitor is a highly extensive platform for network monitoring and alert generation. In this video you'll see a live demo of NetCrunch with most notable features explained in a walk-through manner. You'll also get to know the philos…

600 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question