Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

ServerConnection Constructor (String, String, String)

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 ServerConnection(
	string serverInstance,
	string userName,
	string password
)

Parameters

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

VB


'Declare a ServerConnection object variable to specify SQL authentication, login and password.
Dim conn As New ServerConnection
conn.LoginSecure = False
conn.Login = vlogin
conn.Password = vpassword
'Connect to the local, default instance of SQL Server.
Dim srv As Server
srv = New Server(conn)
'The actual connection is made when a property is retrieved.
Console.WriteLine(srv.Information.Version)
'The connection is automatically disconnected when the Server variable goes out of scope.


PowerShell

$conn = new-object Microsoft.SqlServer.Management.Common.ServerConnection
$conn.LoginSecure = $FALSE
$conn.Login = vlogin
$conn.Password = vpassword
#Connect to the local, default instance of SQL Server
$srv = new-object Microsoft.SqlServer.Management.Smo.Server($conn)
Write-Host $srv.Information.Version

Community Additions

ADD
Show:
© 2015 Microsoft