Yes, we do allow remote access to MSSQL. The client can access the databases remotely by installing SQL Server Management Studio on his computer. You can download it through the link below:
https://learn.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver16