Hi there,
Thanks for reaching out!
If you've confirmed that your Xbox Live subscription is active, please try restarting the game and clearing the download cache to resolve the problem:
https://help.bungie.net/hc/en-us/articles/360049199051-Clearing-the-Console-Cache
If you continue experiencing this after clearing the cache, we recommend you try re-installing the game to resolve the problem.
For more information about the Stingray error code, please view this page: https://help.bungie.net/hc/en-us/articles/360048714772-Error-Code-STINGRAY