Accessing DEV database

You can access the Azure resources and for example the database for DEV environment.

For this,

• Go to https://portal.azure.com/
  • Search > Type "gdcc"
  • Find and click on the resource group attached to gDCC (called eu1-gdcc-dev-rg at the time of writing this doc)
  • Among the resources, find and click on the database (called eu1-gdcc-dev-sqldb at the time of writing this doc)
  • Copy the name of the database and the Server name (called eu1-gdcc-dev-sql-a.database.windows.net at the time of writing this doc)
• Open SQL Managament Studio
  • In Connect to Server window, click Options >>
  • In Tab Connection Properties, set database name
  • In Tab Login, set Server name to the copied server name, Authentication to Azure Active Directory - Universal with MFA, User name to your e-mail

Notes

• If you are missing permissions, create a DevOps ticket
• When working from home, you may need to ask DevOps to whitelist your IP (IP of Copenhagen office is white-listed)