Managing SQL Server Management Studio 2012 Databases with WebsitePanel

How to create database on your WebsitePanel control panel and manage with Microsoft SQL Server 2012
Creating Databases
  • Login to WebsitePanel
  • Select Databases | SQL Server 2012

  • Select Create Database
  • Provide a name for your database and click Save button

  • Select Create User
  • Provide a username, password and associate with the database by selecting the database name from the Default Database drop down. You should also select the checkbox located near the database name.

 

You can now make use of Microsoft SQL Server 2012 or Microsoft SQL Server 2012 Express from your computer to access and manage the database remotely using either the IP address or host name. You will get the required information if you select the relevant database name as shown below

In order to take a backup of your database, select your database name and click on the Maintenance Tools panel

Select the Backup button, provide a backup filename and click Backup button. Alternatively, you can either download the backup or save it on the server where your site is hosted.

You can easily restore a SQL Server backup by selecting the Restore button. You can either upload a backup file by selecting the Browse button or locate the backup from the server.

  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

How to login phpMyAdmin to manage MySQL on Websitepanel?

Please go through http://www.yourdomain.com:9900

How to Restore or take a Backup of MSSQL Database in WebsitePanel?

How to Restore or take Backup MSSQL Database in WebsitePanel? How to create database on your...

How to Restore a Backup of MSSQL Database in MSQL Server Management Studio (Remote Desktop)

Microsoft SQL Server Management Studio is available for free from Microsoft and can be downloaded...

How can I manage MySQL in WebSitePanel?

Please login phpMyAdmin through http://www.yourdomain.com:9900 to manage MySQL databases.

Powered by WHMCompleteSolution