Server.ConnectionContext Propiedad

Artículo
07/14/2013

Gets the current server connection details for the instance of SQL Server.

Espacio de nombres: Microsoft.SqlServer.Management.Smo
Ensamblado: Microsoft.SqlServer.Smo (en Microsoft.SqlServer.Smo.dll)

Sintaxis

'Declaración
Public ReadOnly Property ConnectionContext As ServerConnection 
    Get
'Uso
Dim instance As Server 
Dim value As ServerConnection 

value = instance.ConnectionContext

public ServerConnection ConnectionContext { get; }

public:
virtual property ServerConnection^ ConnectionContext {
    ServerConnection^ get () sealed;
}

abstract ConnectionContext : ServerConnection 
override ConnectionContext : ServerConnection

final function get ConnectionContext () : ServerConnection

Valor de la propiedad

Tipo: Microsoft.SqlServer.Management.Common.ServerConnection
A ServerConnection object that specifies the details of the current connection to the instance of SQL Server.

Implementa

IAlienRoot.ConnectionContext

Comentarios

This property can be used to change connection settings, such as the name of the instance of SQL Server or the authentication type. The ConnectionContext property is represented by the ServerConnection class. When connecting to the local instance of SQL Server by using Windows Authentication, the default values are used. You do not have to set any properties.

Ejemplos

Server srv = new Server("(local)");
ServerConnection conContext = new ServerConnection();
conContext = srv.ConnectionContext;
conContext.LoginSecure = false;
conContext.Login = vlogin;
conContext.Password = vpassword;
Server srv2 = new Server(conContext);

PowerShell

$srv = new-object Microsoft.SqlServer.Management.Smo.Server("(local)")
$conContext = $srv.ConnectionContext
$conContext.LoginSecure = $FALSE
$conContext.Login = vlogin
$conContext.Password = vpassword
$srv2 = new-object Microsoft.SqlServer.Management.Smo.Server($conContext)