Page 1 of 1

MS SQL - SAMPLE CONNECTION STRING (ASP.NET)

PostPosted: Sun Mar 18, 2012 11:14 am
by webhostingindia
This is a sample connection string which you can use with MS SQL 2005 / 2008 under ASP.NET:

<connectionStrings>
<add name="connStr" providerName="System.Data.SqlClient" connectionString="Data Source=localhost;Initial Catalog=XXXX;User ID=XXXXX;Password=XXXXX;" />
</connectionStrings>

For security reasons, we have changed specific settings with XXXX

NOTE: You MUST include the full database name, which consit of the user prefix and the name that you have given, for example XXX_DB