When installing sql express on a server and on the same network I have a client machine with which I want to enter the bd engine but I can not, previously I had been told that the sql express has to make a configuration but the truth is not what configuration.
configure sql express
0
2 answers
1
so you can connect to another pc, when you install the authentication mode in mixed and you create a user, then make sure you have these options configured 
.
answered by 28.10.2016 / 22:20
source
2
The most common is to enter SQL Server through a network using the TCP / IP protocol.
SQL Express installs the disabled protocol by default, so you must enable it.
In Windows 10,
- go to the administrative tools of the control panel
- enters team management
- Services and applications
- SQL Server configuration manager
- SQL Server Network Configuration
- Protocols for the name of your instance
- look for TCP / IP in the right pane, enable it and go.
In addition, you can adjust in the properties by which of the network interfaces you will be listening and the port (by default the port is 1433).
In other versions of Windows, look for the SQL Server configuration manager in the start menu.
answered by
28.10.2016 в 22:14