Write the Connection String used in ADO.Net to connect with SQL Server database?

Posted By: Avi

Date: 2 December 2009 12:23:20 AM

Answer:

Connection String with SQL Server Security Authentication (needs to include UserID and Password of database):

"Data Source=ServerName; Initial Catalog=DatabaseName; User Id=UserName; Password=UserPassword;"

Connection String with Trusted Authentication (UserID and Password of database is not required):

"Data Source=ServerName; Initial Catalog=DatabaseName; Integrated Security=SSPI;"

There are a lot of other parameters available like Application Name, Connection Timeout, Pooling, Max Pool Size, etc. which can be included in the Connection String as per requirements.

Posted By: eTechPlanet

Date: 2 December 2009 12:23:20 AM

Post a better Answer if you have

Name*

E-mail* (Will show your Gravatar icon)

Website