Create connection string using powershell

Question

Hi, I want to create connection string using powershell windows authentication. How do I do that?

Answer 1

Hi,

if it is related to a SQL connection then this will help you:

Powershell script to connect to sql db with windows authentication
https://stackoverflow.com/questions/38177582/powershell-script-to-connect-to-sql-db-with-windows-authentication

this also:
Connecting PowerShell to SQL Server – Using a Different Account
https://www.sqlshack.com/connecting-powershell-to-sql-server-using-a-different-account/

Here you will find also a couple of nice examples:

Automating SQL operations with Service Management Automation (SMA) and Invoke-Sqlcmd – challenges and solutions
40091.automating-sql-operations-with-service-management-automation-sma-and-invoke-sqlcmd-challenges-and-solutions.aspx

Hope I was able to help. Regards,
Stoyan

Answer 2

Hi

Suppose that you want to connect to sql server with powershell.

Here are some documentations for your reference.

https://octopus.com/blog/sql-server-powershell

https://www.sqlshack.com/connecting-powershell-to-sql-server/

https://stackoverflow.com/questions/45859333/sql-connection-from-powershell

Regards，

Zoe

---

If the answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Hot issues October