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

How to manually change the SQL Server location?

Discussion in 'Plesk 9.x for Windows Issue, Fixes, How-To' started by OctavioC, Apr 5, 2011.

  1. OctavioC

    OctavioC Guest

    0
     
    Hello,

    I have my plesk config stored on the build in SQL server (2008 express) and now it is expired...
    I also have installed another SQL server (2008 Enterprise) on other instance, I successfully moved the plesk database from the SQL Express to the SQL Server Enterprise, but now I don’t know how to point the plesk to use the Enterprise SQL server instead of the old one... How can I do? There is any file that I could edit to accomplish this?

    Note: I don’t want to reinstall or upgrade the "SQL Server Express", just to point the plesk to use the instance of the SQL Enterprise Server...

    Thanks,
    Octavio.
     
  2. OctavioC

    OctavioC Guest

    0
     
    I am using Plesk 9.0.1 build090128.13 for Windows, on Windows 2008 x64.
     
  3. OctavioC

    OctavioC Guest

    0
     
    Hello,

    I figured it out, it’s on the registry:

    MS SQL server location and port:
    HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\PLESK\PSA Config\Config\MySQL_DB_HOST
    On this format:
    server,port

    The database username is on:
    HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\PLESK\PSA Config\Config\PLESK_DATABASE_LOGIN

    And the password it’s the same one of the admin user of Plesk. (You should create this username on the SQL Server and assign the required permissions to use the Plesk database)

    Octavio.
     
  4. RonanM

    RonanM Guest

    0
     
    I'm planning an SQL migration, thank you

    I'm planning an SQL migration from SQL 2008 Standard x86 to SQL 2008 Enterprise x64. I plan to detach the database, copy over the files to the new SQL server and then wanted to know how to point Plesk to it. The fact that the new SQL server is on a different machine ought no matter right? Any thoughts, or suggestionson how best to proceed are appreciated. I'm also using Plesk 9.0.1. Thanks.
     
  5. VipinV

    VipinV New Pleskian

    19
    85%
    Joined:
    May 25, 2009
    Messages:
    11
    Likes Received:
    0
    Location:
    India
    Ronan,

    You will need to add the new instance via Plesk. Then update the database server id in all the databases in Plesk database (psa db).
     
Loading...