Configuring Microsoft SQL

Microsoft SQL hosting is available both to *nix and Windows accounts if MS SQL is set up in the system and enabled in the plan.

Unlike other SQL databases, MS SQL requires a login to access the MS SQL server. Once you have created a login, you can create databases. To access a database, you need to create DB users.

• Creating Microsoft SQL logins
• Creating Microsoft SQL databases
• Adding MS SQL database users
• Changing MS SQL quota
• Managing MS SQL databases through web-interface (MS SQL Manager)

Creating Microsoft SQL Logins

Logins are used to access MS SQL server and to create DB users. You should create as many logins as many users you will have.

To create an MS SQL login, do the following:

1. Select MS SQL in the Databases menu.
2. Click the Add New MS SQL login icon at the bottom of page:

   

3. Enter login and password into the MS SQL Login Creation Form that shows:

   

   Note: you can change password by clicking the Change icon against the login name in the Controls section.

4. Click the Submit button.
5. Agree to additional charges.

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.

Creating MS SQL Databases

Databases are created under logins and there can be several databases under one login.

To create a MS SQL database, do the following:

1. Select MS SQL DBs in the Databases menu.
2. Click the Add database icon at the bottom of the page that appears.
3. Fill the MSSQL Database Creation form:

   

4. Click the Submit button.
5. Agree to additional charges.

Important: When MS SQL creates a database, it automatically creates a user with the same name as the login this database was created under.

To delete a database, click the Trash icon against the database name in the Controls section. Deleting a database will delete all its users.

Adding New MS SQL Database users

Users are used to access MS SQL databases. Within a database, one login can be used only by one user. Mind, that the login used to enter the database is already used by you and it can't be used to create a new user on this database. Therefore, when you create a new user to the database, the system will offer you to choose from the logins that aren't used by this database.

To add a new user to individual MS SQL database, do the following:

1. Select MS SQL DBs in the Databases menu.
2. On the page that appears, click the name of existing database or click the Edit icon in the Controls section. The following form will show:

   

3. At the bottom of the page click Add icon against the Database users field. The following form will appear:

   

4. Enter user name.
    
5. Choose login this user will belong to and click Add.
6. Agree to additional charges if any.

Changing MS SQL Database quota

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:

1. Select MS SQL DBs in the Databases menu.
2. On the page that appears click the name of an existing database.
3. On the form that shows, click the Change quota icon against the Database quota field.
4. Enter new database log file ratio and total quota size on the next page:

   

5. Click Submit.
6. Agree to additional charges if any.

Managing MS SQL databases

(MS SQL Manager)

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:

1. Select the Domain Settings menu.
2. On the page that appears, click Edit for Web Service.
3. On the Web Options page, enable ASP and ASPNET if they are disabled. Then enable MS SQL Manager at the bottom of the page.
4. Click the Magnifying glass icon that appears to launch MS SQL Manager. You'll be asked to choose the login to connect to your MS SQL databases:

   

Creating ODBC DSN Records

ODBC - Open DataBase Connectivity is a standard database access method developed by Microsoft Corporation. ODBC makes it possible to access any data from any application by means of ODBC drivers - one for each database format. You can create DSN (Date Source Name) records based on ODBC drivers to access databases of different formats under Windows plan.

• Creating a new DSN record
• Editing DSN records
• Deleting DSN records

Creating a new DSN Record

To create a new DSN Record, do the following:

1. Select ODBC Service in the ODBC menu, and the list of available ODBC drivers will show.

   

2. Click the Add icon next to the DB driver you need.
3. Fill the form that appears. Forms are different depending on the DSN type:

   

   • Enter the second part of your full DSN name in the DSN field. The first part of your full DSN name is your Windows login. In the applications/scripts you run on your server, you must use the full DSN name, e.g. testvi0-mydatabase as in the below example.
   • Directories and file names must include paths relative to your home dir root, (the SourceDB field should include the name of the database and the extension).
   • Create CF MX DSN record - check this box to have system DSN records registred in ColdFusion MX. Once you have created the DSN record, you'll need to wait till the next morning until ColdFusion server is restarted.
4. Click Create.

Editing DSN Records

Here you will learn how to edit your DSN records.

Note: For more details on each driver's parameters, read driver specifications. E.g. you can find all information about MS SQL DSN configuration on the Microsoft Web Site.

To edit DSN records:

1. Select ODBC Service in the ODBC menu.
2. On the page that shows, in the Your DSN section, click the Edit icon next to the DSN record you need.

   

3. Edit the DSN records in the form that appears.
4. Click Update.

Deleting DSN Records

To delete a DSN record, do the following:

1. Select ODBC Service in the ODBC menu. This will open a page similar to the one above
2. In the Your DSN section, click the Delete icon next to the existing DSN.