Connection String Using an User Instance

In this article I am going to explain about how to create connection string by using an user instance in .NET Framework.
  • 2499

Introduction

Here I am explaining how to create connection string by SQL server express instance using an user instance on SQL server express instance in .NET Framework.

To create connection string by using an user instance on SQL server express instance in .NET Framework we need to put filename which you want to attach, set the state of Trusted connection and user instance true. User Instance functionality creates a new SQL Server instance. It uses windows authentication over local named pipes to connect local SQL server instance and it works on local SQL server instance.

Syntax

Data Source=.\SQLExpress;Integrated Security=true; AttachDbFilename=|DataDirectory|\urdb.mdf;User Instance=true;

Further Readings

You may also want to read these related articles :

Ask Your Question 

Got a programming related question? You may want to post your question here

Programming Answers here

Categories

More Articles

© 2019 DotNetHeaven. All rights reserved.