ServerConnection Constructor (String, String, String)

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

命名空间: Microsoft.SqlServer.Management.Common
程序集: Microsoft.SqlServer.ConnectionInfo (in microsoft.sqlserver.connectioninfo.dll)

语法

声明
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
)

参数

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

备注

仅 Microsoft .NET Framework 的 2.0 版本支持此命名空间、类或成员。

示例

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

平台

开发平台

有关支持的平台列表,请参阅安装 SQL Server 2005 的硬件和软件要求。

目标平台

有关支持的平台列表,请参阅安装 SQL Server 2005 的硬件和软件要求。

请参阅

参考

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

其他资源

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