Microsoft SQL (MS SQL) database is a database management system based on Windows platform. It allows you to add, access, and process stored data.
Unlike other SQL databases, MS SQL databases are dependable on logins which give access to MS SQL Server. Once login is created, you can create databases associated with it. After creating a database, H-Sphere automatically creates users with specific permissions. Beside customer users, H-Sphere automatically creates an H-Sphere user for the owner login. So, to create and manage MSSQL database, follow the given sequence:
To create an MS SQL login, do the following:
Note: you can change password by clicking the Change icon against the login name in the Controls section.
Note: To delete login, click the Trash icon against the login name, in the Controls section.
Important: With deleting a login, H-Sphere will delete all DBs created under it and also all users under the DBs. Also if you have some users under this login that are associated with another DB, these users will be deleted as well. Please make sure you want to delete the login before clicking Trash.
To create a MS SQL database, do the following:
Note: To delete a database, click the Trash icon against the database name in the Controls section.
When MS SQL creates a database, it automatically creates a user with the same *login* as the one this database was created with.
After you have created the database, it appears in the database list:
Here you can learn how to add users to individual MS SQL databases. To add a new user, do the following:
Total quota size is the disk space allocated for the database file and the transaction log file. Database/Transaction Log file quota ratio is the portion of disk space allocated for the database file. If you set the total quota size to 100 MB and the database/transaction log file quota ratio to 40%, then the maximum database file quota is 40 MB and the maximum log file quota is 60 MB. The more dynamic your database is, the bigger transaction log file quota ratio should be.
To change the quota, do the following:
You can manage your MS SQL databases through a web-interface with ASP Enterprise Manager, in your control panel called MS SQL Manager. To set up and launch MS SQL Manager:
© Copyright 1998-2003. Positive Software Corporation.
All rights reserved.