How to add a MS SQL Server database??

Discussion in 'Parallels Plesk Panel for Windows - 8.x and Older' started by jadent, Jul 1, 2008.

  1. jadent

    jadent New Member

    Messages:
    23
    I just got a server with Plesk 8.4. MS SQL Server is installed as i can see it in the Plesk Services but when i try to add a database to a domain they only database server type to add is MySQL. If if i goto "Server -> Database Servers -> Add Database Server" in the "Database Server Type" drop down it only lists MySQL.

    How can i enable SQL Server? Thanks
  2. mr_c

    mr_c New Member

    Messages:
    52
  3. sergius

    sergius Parallels Team

    Messages:
    1,911
    Seems Ability to use Microsoft SQL Server option is Off in your Plesk License.
  4. webstyler

    webstyler New Member

    Messages:
    28
    I have same problem.. option is Off

    Can be because is Trial license ??

    Thanks
  5. gongcart

    gongcart New Member

    Messages:
    73
    for using mssql, you have to subscribe or purchase the application pack. But the application pack is outdated application pack. so you are paying more than you want to use. A force sale i would say.
  6. gongcart

    gongcart New Member

    Messages:
    73
    Jesus, why don't you just tell the poster if he purchase the application or not. The standard plesk license does not come with mssql option available. Plesk for windows, that mssql thing should be a standard, otherwise I don't know why you count it as for windows.
  7. eugenevdm

    eugenevdm New Member

    Messages:
    622
    As of September 23, 2010, does one still have to purchase a separate license in order to administer Microsoft SQL with Plesk? The only information I can find with regards to this:

    http://www.parallels.com/products/plesk/addons/#mssql-win

    refers to Plesk 8.6.

    We have a similar problem where on a newly installed Plesk 9.5 server the drop-down to administer Microsoft SQL is simply missing. I would prefer to not shell out $299 just to administer a free (SQL Express) database.
  8. WebJ

    WebJ New Member

    Messages:
    1
    Silly Solution (TRY THIS FIRST)

    I have spent hours (spread over 2 days) trying to figure out how to get MSSQL to show up as an option in the Dropdown for Select Server (Home > Database Servers > Add Database Server). All that showed up was MySQL. I am using Windows Plesk 9.5.2, but it is on a hosted solution and offered by the host.

    I tried EVERYTHING you will first find on this topic. And, as an aside: sending people to Parallel KB's is not necessarily helpful when those things did not work. Don't use the link in the first response on this thread.

    This is going to sound crazy if you did not think of it. I found this out by eventually getting this link http://forum.parallels.com/pda/index.php/t-84450.html. Looks like an archived link, which begs the question: why? When it solved my problem.

    The first step of the reply did the trick for me. I went to Home > License Management (under Help & Support). Look for "Ability to use Microsoft SQL Server". Mine originally said "Off". I clicked on "Retrieve Keys" toward the top (under the tab for Parallels Plesk Panel License Key) and VIOLA. I got some message that key was latest version. Went back to the License Management screen and BAM! it now said "On" for "Ability to use Microsoft SQL Server".

    Now, for my own part, I did update my initial Plesk license after I started my hosting solution on a virtual dedicated server to the Plesk Power Pack. So I don't know if this will benefit you if you got all of that at the same time.

    Hope this helps one poor soul from spending hours (like I did) trying to get this to work.

    When you see "On" you can follow the online documentation and go to Home > Database Servers > Add Database Server and you will now see MS SQL as an option in the drop down.

    Good luck!

Share This Page