The connection string in the web.config is like:
<connectionStrings>
<add name="myDataBase" connectionString="Data Source=.\SQLEXPRESS;Initial
Catalog=Health;Integrated Security=True"
providerName="System.Data.SqlClient" />
<add name="Health" connectionString="Data Source=.\SQLEXPRESS;Initial
Catalog=Health;Integrated Security=True"
providerName="System.Data.SqlClient" />
</connectionStrings>
The first one connection : myDataBase is used for web project. and the
second : Health is used for ClassLibrary.
Is there something I mak mistake:
"Tasos Vogiatzoglou" <tv*****@gmail.com>
???????:11**********************@u72g2000cwu.googl egroups.com...
Check the user you are connecting to the database.
Also check if you have impersonation enabled and check if the
impersonated user has right access to the database. ( If the connection
string has something like "Integrated Authenticaion=true" or SSPI
Authentication="True", then most probably you are trying to write to
the database using either the impersonated account or ASPNET).
Check the user permissions in the database