Only test relevant components during smoke test

[jemrobinson]

✅ Checklist

• I have searched open and closed issues for duplicates.
• This is a problem observed when deploying a Data Safe Haven.
• I can reproduce this with the latest version.
• I have read through the documentation.
• This isn't an open-ended question (open a discussion if it is).

💻 System information

• Operating System:
• Data Safe Haven version:

📦 Packages

List of packages

Paste list of packages here

🚫 Describe the problem

See https://github.com/alan-turing-institute/trusted-research/issues/430#issuecomment-2630696964. MS-SQL database connection is being tested even though there is no MS-SQL database server. We should ensure that the smoke tests only test the deployed components.

🌳 Log messages

Relevant log messages

Your log details here

♻️ To reproduce

• Deploy an SRE without an MS-SQL database
• Run the smoke tests