• 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.

e0aff7830fa22f92062ee4db78133079 caea8340e2d186a540518d08602aa065

Email subscription for changes to this article
Save as PDF