Using EMS SQL Server Manager to manage your Arvixe databases

If you CRUD your SQL Server database, this may interest you.

BTW,  CRUD stands for Create / Read / Update / Delete

What I really mean is: For those who need full access to their database to view and edit data, tables, views, stored procedures, export data, export database objects, import data and more, There are database tools available that allow you to access your remote SQL Server databases on your Arvixe hosting.  As a developer of Custom mojoPortal modules, I use tools like this daily and the tool I use most is EMS SQL Server Manager which available here.  I also use it to manage all the local SQL Server databases on my PC, laptop and the company Network Servers.

EMS have commercial and non-commercial licenses available.  For personal home use I have a non-commercial license which has all the same features as the commercial product.  More on pricing here.  There is also a Lite version which is free and somewhat restricted, but maybe that’s all you need.  Compare Full and Lite versions here.

After installing EMS SQL Manager it can’t do anything much for you until you register a local or remote Host and then you must register databases for that Host.  Lets register a  Host account to your Arvixe server.  My Arvixe server name is  violet.arvixe.com.  Check your initial Arvixe emails for one titled “Hosting  Account Information”.  Just a few lines from the top it says “Server Name: “.  That’s the name you use.

Let’s do that.  From the top database menu select “Register Host”.

This opens up the “Register Database Wizard” window as seen below.  Enter your arvixe server name. Then select the SQL Server authentication radio button. The enter the user name and password for this SQL Server database on your Arvixe hosting package like below.  I unchecked “Register a single database” because I am going to register several databases at once in this tutorial.  Then click the “Next” button.
Please be patient and wait.  This may take a minute or 2.

Below is the next window for selecting one or more databases.
WOW!!!  Look at all those database names.  The list of Available databases is not just your database(s).  It’s a list of all the SQL Server databases on server name violet.arvixe.com.  SQL Database tools don’t have the ability to filter database list by User and password so they show all databases.  Don’t worry, nobody can view or edit a database unless the User Name and Password are for that database is entered.
Scroll through the left database list and click on your database name and then click the right arrow button to move the database name to the Selected databases list on the right.  When you have selected your database(s), click the “Next” button.

Below is the next window.  In this options window.  I accept the default values listed and do nothing on this window.  You may want to change one or more of the settings in this window.


Then click the “Finish” button and wait a bit.

Yes we are finished as seen below.

With the setup complete your database(s) will be listed in the left pane as shown above.
In the left panel, Double Click on the name of the database you would like to open.  Wait.  Then under Schema there will be a user listed and under that will be a list of your tables, views, stored procedures, etc.  Go ahead and double click on a table name and the tables details will open in the larger right pane ready for you to edit data or add new table names.

Done.

I’m not going into the details of how EMS SQL Server Manager works.  That’s beyond the scope of this tutorial.  I will say…”I love this Tool”.  I have been using it for 7 years now.  Yes, I can connect to my database at violet.arvixe.com using MS Visual Studio.  That works fine but that Server Explorer is not near as robust as the EMS tool.

Wait time for connecting will depend mostly on the speed of your internet connection.

Take Care and Happy Hosting.

Rick Hubka

Tags: | Posted under 3rd Party Software, MojoPortal, MSSQL, Programming/Coding | RSS 2.0

6 Comments on Using EMS SQL Server Manager to manage your Arvixe databases

  1. Andrea B. Andrea B. says:

    Thanks Rick, it seems a nice tool, especially for filtering the database list.
    I’ll try it.
    Still waiting for MS Sql Server Management Studio including this feature.

    Thanks

  2. Josh W. says:

    I can’t seem to get it to log into the server to get my databases. I used my account name with password and that didn’t work. I tried using the login name/pass of a Database User and that didn’t work either, please help.

  3. Rick Hubka Rick Hubka says:

    You need 3 entries for it to work
    1) Arvixe server name
    2) Your database User name
    3) Your database password
    NOTE: You can not use windows authentication!
    Then, as long as your PC firewall does not block the request and reply, it should work.

    Hope this helps

  4. I have the same problem – the error I get is :
    Can’t obtain database list from the server.
    [DBNETLIB][ConnectionOpen (Invalid Instance()).]Invalid Connection

    I cross-referenced the following three different times today
    1) Arvixe server name
    2) Your database User name
    3) Your database password

    I have opened port 1433 on my firewall in XP also

    Tech Support gave little help other than to tell me to check the settings – my last try is with you

Leave a Reply

Your email address will not be published. Required fields are marked *


9 × 1 =

You may use these HTML tags and attributes: <a href="" title="" rel=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>