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 HSphere 2.0, 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 has clearly distinguish between 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.