Hi Wilduck

Sorry for the delay !

If your SQL Server is on your local system you just go through with windows authentication

But if your SQL Server is available at any remote location then you need to give that sql server credential to access it in a network .

Hope it may clear your doubt

Keep updating us