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