Powershell / Credentials / Connect to SQL Server with PowerShell

How to login using SQL Server Management Object (SMO)


For windows authentication


SQL Authentication with hard coded password (note recommended)


Impersonate login as user using SQL authentication with secure credentials


So now we can repeatedly use those credentials



Similar Posts:

2 Responses to “ “Powershell / Credentials / Connect to SQL Server with PowerShell”

  1. Ramu says:

    Hi, Thanks For your Script. How to select database, Drop, delete and update table etc.,

    Please share those details

    • Barac says:

      Hi Ramu,
      You are welcome …
      You can use invoke-sqlcmd command to run SQL statement against your instance …
      $ConnStrDB = @{
      ‘Database’ = “yourdbname”
      ‘ServerInstance’ = “yourinstancename.database.windows.net”
      ‘Username’ = “yourusername”
      ‘Password’ = “yourpassword”
      ‘Query’ = “CREATE TABLE [dbo].[TestTAB](
      [id] [int] IDENTITY(1,1) NOT NULL,
      [Column01] [nvarchar](125) NULL
      ) ON [PRIMARY]
      Invoke-Sqlcmd @ConnStrDB

      You can as well user parameters and pass those values
      param (
      [string]$servername = “yourinstancename.database.windows.net”,
      [string]$username = “yourusername”,
      [string]$password = “yourpassword”,
      [string]$dbname = “yourdbname”


Leave a Reply

Your email address will not be published. Required fields are marked *