How to access a sql server on remote machine from local?

Mar 13 2018 8:30 AM

I have to update a field in the table on click of a button by using windows service.The thing is the I have to access a remote server SQL for this update because the database and table are present in the remote machine.How to do it?