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

Why is the MSDE version of SQL Installed?

Discussion in 'Plesk for Windows - 8.x and Older' started by chernobl, Feb 20, 2004.

  1. chernobl

    chernobl Guest

    0
     
    Why is the MSDE version of SQL Server installed? We have a production SQL Server that we want to provision accounts on. Does this require the SQL support add-in? Can I remove the SQL MSDE version or will that cause something to break?

    please advise,
    Anthony Biondo
    Biondo Communications
    http://www.biondocomm.com
     
  2. siren@

    siren@ Guest

    0
     
    You need to install MS SQL prior to installing Plesk. Once you have installed MSSQL you can then install Plesk and it will not install MSDE. Also, MSDE can be upgraded by a full version of MSSQL. This is not recommended by Plesk, but I see no reason it would not work since Plesk does not use the MSDE version.

    Also, to utilize any creation or deletion abilities through Plesk for MSSQL (even the MSDE version) you have to have the SQL addon.
     
  3. chernobl

    chernobl Guest

    0
     
    Hi Larry:

    thanks for responding. We want to have a SQL Server not on the same box as Plesk. We have a box that just does SQL and a box just for web. Is this supported with the MSSQL support. when I talked to the sales reps at Plesk that made it sound like a no brainer.

    thanks for your help,
    Anthony
     
  4. psillars

    psillars Guest

    0
     
    Not sure if you have got a reply from anyone else. We installed Plesk and found it had installed MSDE without us knowing. I have successfully upgrade this to SQL Server standard edition with very few problems.

    The MSSQL addon only seems to allow management of a local MS SQL at this time. It also does not do much more (that I can figure out) than create a database and users for that database.

    If you want to use a seperate MS SQL server, then it will not control it at all. You do not need the MS SQL add-on, you can just use the ODBC manager to create ODBC connections out to your MS SQL server, probably manually.

    I am hoping that Plesk 7 for Windows will give us some more useful features for MS SQL.
     
  5. siren@

    siren@ Guest

    0
     
    You can't manage an external SQL server with Plesk, I don't even think this is an option.

    You can setup ODBC for an external SQL Server
     
  6. joelmoss

    joelmoss Guest

    0
     
    anyone know where I can get a cheap copy of MSSQL server to work with Plesk?
     
  7. mazeman

    mazeman Guest

    0
     
    you can search on ebay..I got a 5cal std edition for $50
     
  8. emsol

    emsol Guest

    0
     
    Where can I get SQL Server standard edition ?
     
  9. siren@

    siren@ Guest

    0
     
    Just an update. I was just looking at our beta of Plesk 7 for Windows. It allows the selection from Localhost to a different location. Not sure if it will work as I can't test it right this minute (maybe a bug in beta), but the option is there. :)
     
  10. atinoco

    atinoco Guest

    0
     
    Can anyone share some experiences on the Upgrade process from MSDE to MS SQL Server 2000.

    How is it done? any problems or issues?

    -Andres Tinoco
     
  11. psillars

    psillars Guest

    0
     
    HI,

    On 6.5 the upgrade process is actually quite smooth from MSDE to MS SQL server. Just copy the SQL install files across and run the install. It will actually bring all the settings across from MSDE into MS SQL. You may need to know the sa password for MSDE, (can't remember if you do) If you have the SQL plugin for Plesk you can just reset it before the upgrade if you wish.

    Make SURE you put Service Pack 3a on as soon as you have done the upgrade, or you may leave yourself open to abuse.

    The only problems we have had (and this is on a production server), is that you can't get Enterprise Manager working correctly locally. We have found this to be a general issue relating to MSDE upgrades, not just those relating to Plesk.

    Hope these thoughts help
     
  12. atinoco

    atinoco Guest

    0
     
    TY for the quick reply. I will begin tests on a local test server soon.

    Are you able to use Enterprise Manager Remotely? Can the plesk MS SQL addon be activated after the MS SQL Server install?

    Thanks again.

    -Andres
     
  13. psillars

    psillars Guest

    0
     
    Simple Answer

    Yes and Yes !!
     
  14. atinoco

    atinoco Guest

    0
     
    TY for the info my friend

    -Andres Tinoco
     
  15. atinoco

    atinoco Guest

    0
     
    Just did an upgrade on a clean test server from MSDE to SQL server Standard, everything seems ok, but i got an error at the end of the upgrade, it said "Error cleaning up Desktop Engine Installation, refer to setup logs for addtional detail" then the setup seems to complete with success..

    what does this mean? should i worry about it?

    Thanks in Advance

    Andres.
     
  16. psillars

    psillars Guest

    0
     
    I would think that would be fine. Obviously I am sure you know that MSDE, stands for Microsoft Desktop Engine, so all it is saying is it could not clean up a few of those files.

    I think I may have had the same error as you, but our production server is running fine after the upgrade
     
Loading...