Accessing and managing MSSQL databases via myLittleAdmin tool

myLittleAdmin is a web-based MSSQL Server administration tool. It brings a rich graphical interface for database management through a browser. It can perform  the same operations as the SQL Server Management Studio from Microsoft. Practically, it has the same structure of database viewing and way of working with it. When using myLittleAdmin, you can add/remove/modify tables, rows, security settings of the database, execute sql queries using interface similar to SQL Server Management Studio, but without necessity to download and install any large application on the local computer. 

To start using this tool first login to the myLittleAdmin interface by visiting the following link:

https://mla.ixwebhosting.com URL. You will need the following information to login:

  •  Server name. You can select it from the list of our servers.
  • Authentication: SQL Server Authentication
  • Database name
  • Database Username
  • Database Password

If you do not have these details, please login to your H-Sphere control panel and click on the MSSQL Server icon to verify the database username and its password. You can obtain this information by accessing your H-Sphere control panel. For more information please follow the following links: 

how to create a MSSQL database: Creating an MSSQL Database

how to create a MSSQL database user: Creating an MSSQL Database User

Here is a little interface guide for myLittleAdmin:

mylittle

1. Main interface. 

mylittle2.1

 

Navigation bar. The navigation bar offers several sections:

  • Connection:  You’ll be able to display connection info and to disconnect.
  • Databases: This is the main section of myLittleAdmin. The treeview allows you to navigate through all objects of all databases(including system databases and snapshot databases).
  • Security: This is where server security objects (like logins, roles or credentials) are located.

  • Server Objects: This is the place where server objects are located.

  • Management: This section allows to check the server activity and to display the error log.

  • Tools: Useful tools and wizards provided with myLittleAdmin are located in this section.
  • Preferences: Where language, skin and other display options can be changed.
  • Help: Offers direct link to myLittleAdmin Community Forums.

 

2. Content zone.

mylittle3.1

The content zone is always built with 4 zones:

  • Navigation icons: Click the folder icon to go one level up. Click the refresh icon to refresh the current page. Click the  to arrow icon to synchronize the navigation bar with the content zone.
  • Object info: Displays the object name and its path in the SQL Sever hierarchy.
  • Action icons: Several icons can be found here, depending on the object type.
  • Content: This is where list and forms are displayed. 

 

CREATING OBJECTS

Creating a table:

mylittle5.1

  • Creating a table with myLittleAdmin can be done in a few clicks.:
  • Display the table list of your database 

  • Now click the icon. The table creation form is now displayed. 

mylittle6.1

  • Start to choose the schema this new table will belong to. Default value is dbo.

  • Then give this new table a name.

  • At last, define the columns of this new table. When checked, the key checkbox specifies that this column will be part of the primary key. For each column, you must specify a name and a type.

  • Once this has been done, click the Create button. 

Tip: By clicking on the icon, you will display the Transact SQL script to create the table. 

Adding a relationship to a table:

mylittle7.1

  • Expand the treeview down to the specified table.
  • Click on the Keys link.
  • Now click on the icon. The relationship (foreign key) creation form is now displayed. 
  • Give the foreign key a name
  • Choose the primary key table.
  • Then choose the column(s) from this primary key table that will be used for the relationship.
  • At last, choose the column(s) from the foreign key table that will be used for the relationship
  • Click the Create button. 

 

Displaying and editing table content:

  • Display the table list.
  • Click on the table you want to display/edit content.
  • In the contextual menu, choose Open Table. 

mylittle8

 

  • Icon allows to export the content of the table in XML, XLS and CSV format.
  • Icon allows to add a new record in the table.
  • Use the icons to navigate through the content.
  • Use the icon to filter the content.
  • Click the icon to delete a row.
  • Click the icon to edit the record in a form.
  • Click the icon to edit the record in a form.

 

mylittle12

 

Tip: You can edit column value directly inside the grid. Just click on the value you want to edit. A textbox will appear; make the change and hit the Enter key. Hitting the Escape key will cancel the change. 

 

mylittle13

 

You can download a full guide of how to manage MSSQL databases via myLittleAdmin here: (mla_guide_edited)

 

Was this article helpful?

Yes (9)
No (2)

We're sorry you didn't find this article very helpful. Please help us improve it by leaving your feedback below.

Error