Creating Databases with SQL Server Management Studio

General

This article describes how to use the Microsoft SQL Management Console to create the databases required for Webdesk EWP

• webdesk
• shark

and to define a technical user for access from Webdesk.

Steps in Detail

Open the SQL Management Console

Connect to SQLEXPRESS using Windows authentication.

In the Object Explorer, expand the server node

• Right-click Databases - create a new database
  
  General tab: Name: webdesk
• Security - right-click Logins - New Login
  
• General:
  

  Vergrößern

• Name: wdadm
• Select SQL Server authentication
• Enter the password twice
• Disable Enforce password policy
• Check the server roles:
  

  Vergrößern

• dbcreator
• public
• Databases - webdesk - Security - Users:
  
• Right-click Users --> New User
• General:
  

  Vergrößern

• User type: SQL user with login
• User name: wdadm
• Login name: wdadm
• Default schema: dbo
• Check Owned Schemas

  Vergrößern

• db_owner
• Check Membership

  Vergrößern

• db_owner
• Create the database
  General tab: Name: shark
• Databases, shark, Security, Users:
• Right-click, New User
• General:
• User type: SQL user with login
• User name: wdadm
• Login name: wdadm
• Default schema: dbo
• Check Owned Schemas
• db_owner
• Check Membership
• db_owner
• Right-click the SQL Server
  
• Open Properties:
• Security tab
  under Server authentication, select the option "SQL Server and Windows Authentication mode", then OK

  Vergrößern

• Restart the server service

IMPORTANT! The user must be the owner of the databases in order to be allowed to read, write, and delete data; otherwise Webdesk cannot function properly.