...
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:usually sql.hic-tre.dundee.ac.uk
Authentication: SQL Server Authentication (not Windows Authentication)
Login: user your project ID as it appears under “Project” for your workspace (e.g. project-XXXX)
Password: provided, but likely blank
...
leave this emtpy
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.
...
🐧 Ubuntu Linux (Azure Data Studio)
...
Azure Data Studio is provided as an alternative to Microsoft SQL Management Studio fro Ubuntu workspaces as SQL Management Studio is not supported on Linux-based platforms. Azure Data Studio can be found in the application menu drop down, top left. When you first open Azure Data Studio, it will take you to a welcome page. From here, click “Create a connection” and enter the appropriate connection details.
Connection type: Microsoft SQL Server
Server: your unique SQL server address sql.hic-tre.dundee.ac.uk
Authentication type: SQL Login
Username: user your project ID as it appears under “Project” for your workspace (e.g. project-XXXX)
Password: provided, but likely blank leave this empty
The remaining fields can be left blank, followed by clicking Connect. An example of this is shown to the right. Once connected, your databases will be displayed under the Databases tree on the left side of the window.
...
Alternatively, if you would prefer to use the graphical ODBC manager, click Add ODBC Data Source from within the SPSS database wizard. Click Add and select “SQL Server”, then click Finish.
A new wizard will popup specific to SQL server. Enter a name for your data source (usually something like ProjectXXXX) and provide the server address, e.g. sql.hic-tre.dundee.ac.uk, then click Next.
This will then prompt you for some authentication details - select SQL Server authentication and put “user” in the username field, then click Next. Check the box “Change the default database to” and select your database from the dropdown list, then click Next. You can then click Finish and test the datasource. This should then appear as a datasource within SPSS.
...