mojoPortal install using MS SQL Server

Last Updated on Friday, 10 December 2010 08:42 Written by Rick Hubka Friday, 10 December 2010 08:33

has excellent installation documentation available here.  However that documentation is not specific to installing your mojoPortal CMS  on Arvixe into your own ASP Hosting package.
Lets get started.

Download the latest mojoPortal deployment files here.
Once there, simply click on a Download image button like this
and the latest version of mojoPortal (about 20 Meg) will start downloading.

On your PC copy the downloaded file into a new empty folder and extract it’s zipped content.
The contents of the folder will look like this.

To install mojoportal we need all the folder and files inside the this wwwroot folder to be copied to the server.  That’s almost 8,000 files and we are only concerned with editing one.  Before we do that lets first Login to your Arvixe Control Panel and create your mojoPortal MS SQL database and User, because we need that database information to edit the file.

Manage MSSQL backups with Scheduled Tasks

Last Updated on Monday, 22 November 2010 03:03 Written by Andrea B. Sunday, 21 November 2010 10:33

Arvixe customers have 2 options to manage MSSQL databases backups.

The first option is to manually backup databases using  Microsoft SQL Server 2008 Management Studio.

A detailed explanation of how to backup using MSSQL 2008 Management Studio can be found here.

The second and most useful option, in my opinion, is to schedule database backups using the ‘Scheduled Tasks‘ feature you can find in the Arvixe Control Panel.

Using Greek Collation on ASP.NET and MSSQL

Last Updated on Wednesday, 3 November 2010 12:43 Written by Yiannis Androulakis Monday, 1 November 2010 02:24

I recently transfered my website to ARVIXE, which includes a forum powered by an MSSQL database.

The forum is in the Greek language and thus, the posts contained latin and non-latin (Greek) characters. While the forum displayed nicely on my former web hosting company, the Greek text was garbled on ARVIXE. This was a major problem since the forum constituted some 75% of the total traffic of the site (around 700K pageviews/month).

How to backup a MSSQL database using Microsoft SQL Server 2008 Management Studio Express

Last Updated on Wednesday, 11 April 2012 01:57 Written by Shai Ben-Naphtali Tuesday, 24 November 2009 09:37

Related documents:
1. How to Use Microsoft SQL Server 2008 to Connect to your Database
2. How to Fix the “The server principal ( ) is not able to access the database ( )” Error In Microsoft SQL Server Management Studio
3. How to restore an MSSQL .bak database using Microsoft SQL Server 2008 Management Studio Express

Arvixe customers can enjoy the ability of remote management of their MSSQL databases using the free software from Microsoft called Microsoft SQL Server 2008 Management Studio Express.

This blog post will explain how an Arvixe customer can backup a database to the hosting space and later download it to keep offline to restore when needed.
Note: Per Arvixe’s TOS and AUP, keeping a backup on your hosting space is not allowed. Please make sure that after you create a backup, you download it to your local PC/Server and remove it from the hosting space.

How to Use Microsoft SQL Server 2008 to Connect to your Database

Last Updated on Friday, 11 March 2011 05:11 Written by Arian Jahansouz Friday, 14 August 2009 04:13

Related documents:
1. How to Fix the “The server principal ( ) is not able to access the database ( )” Error In Microsoft SQL Server Management Studio
2. Windows PowerShell 2.0
3. How to backup a MSSQL database using Microsoft SQL Server 2008 Management Studio Express
4. How to restore an MSSQL .bak database using Microsoft SQL Server 2008 Management Studio Express

This post will give you step by step instructions on how to connect to your SQL server database using Microsoft SQL Server 2008.

1) Set up a “SQL Server 2008 Database” and a “SQL Server 2008 User” in your DotNetPanel. A tutorial on how to do that can be found here.

2) Go to the Microsoft SQL Server 2008 Management Studio Express download page. The page can be accessed here.

3) Click “Download files below”.