문서를 영문으로 보려면 영문 확인란을 선택하세요. 마우스 포인터를 텍스트 위로 이동시켜 팝업 창에서 영문 텍스트를 표시할 수도 있습니다.
|
번역
영문
|
Visual Studio 2017을 사용하는 것이 좋습니다.
ServerConnection 생성자 (String, String, String)
SQL Server 2012
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)
매개 변수
- 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.
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
표시: