• Article for your preferred language does not exist. Below is international version of the article.

Article ID: 118540, created on Nov 11, 2013, last review on Aug 12, 2014

  • Applies to:
  • Plesk Automation

Symptoms

How do I enable remote connection to MSSQL server?

Resolution

Please use the "SQL Server Configuration Manager" to enable remote connections. The following should be done:

  1. Run SQL Server Configuration Manager.

  2. Go to SQL Server Network Configuration > Protocols for MSSQLSERVER.

  3. Make sure TCP/IP is enabled.

  4. Right click on TCP/IP > Properties > IP Addresses tab.

  5. Go to IPAll and specify 1433 TCP Port.

  6. Restart MSSQL server.

Search Words

mssql remote connection

e0aff7830fa22f92062ee4db78133079 caea8340e2d186a540518d08602aa065

Email subscription for changes to this article
Save as PDF