Solved

Dual Netwok

Posted on 2004-08-31
3
312 Views
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?

Thanks!!!
0
Comment
Question by:OptionsMM
3 Comments
 
LVL 3

Expert Comment

by:slappa1
Comment Utility
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.
0
 
LVL 4

Accepted Solution

by:
jonnietexas earned 500 total points
Comment Utility
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.
0
 

Author Comment

by:OptionsMM
Comment Utility
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.




0

Featured Post

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

Let’s list some of the technologies that enable smooth teleworking. 
If your business is like most, chances are you still need to maintain a fax infrastructure for your staff. It’s hard to believe that a communication technology that was thriving in the mid-80s could still be an essential part of your team’s modern I…
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…
After creating this article (http://www.experts-exchange.com/articles/23699/Setup-Mikrotik-routers-with-OSPF.html), I decided to make a video (no audio) to show you how to configure the routers and run some trace routes and pings between the 7 sites…

744 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now