Skip to main content

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)