ServerConnection Constructor (String, String, String)

  • Article

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)

Syntax

'Declaration
Public Sub New ( _
    serverInstance As String, _
    userName As String, _
    password As String _
)

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

public:
ServerConnection (
    String^ serverInstance, 
    String^ userName, 
    String^ password
)

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

public function ServerConnection (
    serverInstance : String, 
    userName : String, 
    password : String
)

Parameters

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

Remarks

This namespace, class, or member is supported only in version 2.0 of the Microsoft .NET Framework.

Example

'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.

Platforms

Development Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

Target Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

See Also

Reference

ServerConnection Class
ServerConnection Members
Microsoft.SqlServer.Management.Common Namespace

Other Resources

How to: Connect to an Instance of SQL Server by Using SQL Server Authentication in Visual Basic .NET
Connecting to an Instance of SQL Server