1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    Dismiss Notice

Issue How do I remove the default MSSQL server?

Discussion in 'Plesk Onyx for Windows' started by JM Tech, Nov 8, 2017.

  1. JM Tech

    JM Tech New Pleskian

    1
    20%
    Joined:
    Nov 8, 2017
    Messages:
    1
    Likes Received:
    1
    Location:
    Australia
    I offer MySQL databases and was exploring also offering MSSQL databases so I installed MSSQL 2016 through Plesk and added in the MSSQL database server as the default MSSQL database server. I have since decided not to offer MSSQL databases so have followed the instructions to remove MSSQL - which I have done successfully, but I can't remove the Database for the list of databases. It doesn't let me select it (I presume because it's the default).

    This is annoying because it appears in the dropdown of database servers when I go to make a database - even though the server doesn't exist any more.

    plesk repair mssql -connection only tells me that it can't connect - it doesn't repair it by removing the database server.
     
    Karim Kanoun likes this.
  2. IgorG

    IgorG Forums Analyst Staff Member

    49
    24%
    Joined:
    Oct 27, 2009
    Messages:
    24,557
    Likes Received:
    1,241
    Location:
    Novosibirsk, Russia
    .I think that you need to remove records in Plesk database. Please go to Plesk database with

    plesk db

    and explore tables DatabaseServers, data_bases, db_users. You need to find id of needed database server and use it for finding out all related records in data_bases, db_users for removing.
    Contact Plesk Support Team if you are not familiar with SQL.
     
Loading...