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