SQL Database Setup:

• To setup your SQL databases you need to click on "MSSQL Server Management" link in HostPilot Control Panel.
• Then you will need to create a login for yourself. The username is the same as your HostPilot username and can not be changed, the password is at your discretion.
• Your credit card will be charged at the time of login setup for prorated monthly fee.
• Then you can click on Database link to create a database. Your credit card will not be charged if the number of databases does not exceed 5 or the total size of all databases does not exceed 10 MB.
• If the number of databases under your SQL login exceeds 5, you will be charged for an additional database on your account.
• If the total size of your database(s) exceeds 10 MB, you will be charged for extra disk space at the time of database setup.

SQL Database Settings:

• Login username is the same as your HostPilot username (can not be changed). This user is the owner (dbo) of the database.
• Password is what you typed in at the time of database setup. The password is not synchronized with your HostPilot password and can be changed at any time.
• Default database size is 10 MB, all of which is allocated for data. Transaction log is not counted towards your billeable SQL disk quota. The log file is truncated on checkpoints.
• You will need to use SQL query to find out present database size.
• Database size can be increased in 5 MB increments.
• If your database reaches allocated disk space, you will need to increase the size of your database to be able to add information to it. Your credit card will be charged at the time of database size increase.

Database Management:

• All administration of the database(s) is performed using SQL server Enterprise Manager or by executing SQL commands using "Command" frame in HostPilot > SQL server management. End user client access license is required to access SQL server using Enterprise Manager.
• Follow this link to read SQL Tutorial.