Professionally I have a non-technical background and am just getting started with databases and SQL Server, so please bear with me.
I've come across this term called "connection string". What it does is connect an application to a database. In order to do that, one has to type in a connection string within the application. Is that correct?
Also, can I connect to a database from another (client) computer by running a connection string? If yes, how do I do that?
I already have a test database that I created in SQL Server Management Studio and was able to connect to it from another computer using Ethernet cable. I went through all these procedures of enabling TCP/IP and altering my Firewall's rules, so I'm just wondering if I could have done it through a connection string.