Upload Local MSSQL Database and Configure Connection String


Today we will show you how to upload your database to your hosting account with us. This includes four steps:

Step 1: create a new database and db username on your hosting account.
Step 2: take a backup of your local database.
Step 3: restore the backup of your local DB into your newly created DB from Step 1.
Step 4: the connection string

Step 1: Create a new database and db username on your hosting account

– Log into your control panel.

– Click on SQL Server 2012


– Click on Create Database


– Type the database name and click on Save


– Now to create the db username, Click on SQL Server 2012 then click on Create user.

– Type the db username, password and password confirmation then set the “Default database” to the one you have already created and check the database name as well. Click on Save.


– Done, now the database and database user are created on your hosting. Let’s go to Step 2.

Step 2: Take a backup of your local database

This step is to be done on your local machine.

– Using SQL Server Management Studio. Click the server name to expand the server tree Then expand Databases. Right-click the database, point to Tasks, and then click Back Up.


– Most of things should be set by default. You can change the location of the database .bak file if you want by removing the current location and then click on Add to add a new location. You will be asked to enter the backup file name as well (ex: testing.bak).


– Now you have your database .bak file. To Step 3.

Step 3: Restore the backup of your local DB into your newly created DB

– First you will need to upload your .bak file to your hosting account. To do this, you can use your control panel’s File Manager http://blog.arvixe.com/how-to-use-file-manager-in-websitepanel/

or using FTP http://blog.arvixe.com/ftp-basics/ .

– Now go back to SQL Server 2012 on your control panel and then click on the database you have created.

– Click on Maintenance Tools then click on Restore


– Select “Hosting Space File” and then select the path to your .bak file and click Restore


– Done. Now your database is restored. For the connection string, check Step 4

Step 4: The connection string

Now everything is ready and set, you just need to configure your connection string. You will need to use the database name, username and password you have created in Step 1. To configure your connection string, please check https://support.arvixe.com/index.php?/Knowledgebase/Article/View/51/8/do-you-have-a-connection-string-i-can-use-to-connect-to-the-local-mssql-database .

You are ready to go online.

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

Tags: , , , , , , , , , , | Posted under Windows Server Admin | RSS 2.0

6 Comments on Upload Local MSSQL Database and Configure Connection String

  1. Yigit says:

    You are great! I easily move my db to your server :)) Thank you!

  2. Kais says:

    Cannot open database “MYDATABASE” requested by the login. The login failed. Login failed for user “sa”

  3. jomal says:

    hi sir! i cont upload my database, i got error can anyone help me
    this is my (The media family on device ‘C:\Windows\TEMP\fdd396c8-2af8-4c5e-a6cc-736b84c9f5a3\Registration.mdf’ is incorrectly formed. SQL Server cannot process this media family.)
    tnx alot 🙂

  4. Khalaf says:

    Please how to solve this?
    while restore the database i got this error message
    Error restoring SQL Server database.

    The media set has 2 media families but only 1 are provided. All members must be provided.

  5. I have created ODBC connection to my database using SQL Server Driver from Control Panel and I am getting the next error:
    “[Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application”
    It seems like 64bit to 32bit conflict. Does anyone know how to resolve it?

Leave a Reply

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