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

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

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.

System administration
SQL Server
Soutenir
LinkedInReddit

📚 Articles similaires

Romain Drouche
System Architect | MCSE: Core Infrastructure
IT infrastructure expert with over 15 years of field experience. Currently a Systems and Networks Project Manager and Information Systems Security (ISS) expert, I use my expertise to ensure the reliability and security of technological environments.

Leave a Comment