Remove configuration of before_all adapter in spec

What does this MR do and why?

Similar to !93542 (merged) this can lead to broken master specs because subsequent specs won't have the correct before_all adapter

This is an actual broken master now: #369190 (closed)

MR acceptance checklist

This checklist encourages us to confirm any changes have been analyzed to reduce risks in quality, performance, reliability, security, and maintainability.

• I have evaluated the MR acceptance checklist for this MR.

Related to #369078 (closed)