This documentation is archived and is not being maintained.

SqlConnectionStringBuilder.UserInstance Property

Gets or sets a value that indicates whether to redirect the connection from the default SQL Server Express instance to a runtime-initiated instance running under the account of the caller.

Namespace: System.Data.SqlClient
Assembly: System.Data (in

public bool UserInstance { get; set; }
/** @property */
public boolean get_UserInstance ()

/** @property */
public void set_UserInstance (boolean value)

public function get UserInstance () : boolean

public function set UserInstance (value : boolean)

Not applicable.

Property Value

The value of the UserInstance property, or False if none has been supplied.

This property corresponds to the "User Instance" key within the connection string. If the value passed in is null when you try to set the property, the UserInstance property is reset. If the value has not been set and the developer tries to retrieve the property, the return value is False.


This feature is available only with the SQL Server 2005 Express Edition. For more information on user instances, see Working with User Instances and "User Instances for Non-Administrators" in SQL Server Books Online.

Windows 98, Windows Server 2000 SP4, Windows Millennium Edition, Windows Server 2003, Windows XP Media Center Edition, Windows XP Professional x64 Edition, Windows XP SP2, Windows XP Starter Edition

The Microsoft .NET Framework 3.0 is supported on Windows Vista, Microsoft Windows XP SP2, and Windows Server 2003 SP1.

.NET Framework

Supported in: 3.0, 2.0