SQL Server configure remote access

This article describes how to configure remote access to a SQL Server (EXPRESS).

1. Open the SQL Server Configuration Manager.
SQL Server Configuration Manage

2. Go to SQL Server Network Configuration / Protocols for SERVER NAME, then right-click TCP / IP and click Properties.

3. Go to the IP Addresses 1 tab and then search for the IPAll 2 section. Enter the port number 3 (default 1433) and click on Apply 4 then OK 5 .
SQL Server port 1433

% start_p_primary% If a firewall is active, think about opening the port.% end_p%

4. Close the warning message by clicking OK 1 .
message

5. Go to SQL Server Services 1 , right-click the SQL Server 2 service, and click Restart 3 .
Restart service

6. Wait while restarting …
wait

7. For example, you can use SSMS from a remote server.



Related Posts


Sharepoint 2013 foundation: installation and configuration

In this tutorial, we will see how to set up Sharepoint 2013 foundation on Windows 2012R2. Although this version at the time of writing this article is more than 5 years old, it allows to discover Shar

SQL Server: Set up a backup plan

Introduction In this article, I will explain how to set up a backup plan with SQL Server. In this tutorial, we will use the wizard available in SSMS to configure the database to save as well as the sc

SQL Server Restore a Database from a Backup (BAK)

Introduction In this tutorial, I will show you how to restore a SQL Server database from a backup file (BAK). To perform the restore, you must have SQL Server Manager Studio (SSMS). Restore a database