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 System.Data.dll)

public bool UserInstance { get; set; }

Property Value

Type: System.Boolean
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 SQL Server Express User Instances (ADO.NET) and "User Instances for Non-Administrators" in SQL Server Books Online.

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

The .NET Framework and .NET Compact Framework do not support all versions of every platform. For a list of the supported versions, see .NET Framework System Requirements.

.NET Framework

Supported in: 3.5, 3.0, 2.0