We have a Windows machine with MS SQL Server running on it and we want to connect to the database from a script running on a Linux machine. Can we just configure Sql Server to listen to a certain port and connect to it by specifying IP, port, database name, user and password, like we would with MySql? Or do we need to run SQL Server Browser Service to achieve that? Description of what this service actually does is vague, I don't get it. We have no reason to do things like listing databases or doing any anything extra. Just connect and select.
TCP/IP connection is already enabled in the SQL Server, there is no firewall installed, ping is successful, yet the port doesn't seem to be listened to. So I was wondering if that service is what is missing.