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


SQL Express: backup plan
Introduction With the SQL Express version, it is not possible to set up a backup plan using SSMS. There are many scripts on the Internet for performing a backup, in this tutorial I will explain how to put in backup plan with a SQL Backup Master that

Install WSUS with a SQL Server database
Presentation Since Windows 2016 server, it is possible to install the Windows Server Update Service (WSUS) directly with a SQL Server database. In this article we will see how to proceed. Prerequisites To install WSUS with a SQL Server database you n

Optimize the space of SQL Server databases
Presentation In this tutorial I will show how to optimize the space used by databases. The optimization of the space is done in two stages: On the database: internal data optimization On files: reducing the size of the files on the disk. It is recomm

Leave a Comment