Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

\uD83D\uDCD8 Windows (SQL Server Management Studio, SSMS)

...

Open Microsoft SQL Management Studio from the Windows application menu. Upon launching, it will prompt for some connection details.

  • Server type: Database Engine

  • Server name: sql.hic-tre.dundee.ac.uk

  • Authentication: SQL Server Authentication (not Windows Authentication)

  • Login: your project ID as it appears under “Project” for your workspace (e.g. project-XXXX)

  • Password: leave this emtpy

  • Check Trust server certificate

After pressing Connect, you will be able to see the server address on the left under Object Explorer. Using the database tree, you can navigate to your database and perform queries.

...