• Halloween is coming! To celebrate the occasion, we dusted off a couple of old skins, and even created a brand new one (Pixel).
    To get into the festive spirit, install the Skins extension.
  • The new Python extension is now available. It allows customers to deploy and manage WSGI-based Python applications on their websites directly from Plesk.
  • The Plesk Mobile apps for iOS and Android and the Plesk Mobile Center extension have been deprecated, and are no longer available for new installations. In Plesk Obsidian 18.0.84, the Plesk Mobile Center extension will be removed from servers during the upgrade, and the Plesk Mobile apps will lose their server management features.
  • The Social Login extension has been deprecated and will be removed in Plesk Obsidian 18.0.84. After that, it will no longer be possible to log in to Plesk with a Google, Facebook, GitHub account, or with a passkey. Plesk usernames and passwords, as well as logging in with a WebPros Account, are not affected.

How to install SQL Server 2005 Express Edition so that customers can use it?

E

electric

Guest
Hello,

I would like to install MS SQL Server 2005 Express Edition so our customers can have MSSQL databases.

How do I install the software so that they can use the MSSQL database functionality located in the plesk end-user (domain) control panel?

When I login as admin, I am unable to register the SQL Server, since only the "MySQL" option is availble in the drop-down box.

Any ideas? It would be nice if customers could use the plesk control panel to create/manage their MSSQL Server 2005 Express Edition databases. Otherwise, how do they manage things?
 
Install SQL Server 2005 on the server as normal. In the administration area, go to Server>Component Management and click the "Refresh" icon on the top. You should be able to see SQL Server under the SQL Server section. Your customers should be able to select SQL 2005. Hope this helps.
 
Yes, SQL Server is listed there.

SQL Server: Microsoft SQL Server 9.00.3042.00

It shows a green button, etc.

However, no SQL Server links are available to any customers when managing databases.

Any other ideas?
 
Same issue, now resolved

I was having the same issue where I could register the MSSQL database (sqlexpress) within Plesk 8.3 but was unable to then see the MSSQL option for database management. The advice given above where you need to "refresh" the components management area actually worked for me. Previously I did see the MSSQL installed and available however until I actually clicked the "refresh" button I was unable to manage the databases themselves via Plesk..
 
sergious,

Hello, i have the same problem.
I cannot add a mssql database, and the link you gave does not help, i cannot remove mysql or anything since its the only one, the mysql button is grey so i cannot remove it.
MSSQL is installed and running, its shows the green button too.

Thank you in advance!
 
I do have the same problem,
any Ideas?

The DB-creation link just gives me the option to create a MySQL DB.
 
You must log in or register to reply here.

Similar threads

J
Question Log outgoing emails from Plesk panel to users?
Replies
3
Views
2K
Kaspar
K
L
Question Plesk on Ubuntu 20.04: Can PHP 5.6 from Ondřej Surý PPA be installed safely as a custom PHP handler?
Replies
2
Views
355
tessa67
tessa67
D
Question IMAP default folders (Sent/Drafts/Trash) stay in English after mailbox creation – how do you solve this long-term?
Replies
5
Views
5K
dbmtrde
D
D
Issue Outgoing mail limit increase in UI didn't take effect — turned out to be a service plan sync bug (18.0.80)
Replies
3
Views
7K
Sebahat.hadzhi
Sebahat.hadzhi
M
Question How to restore Dropbox backups
Replies
2
Views
4K
tale
T
Back
Top