|
For more information contact HitSites Support at
support@hitsites.net
Microsoft SQL Support feature allows internet users to work with
your Microsoft SQL databases. For more information on Microsoft
SQL Server, please go to
www.microsoft.com/sql/evaluation/overview/CE/default.asp.
To offer Microsoft SQL database access within H-Sphere, you
must be subscribed to a plan with MS SQL support. You can check it
out from the Compare Plans chart which is accessible from the
signup page.
To correctly work with Microsoft SQL, one must
distinguish between the two different underlying concepts:
-
login, which is required for connecting to the Microsoft SQL
server and server role authentication. You require a login to
create a database.
-
user, which is required for working with Microsoft SQL
databases.
How to Create a Database
To create a Microsoft SQL database, you first need to create at
least one login. It is required to remotely connect to the
Microsoft SQL server. In the MSSQL menu select MSSQL logins:
In the window that appears enter the login and password:
Next, select MSSQL Databases, then specify database parameters:
where:
-
Total quota size is the disk space allocated for the
database file and the transaction log file. This quota cannot be
exceeded.
-
Database/Transaction Log file quota ratio is the
portion of disk space allocated for the database file. For
example, if you set the total quota size to 20 MB and the
database/transaction log file quota ratio to 10%, the maximum
allowed size of the database file can be 2 MB.
After you have created the database, it appears in the database
list:
To connect to the Microsoft SQL server from a remote computer,
use any Microsoft SQL agent. When prompted, enter the host name
suggested in the control panel, and the login / password you have
created.
|
