SQL Express - Add Database

This article assumes that you have downloaded and installed SQL Server Express and SQL Server Management Studio on your VPS. You can an article on installing SQL Express and Management studio here.

You can add a database by:

  • Once logged into your VPS, open the Start menu and select All Programs > SQL Server Management Studio Express
  • On the login screen that appears, click Connect.
  • In the Object Explorer on the right hand side, right click the Databases container and select New Database.
  • Enter the name of your database and any other configuration required.
  • Your database connection information is displayed on the bottom left of this screen.
  • Once your database is added, it will appear in the Databases container mentioned above.
  • You view its table and settings by browsing to this location via the Object Explorer.

  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

Can I use VNC / Radmin / GotoMyPC on my VPS to connect?

On our Windows virtual servers (windows vps) you can install programs such as GotoMyPC abd Remote...

Does my VPS use dedicated bandwidth?

First lets explain what dedicated bandwidth is.  Dedicated bandwidth is where your vps...

How can I transfer files to and from my windows vps?

You can install the FTP server software which is on the desktop of your vps. This software will...

How do I add extra hard drive space to my VPS?

All VPS and shared account holders can now add extra drive space to their packages (xen vps, web...

How do I connect to my windows xp vps from my home/office windows xp computer?

Log into your home pc as usual. Once your windows xp system has loaded proceed with the following...

Powered by WHMCompleteSolution