SQL Server 2016 Management Studio

Configuration

Open SQL Management Konsole 

Connect to SQLEXPRESS using Windows authentication.

Collapse the Server 

• Databases, Right click, create new database
   
  Tab General: Name: webdesk
• Security, Right click, new, Registration
   
• General:
   

  Vergrößern

• Name: wdadm
• choose SQL Server-Authentifikation 
• type the Password twice
• uncheck "Force the password directive"
• Serverrols check:
   

  Vergrößern

• dbcreator
•  public
• Databases/webdesk/Security/Users:
   
• Right click, new User
• General:
   

  Vergrößern

• Usertyp: SQL-User with login name
• Username: wdadm
• Login name: wdadm
• Standardschema: dbo
• Schemas in possession check

  Vergrößern

• db_owner
• membership check 
  

  Vergrößern

• db_owner
• Databases, Right click, create new database 
  Tab General: Name: shark
• Datenbases/shark/Security/User: 
• Right click, new User
• General:
• Usertyp: SQL-User with login name
• Username: wdadm
• Login name: wdadm
• Standardschema: dbo
• Schemas in possession check
• db_owner
• membership check
• db_owner
• Right click on the SQL Server
   
• Open Properties:
• Tab Security  
  Select the "SQL Server and Windows Authentication Mode" option in the Server Authentication section, ok
  

  Vergrößern

• Restart the Server service 

Important! The user must be the owner of the databases to be able to read, write, and delete data, otherwise the Webdesk may not work properly.