Skip to content

virtual-machines-sql-server-connection-tcp-protocol.md

Latest commit

 

History

History
24 lines (16 loc) · 1.31 KB

virtual-machines-sql-server-connection-tcp-protocol.md

File metadata and controls

24 lines (16 loc) · 1.31 KB
author rothja
ms.author jroth
ms.date 10/26/2018
ms.service azure-vm-sql-server
ms.topic include

  1. While connected to the virtual machine with remote desktop, search for Configuration Manager:

    Open SSCM

  2. In SQL Server Configuration Manager, in the console pane, expand SQL Server Network Configuration.

  3. In the console pane, click Protocols for MSSQLSERVER (the default instance name.) In the details pane, right-click TCP and click Enable if it is not already enabled.

    Enable TCP

  4. In the console pane, click SQL Server Services. In the details pane, right-click SQL Server (instance name) (the default instance is SQL Server (MSSQLSERVER)), and then click Restart, to stop and restart the instance of SQL Server.

    Restart Database Engine

  5. Close SQL Server Configuration Manager.

For more information about enabling protocols for the SQL Server Database Engine, see Enable or Disable a Server Network Protocol.