Welcome to Microsoft Q&A!
Connecting to SQL server using SSMS
Connecting SQL server from a standalone machine, you should enable protocols, configure a fixed port, open ports in the fire wall, enable SQL Server Brower. For more information, please refer to Connecting from Another Computer.
Deploying SSIS packages from SSDT server to SQL server
Integration Services supports two deployment models, the project deployment model and the legacy package deployment model. If you would like to deploy packages to standalone SQL Server, you should choose the legacy package deployment model. For more information, please refer to Legacy Package Deployment (SSIS)
If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.