Rate this article :
This article was useful to you ?
Yes
No
Vous avez noté 0 étoile(s)
Procédure
MyLittleAdmin is the utility offered in our Plesk packages to enable SQL Server database users to act on their database from their browser.
Although this utility can provide many services, it also has some limitations that we will review in this documentation.
By default, MyLittleAdmin is offered as a Lite version (free of charge), but it is also available as a 'Full' version if you purchase a licence directly from the tool's publisher: http: //www.mylittleadmin.com/en/welcome.aspx.
Here is a table summarising the features available in the "Lite" and "Full" versions:
Full Version | Lite Version (free) | |
Connection SQL Server and Windows authentication Network protocols and other options |
|
x x |
Databases System, Snapshot and User databases List Create, delete, rename Properties, Permissions, Extended Properties |
x x x x |
x x x (properties only) |
Tables System and User tables List Create, delete, rename, modify View dependencies Quick data edit Export data to XLS, XML, CSV Properties, Permissions, Extended Properties |
x x x x x x x |
x x x x x (properties only) |
Columns List Create, delete, rename, modify Properties, Permissions, Extended Properties |
x x x |
x x (properties only) |
Keys Foreign and primary keys list Create, delete, rename, modify |
x x |
x |
Constraints List Create, delete, rename Properties, Extended Properties |
x x x |
x x (properties only) |
Triggers List Create, delete, rename, modify View dependencies Extended Properties |
x x x x |
x x |
Indexes List Create, delete, rename Properties, Extended Properties |
x x x |
x x (properties only) |
Statistics List Create, delete Properties |
x x x |
x x (properties only) |
Views System and User views List Create, delete, rename, modify View dependencies Export data to XLS, XML, CSV Properties, Permissions, Extended Properties Columns, Triggers, Indexes, Statistics |
|
x x x x (properties only) x |
Synonyms List Create, delete Properties, Permissions, Extended Properties |
x x x |
x x (properties only) |
Stored Procedures System and User stored procedures List Create, delete, rename, modify View dependencies Properties, Permissions, Extended Properties Parameters list |
x x x x x x |
x x x x (properties only) x |
Functions System and User table-valued functions System and User scalar-valued functions List Create, delete, rename, modify View dependencies Properties, Permissions, Extended Properties Parameters list |
x x x x x x x |
x x x x x (properties only) x |
Database Triggers List Create, delete, modify Extended Properties |
x x x |
x |
Assemblies List Delete |
x x |
x |
Types System data types, User-defined data types, User-defined types, XML schema collections List Create, delete, rename, modify View dependencies Properties, Extended Properties |
x x x x x |
x x x x (properties only) |
Rules List Create, delete View dependencies Properties, Extended Properties |
x x x x |
x x x (properties only) |
Defaults List Create, delete View dependencies Properties, Extended Properties |
x x x x |
x x x (properties only) |
Service Broker Message types, Contracts, Queues, Services, Routes, Remote Service Binding List Delete |
x x x |
x x |
Storage Full Text Catalog, Partition Schemes, Partition Functions List Create, Modify, Delete |
x x x |
x x |
Users List Create, delete, rename Properties, Extended Properties |
x x x |
x |
Roles Database roles, Application roles List Create, delete, modify Properties, Extended Properties |
x x x x |
x x |
Schemas List Create, delete, modify Properties, Permissions, Extended Properties |
x x x |
x |
Symetric and Asymetric Keys List Delete Properties |
x x x |
x |
Certificates List Delete Properties |
x x x |
x |
Logins List Create, delete, modify Properties |
x x x |
x |
Server roles List Properties |
x x |
x x |
Credentials List Delete Properties |
x x x |
x x |
Backup devices List Create, delete Properties |
|
x x |
Linked servers List Delete Properties |
x x x |
x |
Server Triggers List Create, delete, modify |
x x |
x |
Activity monitor Process List |
x |
|
Tools and wizards New query tool Generate INSERT script wizard CSV Import wizard Backup wizard Restore wizard Detach wizard Attach wizard Shrink database wizard Change password wizard |
x x x x x x x x x |
x |
Preferences Multi language Multi skin |
x x |
x x |
Misc. Ability to enable/disable each feature Ability to get the T-SQL script of each action Silent logon module and much more ! |
x x x x |
x x x |
If you wish to install the full version of MyLittleAdmin after acquiring the licence, you can do so by following this procedure: https: //help.lws-hosting.com/en/How-to-install-myLittleAdmin-on-Plesk
Rate this article :
This article was useful to you ?
Yes
No
1mn reading
How do I create a database in Plesk?
0mn reading
How do I create an ODBC link in Plesk?
0mn reading
How do I export a database to Plesk?
0mn reading
How do I install myLittleAdmin on Plesk?
Bonjour, merci pour votre question,
L'erreur "Impossible d'afficher la page, car une erreur interne au serveur s'est produite." est générée lorsqu'une erreur interne se produit sur le serveur lors de l'exécution d'une requête. Il existe de nombreuses raisons pour lesquelles cela peut se produire, telles que des erreurs de configuration de serveur, des problèmes de mémoire, des erreurs dans les scripts PHP ou des problèmes de base de données.
Dans votre cas, il se peut que l'erreur soit dû une erreur de certificat de votre sous-domaine "mssql".
Ce sous-domaine est créé par défaut lors de l'achat de votre formule ASPNet, si vous l'avez supprimé, il vous suffira de le recréer sur Plesk et le certificat de ce sous-domaine sera automatiquement régénérer par la suite.
Nous vous invitons à contacter notre service support à travers votre espace client, afin de vous apporter une aide sur le problème que vous rencontrez. (https://aide.lws.fr/a/268)