• If you are still using CentOS 7.9, it's time to convert to Alma 8 with the free centos2alma tool by Plesk or Plesk Migrator. Please let us know your experiences or concerns in this thread:
    CentOS2Alma discussion

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