Browse
 
Tools Add
Rss Categories
-->

SQL Server Setup Guide

Reference Number: AA-04483 Created: 2012-12-11 04:04 Last Updated: 2012-12-11 04:04 0 Rating/ Voters


 

Setup Microsoft SQL Server

 

Contents

 


Goals................................................................................................................................................ 2

Create a Database ............................................................................................................................ 2

Conclusion........................................................................................................................................ 7



Goals

 

This guide will help you create a MS SQL Database on your Windows VPS. Sometimes you will need to create databases for your website to store or access information. You may use the Microsoft SQL Server 2008 R2 Express Edition, which is pre-installed on your server, to help you create new database that you can associate with your website.

Create a Database

 

1.      First you will need to remotely connect to your Windows server.

2.      Navigate through the following path: click on Start and then click on All Programs. Click on Microsoft SQL Server 2008 R2.


3.      Expand Microsoft SQL Server 2008 R2 and right-click on the SQL Server Management Studio application and click on the Run as administrator option.


4.      On the User Account Control prompt, click Yes.


5.      If this is the first time you are opening SQL Server Management Studio on your server, you will see the following screen stating that SQL Server Management Studio is being configured.


6.      On the Connect to Server dialog box, leave the Server type as Database Engine and enter your VPS name in the Server name field. The Authentication field should be set to Windows Authentication. You will notice that the User name field has already been filled and greyed out and the Password field is blank. Then click Connect.


7.      You will see the following folders under the Object Explorer heading: Databases, Security, Server Objects, Replication, and Management.


8.      Right click on the Databases folder and select the New Database‚Ķ option.


9.      In the New Database window, enter the Database name. You can create the database by accepting all the default values, click OK, and otherwise follow the remaining steps mentioned below.


10.  To change the Owner name, click the (...) button to select another owner.


11.  Click on the Browse button in the Select Database Owner window.


12.  In the Browse for Objects window, check the box next to the user who you want to set as the owner of the database and click OK.


13.  To change the default values of the primary data and transaction log files, in the database files grid, click the appropriate cell and enter the new value.

14.  In the same way, you can change the collation of the database, modify database options, file groups or add extended properties. Once you have made the appropriate changes, click OK.

15.  Now if you expand the Databases folder, you will find the database you just created.


Conclusion

 

Now that you have successfully created a database, you can associate it with you website as per your requirements. If you encountered any issues with this guide, please also note that there is additional information available in our Wiki database at http://myhosting.com/kb. Finally, we encourage you to contact our technical support team by email at vps@myhosting.com, or calling us at 1-866-289-5091 with any questions or concerns.

Rss Comments
  • There are no comments for this article.
Info Add Comment
Nickname: Your Email: Subject: Comment:
Enter the code below: