Freigeben über


ServerConnection Constructor (String, String, String)

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
)

Parameter

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

Hinweise

Der Namespace, die Klasse oder das Element wird nur in der Version 2.0 von Microsoft .NET Framework unterstützt.

Beispiel

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

Plattformen

Entwicklungsplattformen

Eine Liste der unterstützten Plattformen finden Sie unterHardware- und Softwareanforderungen für die Installation von SQL Server 2005.

Zielplattforme

Eine Liste der unterstützten Plattformen finden Sie unterHardware- und Softwareanforderungen für die Installation von SQL Server 2005.

Siehe auch

Verweis

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

Andere Ressourcen

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