confused with connections in asp.net

[kkshansid]

i m from asp background
i m very new to asp.net
n i m confused with connections in asp.net
i have a project in asp.net for practice
its web.config file which i think is a connection file has connection with sql express
what should i do to connect it with sql server 2005

 
<?xml version="1.0"?>
<configuration xmlns="http://schemas.microsoft.com/.NetConfiguration/v2.0">
<appSettings/>
<connectionStrings>
<add name="ConnectionString" connectionString="Data Source=localhost\SQLExpress;Initial Catalog=asd;Integrated Security=True" providerName="System.Data.SqlClient"/>
</connectionStrings>
<system.web>
<compilation debug="true"/>
<authentication mode="Windows"/>
 
 
</system.web>
 
</configuration>
 

[Bassem]

Simple connectionString

<add name="dbConnectionString" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirector y|\dbName.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True"
providerName="System.Data.SqlClient" />
Now put your database in the data directroy.

I hope it will help!
Regards,
Bassem

[kkshansid]

but i hav to connect it with sql server 2000 or 2005 which hav username and password and server authentication mode.your connection is still with sql express

[kunal pawar]

See "Data Source" is your sever name. Like tt\SQLExpress or may be TT its depeands when you install Sql Server 2005.

Or you can refer connectionstrings.com

[sangam56]

Hi kkshansid,
You can have the connectionstring in the web.config file like this:

 
<!-- Connection strings-->
<connectionStrings>
<remove name="MyConnectionString"></remove>
<add name="MyConnectionString" connectionString="Data Source=.\SQLEXPRESS;Initial Catalog=MyDB;User ID=mysqlusername;Password=mypassword;pooling=false" providerName="System.Data.SqlClient"/>
</connectionStrings>
 

Hope this helps.

[kkshansid]

what about authentication mode windows mode dont take user id and password

[sangam56]

You can just use Integrated Security=true in the connection string if you are going to use Windows Authentication mode.

 
<!-- Connection strings-->
<connectionStrings>
<remove name="MyConnectionString"></remove>
<add name="MyConnectionString" connectionString="Data Source=.\SQLEXPRESS;Initial Catalog=MyDB;Integrated Security=true;pooling=false" providerName="System.Data.SqlClient"/>
</connectionStrings>
 

Waiting you feedback. Thanks.

[kkshansid]

sql server 2005 details
server name=kkshansid
user id=sa
password=
it is sql server 2005 not sql express
what should be authentication mode?

[sangam56]

Now perhaps it is my turn to be confused! It seems you have some different requirement. I hope this link provides you much guidance.

http://www.connectionstrings.com/sql-server-2005

Hope you find the right connection string here. Thank you.