The web host accessible to all
Windows Plesk shared hosting 30 March 2021 By Aurélien T. 1 min read

MyLittleAdmin features

Procédure

What is MyLittleAdmin?

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.

Difference between the 'Lite' and 'Full' versions?

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
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
x
x
x
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
x
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

Going further

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

help.lws.net/a/1357
Was this article helpful?

Yes

No

Read 14 060 times

Thank you! Feel free to ask questions about our documentation if you would like more information, and help us improve it.

Similar articles

How do I create a database in Plesk? 1 min read How do I create an ODBC link in Plesk? 0 min read How do I export a database to Plesk? 3 min read How do I install myLittleAdmin on Plesk ? 6 min read

Questions about the article 1

Ask a question
urbanoll
14 Jan 2023
Suite à l'execution de requête, myLittleAdmin envoie l'erreur "Impossible d'afficher la page, car une erreur interne au serveur s'est produite."
Benjamin-LWS Official answer
23 Jan 2023

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)

Was this answer helpful?

A question about this article?

Ask the LWS team and the community. Answers are published after moderation.

Ask the LWS team and its community a question

GDPR: Controller: LWS-Ligne Web Services. Purpose: moderation and public publication of your question, possible notification of an answer. Legal basis: consent (Art. 6(1)(a) GDPR). Email retention: 90 days after notification, 12 months maximum without an answer. To exercise your rights, see the GDPR section of our Terms and Conditions.
About LWS :  LWS is a 100% French web hosting company that focuses on quality and innovation and offers a responsive and competent technical service at affordable prices.
Our services
ONLINE HELP
Resources
Language