Database Creation

Follow the steps below to setup the initial database and service account access.

  • Open SQL Server Management Studio from the start menu
  • Connect to your database instance where the database will be stored
  • From the Object Explorer, right click on ‘Databases’ and select ‘New Databaseā€¦’

database1

  • Enter IdentityServer or a name of your choosing under ‘Database name’
  • Click ‘OK’

database2

  • From the ‘Object Explorer’, expand ‘Security’ and then right click on ‘Logins’ and select ‘New Loginā€¦’

database3

  • Click on ‘Search’
  • Change the ‘From this location’ to ‘Entire Directory’
  • Find the service account that will run the Identity Server IIS site
  • Click ‘OK’

database4

  • Click on the ‘User Mapping’ section
  • Tick the box for the newly created database
  • Change the ‘Default Schema’ to ‘dbo’.
  • Under ‘Database role membership for database’ select ‘db_owner’
  • Click ‘OK’

database5