• Our team is looking to connect with folks who use email services provided by Plesk, or a premium service. If you'd like to be part of the discovery process and share your experiences, we invite you to complete this short screening survey. If your responses match the persona we are looking for, you'll receive a link to schedule a call at your convenience. We look forward to hearing from you!
  • We are looking for U.S.-based freelancer or agency working with SEO or WordPress for a quick 30-min interviews to gather feedback on XOVI, a successful German SEO tool we’re looking to launch in the U.S.
    If you qualify and participate, you’ll receive a $30 Amazon gift card as a thank-you. Please apply here. Thanks for helping shape a better SEO product for agencies!
  • The BIND DNS server has already been deprecated and removed from Plesk for Windows.
    If a Plesk for Windows server is still using BIND, the upgrade to Plesk Obsidian 18.0.70 will be unavailable until the administrator switches the DNS server to Microsoft DNS. We strongly recommend transitioning to Microsoft DNS within the next 6 weeks, before the Plesk 18.0.70 release.
  • The Horde component is removed from Plesk Installer. We recommend switching to another webmail software supported in Plesk.

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