What is the root password for MySQL?
Unable to access Plesk: Access denied for user 'admin'@'localhost' (using password: YES)
Unable to import a database dump in Plesk: Unknown collation: 'utf8mb4_unicode_ci'
MariaDB service cannot start: InnoDB: Error: space header page consists of zero bytes in data file ./ibdata1
Unable to import database dump: ERROR 1062 (23000) at line: Duplicate entry for key
Inconsistency in Plesk Database: No rows in the table 'db_users' with id
How to upgrade MySQL 5.7 to MariaDB 10.2
Upgrade of MySQL schema with mysql_upgrade fails with the error: Error: Incorrect database name '#mysql50#.ssh'
Unable to open PHPMyAdmin: ERROR: Call to a member function getName() on null (ThemeManager.php:507)
MySQL database is not accessible: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'

See more

How to enable remote connections to MS SQL server?

Updated September 05, 2017 09:56

Applicable to:

Plesk for Windows

Question

How to enable remote connections to MS SQL server?

Answer

Run SQL Server Configuration Manager.
Go to SQL Server Network Configuration > Protocols for MSSQLSERVER .
Make sure that TCP/IP protocol is enabled.
Right click on TCP/IP > Properties > IP Addresses tab.
Go to IPAll section and specify "1433" TCP Port:
Restart MS SQL server. The simplest way is to open Control Panel > Administrative Tools > Services and restart it:

Comments

0 comments

Please sign in to leave a comment.