This topic has not yet been rated - Rate this topic

ConnectionSettings.LoginSecure Property

SQL Server 2008

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)

Syntax

C++

JScript

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.

Examples

VBNET


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

Reference

ConnectionSettings Class

ConnectionSettings Members

Microsoft.SqlServer.Management.Common Namespace

Other Resources

Connecting to an Instance of SQL Server

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD