SQL Server database Authentication in Fabric

I am trying to get data from SQL Server Management Studio to a copy data activity MS Fabric using SQL Server database as my source but am getting an error 'invalid credentials' every time I try. I had copied the connection string from a data warehouse in fabric to create a connection from SSMS. Anyone who knows how I can easily get data to a copy data activity in fabric data pipeline from SSMS? or how to deal with the invalid credentials error?

1 comment