remote connection to SQL Server 2017

Navigation
0

I have a problem connecting remotely to SQL Server. I have the following:

  • A Windows 2012 R2 server, with SSMS 2017, and with SQL Express Edition.
  • A database, called Test, and the instance is SQLExpress.
  • I also have remote access enabled, ports 1433-1434, and additional I create a user with permission to access.
  

From an external device, I try to connect from an SSMS and I do not   find the remote SQL server; I can not do a test either,   from control panel / odbc.

Will it be necessary to open a port? The two previous ports are open, both in the windows server and in the firewall itself.

    
asked by Jordi Maicas Peña 15.08.2018 в 21:05
source

1 answer

-1

To configure the remote access option

  • In the Object Explorer, right click on a server and select Properties.

  • Click on the Connections node.

  • In Remote Server Connections, check or uncheck the box check Allow remote connections to this server.

    • I share a reference link:

    Remote Access Configuration SQL Server

        
    answered by 15.08.2018 в 21:57
    how to enable a button, with IsEnabled disabled How to send error or info messages to the view with ModelState?