nopCommerce Tips: How to Access Your Live nopCommerce Database

nopCommerce has a very robust and extensive administration panel, but every now and again, you’ll find that data needs to be updated or corrected in a way that’s not supported by nopCommerce directly. It’s at those times that you may find it preferable to edit the database directly – today, we’ll talk about how to do just that.

We’ll start with the prerequisite that you’re leveraging MSSQL for your database, and that you have SQL Server Management Studio installed on your computer. If you don’t already have it installed, you can go here http://www.microsoft.com/en-us/sqlserver/get-sql-server/try-it.aspx and download either a trial version, or the free Express version.

Once you’ve got all that set up, refer to your live server setup. For instance, if you’re using Arvixe hosting, you’ll log in via WebsitePanel, and navigate to your “Databases” tab. From here, we’ll want to retrieve your database access information; your SQL user name, and SQL database password.

You’ll want to check with your hosting provider to find out whether to access your live SQL database by IP address or URL. Once you’ve got that information, open up your SQL Server Management Studio. You’ll see a modal that contains information fields to let you connect to your database.

In the field labeled “server name”, enter your IP address or URL; in the login and password fields, enter the information you got from your WebsitePanel. Select “Remember password”, and click “Connect”. Allow a moment for the connection between your desktop and the server; you should then see the server and all databases on it, and be able to access your nopCommerce database to edit or update any information, as needed.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Looking for quality nopCommerce Hosting? Look no further than Arvixe Web Hosting!

Tags: , , , , , , | Posted under MSSQL, nopCommerce | RSS 2.0

Author Spotlight

Carole Bennett

Carole Bennett is the founder and principal of IndigoTea. As a professional IT consultant, Carole has provided solutions for companies as diverse as Verizon, Frito-Lay, Capital One Auto Finance, and Zales Jewelers, parlaying a unique talent for acting as a translator between the worlds of business challenges and technology solutions. She considers multi-tasking skills gained from simultaneously 1) managing a fire performance troupe, 2) raising a family, and 3) working as a full-time IT consultant excellent preparation for her current career incarnation as the driving force behind IndigoTea. "Fire-breathing redhead on a mission" is not just a metaphorical description!

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>