Hi

I am doing my app in ASP.net.
 We installed sqlserver using windows authentication.
i am specifying my connection string like this
<add key="ConnectionString" value="Data Source=myservername; Initial Catalog=databasename;Integrated Security=SSPI;"/>

so its taking loged userid account and connecting to the database without any problem

In server ,under computer management i created one user say name 'commondb'.
In my aspx page i want to connect to this perticular 'commondb' user and want to do database maniplations.
Can i do this .If so how to pass the user id and password to connect string.

Pl advice me.

Try this:
<add key="connectionString" value="data source=myservername;user id=sa;password=mypassword;" />