This might look very primitive, but since I am a newbie to PowerShell scripting, it does no harm to write them down here and reference them in a later time when needed.
For sql server authentication:
"Server=
server_name or server_ip;Database=db_name;Integrated Security=False;UID=login_name;Password=password"
For windows authentication:
"Server=server_name or server_ip;Database=db_name;Integrated Security=True"
Another website which is dedicated to connection strings might also come in handy, the link is here.
But shockingly, I can't find the above PowerShell script connection strings on the website.
Posts
