Results 1 to 8 of 8

Thread: How to add a MS SQL Server database??

  1. #1
    Kilo Poster
    Join Date
    Nov 2007
    Posts
    23

    Default How to add a MS SQL Server database??

    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. #2
    Kilo Poster
    Join Date
    Aug 2007
    Posts
    52

    Default

    Hi, I just set this up the other day and followed the info here to get going:

    http://forums.deftechgroup.com/showthread.php?t=300



  3. #3

    Default

    Quote Originally Posted by jadent View Post
    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
    Seems Ability to use Microsoft SQL Server option is Off in your Plesk License.



  4. #4
    Kilo Poster
    Join Date
    Aug 2008
    Posts
    28

    Default

    Quote Originally Posted by sergius View Post
    Seems Ability to use Microsoft SQL Server option is Off in your Plesk License.
    I have same problem.. option is Off

    Can be because is Trial license ??

    Thanks



  5. #5
    Kilo Poster
    Join Date
    Dec 2007
    Posts
    73

    Default

    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. #6
    Kilo Poster
    Join Date
    Dec 2007
    Posts
    73

    Default

    Quote Originally Posted by sergius View Post
    Seems Ability to use Microsoft SQL Server option is Off in your Plesk License.
    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. #7

    Default

    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/pl...ons/#mssql-win

    refers to Plesk 8.6.

    With one of the world's most advanced relational database management systems, Parallels Plesk Panel 8.6 for Windows enables users to deploy and manage MS SQL Server databases right from the user interface with a few clicks.
    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.
    Snowball Internet Service Provider
    Website hosting, co-location, virtual machine hosting, cloud hosting, ADSL, wireless internet
    Web: http://www.snowball.co.za
    Facebook: http://www.facebook.com/snowisp/
    LinkedIn: http://www.linkedin.com/company/snowball-effect-internet-service-provider/



  8. #8
    Bit Poster
    Join Date
    Nov 2010
    Posts
    1

    Default 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!



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •