1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice

Don't see MS SQL in Plesk?

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

  1. Pauli

    Pauli Guest

    0
     
    MS SQL is installed on the server but I don't see it in Plesk under the database button - only MySQL. I have a company that built and manages the server and they said that they installed it it in the correct order - sql then plesk.

    No one seems to know why it isn't showing up.

    Any suggestions?

    Oh yeah and did I mention that I can't get web mail to work or even logon through Frontpage because of permission problems which I know are good.

    It looks like a great product - if it worked.

    BTW it's a win2003 box.

    Any help is greatly appreciated.
     
  2. ibs2

    ibs2 Guest

    0
     
    If I understand well, I think you are mistaken.

    Thats what I recently learned: Plesk installs a MSDE ("de" stands for desktop edition), somekind of standalone runtime of MS with no administration. From plesk you create databases and database users, then you must use a 3rd party tool for managing tables and so.

    The availabilty of MS at plesk depends on the license. No matter if MS is installed prior to plesk, if you don't buy the aditional pack (99$), Plesk does not allow you to use MS.

    This post may help you:

    http://forum.plesk.com/showthread.php?s=&threadid=12757

    For frontpage permissions, contact plesk support. It worked for me.
     
  3. Pauli

    Pauli Guest

    0
     
    MSDE is used if you don't have the full version - I have the full version which includes enterprise manager.

    I shouldn't have any problems, I am using enterprise packages which cost a lot of $$$

    Thanks for the feedback
     
  4. bdee1

    bdee1 Basic Pleskian

    23
    57%
    Joined:
    Mar 15, 2004
    Messages:
    43
    Likes Received:
    0
    i just got a Dedicated server with plesk (no SQL support) then i installed SQL server 2000 Standard and asked my server provider to install SQL support in plesk.

    it worked for a couple hours and then stopped. while it was working i was able to create 1 database and was able to go into enterprise manager and see that there were 2 instances of SQL server (Local and the named instance that i installed) the local install must have been MSDE - the local was the one that my databse was created in.

    at this point i realized that the plesk SQL support pack must have installed MSDE, but i want plesk to use the SQL server standard, not MDSE.

    so.... i uninstalled my named instance of SQL server and then with the SQL Server install program, upgraded MSDE to SQL server 2000 standard.

    thats when plesk stopped working with the database.

    and enterprise manager woudl nto open the local instance either.

    so my quetions are:

    1) how do i fix plesk so it interacts with SQL correctly?
    2) what is the proper way to make plesk work with SQL Server 2000 Standard instead of MSDE.
     
Loading...