Connect to SQL Server using powershell

Question

I am using this powershell script below to connect to an instance of sql server. I am pretty sure that my username and password are correct.

$connectionString = "server={0};database={1};uid={2};pwd={3};"

$c = Get-Credential
Write-Host($ipAddress)
Write-Host  $c.username 
Write-Host  $c.GetNetworkCredential().password

$connectionString = [string]::Format( "server={0};database={1};uid={2};pwd={3};", "servername", "databasename",$c.username,$c.GetNetworkCredential().password) 
#open database connection to SQL Server

Write-Host  $connectionString
$conn = New-Object system.Data.SqlClient.SqlConnection
$conn.connectionstring = $connectionString
$conn.open

    switch ($conn.State)
{
"Open" { Write-Host "Do some work"; }
Default { Write-Host "The connection is $($conn.State).  There has been an error connecting to the database."; }
}

It is always falling to the default statement.

Mike Shepard · Accepted Answer · 2011-09-15 22:17:55Z

4

Your call to $conn.open is missing the (), so it would be returning a reference to that method rather than calling it.

answered Sep 15, 2011 at 22:17

Mike Shepard

18.4k7 gold badges59 silver badges72 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Connect to SQL Server using powershell

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related