Creating SQL Server Database and Database User

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. It’s optional field, but once selected the name of the database could be omitted from connection string of your application.