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 with SQL Backup Master

IntroductionCreating a 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

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

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: reduci