Remote connect SQL Express

  1. Start SQL Server Surface Area Configuration > Remote connections
  2. SQL-Surface
  3. Select “using both TCP/IP and named pipes”
  4. Start “SQL Server Configuration Manager”
  5. Find out the dynamic port
  6. SQL-dynamicPort
  7. Now connect to the SQL server from a remote server:
  8. HOSTNAMESERVER\MSSQL$SQLEXP_VIM,49382
  9. sql-connect

Author: Thomas Faddegon

Do you like my posts and want to do something back? You can buy me a beer :)