How to create SQL database

Quick: How to create SQL 2005 Database.

  1. Log in to the control panel at http://control.apexhost.net.au
  2. Click on Databases select database type.
  3. Click on Create Database and enter your preffered name
  4. Click Save
  5. Click on create user then enter your preffered username and password. System will only allow min 6 char with 2 numbers.
  6. In the drop dpwn list choose the database you just created in step 3.
  7. Be sure to tick the tickbox next to the DB name under databases (matching your new DB)
  8. Click Save.

 

Detaied:

Creating SQL Server Database and Database User

Open Hosting Space home page.

To see the list of SQL Server databases and users point Databases in the hosting space left navigation menu and click select SQL Server from the popup menu:

To create a new SQL Server database click Create Database button:

Specify database name and click Save button to finish the wizard.

The next step is to create database user account and associate it with the database.

To create database user account click Create User button:

 

Specify username, password and then in Databases sections tick those databases you want to grant access for this user account. Database user will granted db_owner role in the selected databases.

You could specify Default database as well. Its optional field, but once selected the name of the database could be omitted from connection string of your application.

  • 1 Users Found This Useful
Was this answer helpful?

Related Articles

Backing up and Restoring SQL Server Database

To backup SQL Server database open its properties screen: and then click Backup button:...

SQL server addresses

Apexhost SQL servers: SQL2008: sqlsvr3.apexhost.net.au SQL2008: sqlsvr4.apexhost.net.au (For...