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 2012 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: Press the windows key on your keyboard.
3.
Right
click SQL icon as you see it above, to bring up the advanced options on the
bottom
4.
Now
click on the Run as administrator option
5.
On
the User Account Control prompt, click Yes.
6.
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.
7.
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.
8.
You
will see the following folders under the Object Explorer heading: Databases,
Security, Server Objects, Replication, and Management.
9.
Right
click on the Databases folder and select the New Database… option.
10. 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.
11. To change the Owner
name, click the (...) button to select another owner.
12. Click on the Browse
button in the Select Database Owner window.
13. 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.
14. 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.
15. 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.
16. 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.
