Export (0) Print
Expand All

ServerConnection Constructor (String, String, SecureString)

Initializes a new instance of the ServerConnection class with the specified server instance and logon credentials.

Namespace:  Microsoft.SqlServer.Management.Common
Assembly:  Microsoft.SqlServer.ConnectionInfo (in Microsoft.SqlServer.ConnectionInfo.dll)

public function ServerConnection(
	serverInstance : String, 
	userName : String, 
	password : SecureString
)

Parameters

serverInstance
Type: String
A String value that specifies the name of the instance of the server with which the connection is established.
userName
Type: String
A String value that specifies the logon account used to establish the referenced connection.
password
Type: SecureString
A SecureString value that specifies the password used with the logon account.

C#

SecureString vpassword = new SecureString();
Char[] secChars = new Char[10] {'!', 'p', 'A', 's', 's', 'w', 'o', 'r', 'd', '1'};

foreach (Char c in secChars)
{
   vpassword.AppendChar(c);
}
String vlogin = "sa";
Server srv = new Server("(local)");
ServerConnection conn = new ServerConnection(srv.Name, vlogin, vpassword);

PowerShell

$vpassword = new-object System.Security.SecureString
$secChars = @("!", "p", "A", "s", "s", "w", "o", "r", "d", "1")
Foreach ($c in $secChars)
{
   $vpassword.AppendChar($c)
}
$vlogin = "sa"
$srv = new-object Microsoft.SqlServer.Management.Smo.Server("(local)")
$conn = new-object Microsoft.SqlServer.Management.Common.ServerConnection($srv.Name, $vLogin, $vpassword)

Community Additions

ADD
Show:
© 2014 Microsoft