Unable to access myLittleAdmin in Plesk: myLittleAdmin Silent Logon Error

Symptoms

When clicking myLittleAdmin icon for MSSQL database on example.com subscription in Plesk, one of the following errors appears:

PLESK_ERROR: ERROR: Zend_Controller_Exception: Permission denied.#0 C:\Program Files (x86)\Parallels\Plesk\admin\externals\Zend\Controller\Plugin\Broker.php(309): Plesk\Application\Controller\Plugin\ForgeryProtection->preDispatch(Object(Zend_Controller_Request_Http)) #1 C:\Program Files (x86)\Parallels\Plesk\admin\externals\Zend\Controller\Front.php(941): Zend_Controller_Plugin_Broker->preDispatch(Object(Zend_Controller_Request_Http)) #2 C:\Program Files (x86)\Parallels\Plesk\admin\plib\Application\Web.php(39): Zend_Controller_Front->dispatch(NULL) #3 C:\Program Files (x86)\Parallels\Plesk\admin\htdocs\application.php(15): Plesk\Application_Web->run() #4 {main}
Message Permission denied.#0 C:\Program Files (x86)\Parallels\Plesk\admin\externals\Zend\Controller\Plugin\Broker.php(309): Plesk\Application\Controller\Plugin\ForgeryProtection->preDispatch(Object(Zend_Controller_Request_Http)) #1 C:\Program Files (x86)\Parallels\Plesk\admin\externals\Zend\Controller\Front.php(941): Zend_Controller_Plugin_Broker->preDispatch(Object(Zend_Controller_Request_Http)) #2 C:\Program Files (x86)\Parallels\Plesk\admin\plib\Application\Web.php(39): Zend_Controller_Front->dispatch(NULL) #3 C:\Program Files (x86)\Parallels\Plesk\admin\htdocs\application.php(15): Plesk\Application_Web->run() #4 {main}
File Broker.php
Line 312
Type Zend_Controller_Exception

or

PLESK_INFO: myLittleAdmin Silent Logon Error
Login failed for user 'USER_NAME'

or

PLESK_INFO: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
Provider=sqloledb;Data Source=.\\MSSQLSERVER2012;User Id=userdb;Password=*****;

or

PLESK_INFO: Connection timeout

or

PLESK_INFO: MyLittleAdmin commercial license key is installed

or

PLESK_INFO: This page can't be displayed. Make sure the web address is correct. Look for the page with your search engine.

or

PLESK_INFO: HTTP Error 404. The requested resource is not found

or

PLESK_INFO: Server Error
404 - File or directory not found

or

PLESK_INFO: myLittleAdmin Silent Logon Error
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

Cause

• Domain names mssql.example.com and example.com are not resolved to current Plesk server.

• MyLittleAdmin is not licensed for additional servers.

Resolution

1. Make sure domain example.com resolves properly . Otherwise, contact domain registrar and check the DNS settings.

   Note: DNS propagation may take up to 24-48 hours.

2. Check if the following 'A' records are present in domain's dns zone at:
   Domains > example.com > Website & domains > DNS settings

   CONFIG_TEXT: mssql.example.com A 203.0.113.2
   example.com A 203.0.113.2

3. Make sure that MyLittleAdmin is licensed for additional SQL Server instance.

4. Add the following record to the Windows hosts file for a particular machine if required:

   CONFIG_TEXT: 203.0.113.2 mssql.example.com