|
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 2.x,
you must be subscribed to a plan with MS SQL support. You
can check it out from the Compare Plans chart from the signup
page.
To work with Microsoft SQL correctly, you have to distinguish
clearly between two different underlying concepts:
- login, which is required for connecting to the Microsoft
SQL server and server role authentication. You need 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. You should 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.
|
