Connection String Using an User Instance

Posted in Connection String | Connection String Reference on June 29, 2012

Tags: SQL server express instance, connection string, Trusted connection, windows authentication

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

2275

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 :

	
	
	Connection Strings for SQL Server 2000
	

	
	
	Storing and Retrieving Connection Strings in ASP.NET 2.0/3.5 
	

	
	
	Connection Strings for SQL Server 2005
	

					
					Ask Your Question

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

Connection String Using an User Instance

Related Articles

Categories

More Articles