Press "Enter" to skip to content

SQL Server configure remote access

0

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 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 schedule and then we will modify the plan to indicat

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

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

Leave a Reply

Your email address will not be published. Required fields are marked *

It looks like you're using an adblocker.
We use ads to keep our content free. Please support us by turning off your adblocker.