MSSQL Admin Tools

MSSQL Admin Tools

I would like to manage my MSSQL database. How can I do this?

On some of our MSSQL servers we have installed a tool called
MyLittleAdmin. This web application allows you to edit your database,
back it up and restore it from a backup (MSSQL 2005 & 2008 only).
To access it, you\'ll first need to know what server you are using. To
find out what server you\'re using, go to control panel -->
Databases menu --> MSSQL --> MSSQL DB and the server will be
listed on this page. Use that server name for the following links:



mssql1 (mssql-01)

http://208.77.156.4/mssql_admin/



mssql2

http://96.125.180.4/mssql_admin/



mssql3

http://96.125.180.5/mssql_admin/



mssql4

http://67.22.135.4/mssql_admin/


mssql5
http://96.125.181.4/mssql_admin/


You would login with the username and password that you setup in the
MSSQL page in the control panel. The database or initial catalog would
be the database you want to use.


Access to our MSSQL servers is restricted to local (on-network) IP's only. In order to run programs such as SQL Management Studio, customers will need to subscribe to our Customer VPN Service. Please contact Support to order. 


When restoring a database from a bak, the user that you previously had
will no longer be attached to that database. As such, please contact us
to request that we add the back in. If this isn't done, you wont be
able to access the database.

    • Related Articles

    • MSSQL Redirect Module

      Cartika has introduced an MSSQL redirect module available for all Reseller customers (including UR customers, VDC, VPS and Cloud customers with MSSQL enabled) This module can be found under E.Manager > 3rd party Tools > CPDevel in your reseller ...

    • Shrink mssql db with mylittleadmin

      How to truncate mssql logfiles using mylittleadmin: 1) login into mylittleadmin 2) Select the Tools option 3) Under Tools click on : Shrink Database 4) Select your database 5) Under the option “Currently allocated space”, change the value with a ...

    • Shrink mssql db with mylittleadmin

      How to truncate mssql logfiles using mylittleadmin: 1) login into mylittleadmin 2) Select the Tools option 3) Under Tools click on : Shrink Database 4) Select your database 5) Under the option “Currently allocated space”, change the value with a ...

    • Restoring MSSQL via MS SQL Studio - VPS/Cloud/Dedicated only

      To restore a MSSQL database to your VPS or dedicated server, you would do the following steps: 1) Login to MS SQL Studio via remote desktop -- you will want to use an admin login and if you do not have this please contact us. 2) Right click the ...

    • Restoring a MSSQL database from a .sql file using EMS Sql Manager Lite

      How do I restore an MSSQL database from a .sql file? If you don't have a SQL management program, go to http://sqlmanager.net/en/products/studio/mssql to download the freeware version and install to your local computer.   Start EMS Sql Manager. If ...