This is a good article that describes how to connect to a non production environment with SSMS https://stoneridgesoftware.com/how-to-connect-to-your-non-production-d365-finance-and-operations-database/
AX – D365FO – Connect to Your Non-Production Database (UAT, etc..) with SQL Server management studio (SSMS)
AX / Dynamics 365 For Finance and Operations blog 