How to add a MS SQL Server database??

[jadent]

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

 

[mr_c]

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

 

[sergius]

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.

 

[webstyler]

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

 

[gongcart]

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.

 

[gongcart]

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.

 

[eugenevdm]

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.

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.

 

[WebJ]

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!