I am a newbie to SSIS.
I have created Azure VM and installed SQL Server. I need to deploy the ssis package from visual studio in my local to SQL server on Azure VM. Using below command I can login to VM SQL server with windows authentication from SSMS in my local.
runas /netonly /user:domain\user "C:\Program Files (x86)\Microsoft SQL Server\140\Tools\Binn\ManagementStudio\Ssms.exe"
Now, I'm trying to deploy package from Visual studio to VM SQL Server, In the deployment wizard it asks for destination server where not able to login to VM sql server using windows authentication, it throws below error: And when using SQL server authentication in deployment wizard for destination server it throws below error:
How can I deploy packages to Azure VM SQL Server from local ?