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