ServerConnection Constructor (String)

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

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

Syntax

'Declaration
Public Sub New ( _
    serverInstance As String _
)
'Usage
Dim serverInstance As String 

Dim instance As New ServerConnection(serverInstance)
public ServerConnection(
    string serverInstance
)
public:
ServerConnection(
    String^ serverInstance
)
new : 
        serverInstance:string -> ServerConnection
public function ServerConnection(
    serverInstance : String
)

Parameters

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

Examples

VB

'Connect to a remote instance of SQL Server.
Dim srv As Server
'The strServer string variable contains the name of a remote instance of SQL Server.
srv = New Server(strServer)
'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

#The strServer string variable contains the name of a remote instance of SQL Server
$srv = new-Object Microsoft.SqlServer.Management.Smo.Server($strServer)
#The actual connection is made when a property is retrieved.
Write-Host $srv.Information.Version
$The connection is automatically disconnected when the Server variable goes out of scope.

See Also

Reference

ServerConnection Class

ServerConnection Overload

Microsoft.SqlServer.Management.Common Namespace

Other Resources

Connecting to an Instance of SQL Server