Windows MSSQL Database Hosting

Databases plays an important role in success of any online business, if you are having big size database then you will have to consider MSSQL database  or MySQL database hosting plans where you can host them. All webhost offers you both database hosting packages. You may have to pay extra for getting such special type of hosting plans, some host offer them as a part of their hosting services.
If you have created database using MSSQL then you will have to consider Windows database hosting packages which will support MSSQL databases on their servers so that you can host your MSSQL databases and can run your website smoothly. MSSQL databases are more advance form of database hosting as compare to MS Access database hosting, if you have few fields and don’t have heavy traffic then you can consider MS Access database hosting packages else its better to go with advance form of database hosting packages such as MSSQL database hosting.

MS SQL Server is a fully blown enterprise-level database, it can handle thousands of concurrent users and database connections and is perfect for websites having huge databases with hundreds tables/fields.

You will have Plesk as control panel with your Windows database hosting plans using which you can create databases for your website. Following process will help you to create databases using Plesk control panel.
1. Login to Plesk.
2. Click on the domain name in the list at the bottom.
3. Click on Databases.
4. Click on Add New Database.
5. Enter a database name and select Microsoft SQL Server as type.
6. Click OK. This will take you to the Database Users window.
7. Click Add New Database User.
8. Enter a username and a password twice.
9. Click on OK. The user will be added to the database. That’s all you have successfully created database and user for it.

Posted under ASP .NET Hosting, ASP Hosting, Plesk Control panel, Website Hosting control panel, Windows Hosting with Plesk

This post was written by on November 12, 2008

Tags: , , ,

Managing your DNS Zone files using Plesk.

What is Zone file : Technically a zone is another name for a domain name or a sub-domain within your DNS server. You will have every domain and sub-domain with its zone file. Zone files contain records in plain text having DNS information that links a domain to an IP address. Every zone contains several different records. Major difference between domain and zone file is of hierarchy, a domain will have a sub-domain contained within its hierarchical structure whereas sub-domain will have a zone, its not considered as a sub-zone. There is no such thing as sub-zone, all zones are separate entity which can be linked.

If you are using Plesk as control panel for managing your webhosting account then when you create any domain it will automatically create a DNS zone for it. If you are Plesk Administrator then you have freedom to customize these DNS zones.

How to view and manage Zone files for a specific domain :
You need to Login to your Plesk as an Admin. You will get list of domains at the bottom of page, just select the domain name you want to work on. You will have Services group in which you need to click on DNS button, now you will get DNS Zone properties screen from where you can add/remove zone records, can easily change zone types, can turn off lock DNS services etc. for required domain. Thus Plesk offer you good tool for managing DNS stuffs.

Posted under ASP .NET Hosting, ASP Hosting, Plesk Control panel, Website Hosting control panel, Windows Hosting with Plesk