SQL Network Database Communication

Question

SQL Network Database Communication

Navigation

#1 by (2 votes)

0

I have an application that works perfectly with BD on a notebook. But I would like to be able to access this database through another device.

So I thought about doing this communication over the network. But I happen to know nothing about networks and I can not steer myself on this subject or the care I must take to get unauthorized access.

Where can I start searching to solve my problem? Do I need to create a local network through windows, or just through the Configuration Manager with this communication?

sql-server network sql-server-express

asked by anonymous 09.10.2017 / 16:39

1 answer

How forms are opened - Visual Studio (Segment fault fault) Make a program that receives two distinct sentences and prints inverted

score 2 · Accepted Answer

Enable IP connections

In SQL Configuration Manager configure 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:

EnableUserLoginandPassword

InSqlManagementStudiorightclickontheserver,properties,Security,Changetheconnectionmodeto"Mixed mode", that is, Windows user or SQL Server as shown below:

Createauser

Createanewusertoconnecttotheserver.Opentheserverdatabasefolder,right-clicktheLoginsandNewLogonfolder,asshownbelow:

With these settings it should be possible to connect remotely over an IP connection \ InstanceSQLServer

If a permission error occurs, it may be necessary to enable port 1433 (default SQL port on the firewall and grant permission for this database with this new user.) But these settings are simpler and worth attempting to connect to. which has already been done above.