ConnectionSettings.LoginSecure Property

Gets or sets the Boolean property that specifies whether the connection is established to the server by using Windows Authentication or SQL Server Authentication.

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

public bool LoginSecure { get; set; }

Property Value

Type: System.Boolean
A Boolean value that specifies whether the connection is established to the server by using Windows Authentication or SQL Server Authentication.
If True (default), Windows Authentication is used to establish a connection with the server.
If False, SQL Server Authentication is used to establish a connection with the server.


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


Community Additions

ADD
Show: