How to provide password for SQL server remote

[amitaiemd]

Hi Team,

I am stuck with connecting Azure pipeline to remote SQL server. I have a powershell run as command to connect to SQL server remote, but I am unable to understand how do I set/provide password for that connection string. I will be greatful if you can help me assist on this.

[#2]

@amitaiemd 

 Would suggest connecting by using a service principal:

Azure AD Service Principal authentication to SQL DB - Code Sample - Microsoft Community Hub

[#3]

Thanks Kidd, this is sorted out now
Can you please help me with an example, where I can upload a file to a folder under TFVC(TFC) repository from Azure pipelines.yml. I want to know the powershell rest call sample for this. Thanks