How to broadcast data from a SQL server to an IP an Port

[Triacona]

Hi all,

Thanks for a great forum.

I hope this is the right topic for this query?

I have the following issue.

I have a server, which has SQL server and a database, for car parking data ( spaces total and spaces left ).

I want to broadcast each car parks spaces left to the Server IP and ports ( about 5, one for each car park ).

How would I go about this?

I have looked at the MS sites, one is

https://docs.microsoft.com/en-us/sq...n-on-a-specific-tcp-port?view=sql-server-2017

I want to continuously broadcast that data to the IP and ports, so the data is always live.

The server requesting data from those ports, outputs that data onto a website.

Where do I start?

What should I ensure is in place before transmitting the data?



Thanks for your help on this

Thank you,

Kind regards

Triacona

 

[NoCoolHandle]

Ok.. the link is really just to set up what PORT is open on that server to communicate over. IE all clients (applications) by default try to connect to sql on port 1433. However as this is a known port that all hackers are aware of, having port 1433 open on a public network can be a serious issue. It is usually best to just have your firewall do some port forwarding ie.. traffic on port 60123 is redirected to port 1433 of you sql ip.

if you have a web page that needs to read data from one of your sql systems and they are on the same network. no need to worry, just set up the connection string to that server and read the data directly. (again be careful if this is public as you do not want to expose port 1433 to the internet)

If you want to PUSH the data from sqlserver to a central sql system - look into replication.

HTH

Rob

 

[fredericofonseca]

see

https://www.tek-tips.com/viewthread.cfm?qid=1792690

for more info -



Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

FAQ219-2884
FAQ181-2886