WebAdmin link for MSSQL database shows 404 page not found

Error:

WebAdmin link for a Plesk user’s MSSQL database shows 404 page not found.

Login To Plesk >> Databases >> WebAdmin show below error(Redirects to URL below):

Server Error in ‘/’ Application.
The resource cannot be found.
Description: HTTP 404. The resource you are looking for (or one of its dependencies) could have been removed, had its name changed, or is temporarily unavailable. Please review the following URL and make sure that it is spelled correctly.

Requested URL: /mssql/app/connect.aspx

Version Information: Microsoft .NET Framework Version:2.0.50727.3649; ASP.NET Version:2.0.50727.3618

Solution:

1. Firstly try to ping the sub-domain mssql.mydomain.com and check if it is working or not, if not, you need to create a dns entry for mssql. If the same error still persists, you can run the following commands in the ‘cmd’.

2. Run the commands one by one in ‘cmd’

> cd %plesk_bin%

> websrvmng.exe –reconfigure-sqladmin
> defpackagemng.exe –fix –type=sqladminmssql

---