• Debian 11 is approaching its end-of-life (vendor EOL date - August 31, 2026). Plesk Obsidian 18.0.80 will be the last release to support it.
    If you are running Plesk Obsidian on Debian 11, we recommend you upgrade those servers to Debian 12 using our dist-upgrade tool.
  • We plan to deprecate and remove the support for XML RPC protocol versions earlier than 1.6.9.1 in Plesk Obsidian 18.0.82. We strongly recommend that you update all existing integrations using earlier versions of the XML RPC protocol to comply with the version 1.6.9.1 specification.

Plesk 12.5 switch DB Provider not showing MSSQL

Nguyen_Dinh_Tinh

New Pleskian
Hi all.
I have a trouble after installing Plesk 12.5. These are my step:
- Install IIS, .NET, MVC
- Install MSSQL Server 2012 Standard
- Install Plesk 12.5
So, on Plesk Panel, I have added MSSQL Server successfully.
Now I want to switch DB Provider to MSSQL. I open Plesk Reconfigurator and chose "Switch DB provider" --> It show only MySQL provider, not include MSSQL.
Capture.jpg

Capture2.jpg

I've tried to run this command from dbupgrade
dbupgrade.exe --switch-plesk-database --new-provider=MSSQL --host=localhost --admin-login=sa --admin-password=vs42y@krTP8DK# --db=psa --login=psauser --password=p8C8LaYHsC
but no luck. It show Unexpected Parameter "--new-provider=MSSQL". I tried to delete this parameter and then changed --host=MSSQL, and run again, but it shown unknown MySQL Server Host.

Switching DB...
Exporting DB...
Stopping service plesksrv...
Starting service plesksrv...
Failed to connect to database: Unknown MySQL Server Host 'MSSQL' (11001)


Does anyone get this error before and can help me?
Thanks alot.
 

Attachments

  • Capture.JPG
    Capture.JPG
    56 KB · Views: 2
  • Capture2.JPG
    Capture2.JPG
    36.3 KB · Views: 2
I have found that according to our internal document PPP-15993 MSSQL support as a control panel database has been dropped in Plesk 12.5
Therefore you can't switch database engine to MSSQL for psa database.
 
Back
Top