How to Connect to SQL Server using Powershell

Sarabpreet Singh Anand

SQLServer - MVP Sarabpreet is SQLServer MVP, Consultant, Speaker, Trainer, Blogger and Community Lead. You can find him speaking at a local UG Event or a SQL Webcast. He has 11+ years of Experience and worked with Industry Leaders. He has many SQL Certifications under his belt. His core competency lies in administration of SQL Server. Always ready to help, online \offline. His life’s mantra is “Knowledge Increases by sharing so, Pass it on”.

You may also like...

7 Responses

  1. Jack Vamvas says:

    Hi, Nice information. If you need to connect via a Powershell script – see an example http://www.sqlserver-dba.com/2012/02/list-failed-sql-server-jobs-with-powershell.html

  2. GS Sohal says:

    cool .. Thanks for sharing … definitely .. will cause me to spend some time on command window 🙂

  3. Puneet says:

    I don’t have SSMS installed on my computer. Is there a way to connect to SQL server without installing the sql drivers? I am building some apps for operations guys and hence they want to use the app but don’t have SSMS installed on their machines

  1. July 14, 2012

    […] very easily use powershell to connect to SQL Server instance and see all the available databases (http://www.sarabpreet.com/?p=288), but by default powershell maintains security and hide all system level databases. Now the […]

  2. July 27, 2013
  3. July 28, 2013

    […] Sarabpreet had covered quite interesting ways to do the same … you may check his article over here (a big Thanks to Sarab for sharing the same […]

Leave a Reply