Network SQL Database Communication

Question

I have an application working perfectly with the BD in a notebook. But I would like to be able to access this database with my application through another device.

So I thought I’d do this network communication. But it turns out that I don’t know anything about networks and I’m not being able to orient myself on this subject nor the care I should have to have someone who doesn’t have access.

Where can I start researching to solve my problem? I need to create a local network through windows, or just by Configuration Manager I can do this communication?

Answer 1

Enable IP connections

In SQL Configuration Manager set up your instance to receive IP connections

Enable remote connections

In Sql Management Studio right-click on the server, properties, connections, enable remote connections as shown below:

Enable Connection by User and Password

In Sql Management Studio right-click on the server, properties, Security, Change connection mode to "Mixed mode", ie Windows user or SQL Server as per image below:

Create a user

Create a new user to connect to the server. Open the server database folder, right-click the Logons folder and New Logon, as shown below:

With these settings it should be possible to connect remotely via an Instantiative IP connection

In case of a permission error it may be necessary to enable port 1433 (standard SQL port on the firewall and grant permission to this database with this new user. But these settings are simpler and worth trying the connection with what has already been done above.