ServerConnection 생성자 (String, String, String)

SQL Server 2012

다른 버전

SQL Server 2005

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

네임스페이스: Microsoft.SqlServer.Management.Common
어셈블리: Microsoft.SqlServer.ConnectionInfo(Microsoft.SqlServer.ConnectionInfo.dll)

구문

C++

JScript

public ServerConnection(
	string serverInstance,
	string userName,
	string password
)

매개 변수

serverInstance: 유형: System.String
A String value that specifies the name of the instance of the server with which the connection is established.

userName: 유형: System.String
A String value that specifies the logon account used to establish the referenced connection.

password: 유형: System.String
A String value that specifies the password used with the logon account.

예

VBNET

'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