>Login problem is solved. I just changed the authentication mode in >the web.config file.

Would you tell me what do you exactly put code in the web.config file? I have the same problem, but still don't know how to set to authentication mode in the web.config file through its code or any other way.


Here is my problem:

I have a login problem with the MSDE database.

When I mannuelly do, I can only create a new database by Use Window NT Integrated Security.
If I use SQL Server Autherntication, it will show me the error msg "ADO Error: ' Login
falled for user 'sa'. Reason: Not associated with a trusted SQL Server connection'"

Now in the web.config file. I have followed the book used
<appSettings>
    <add key="ConnectionString" value="Server=Home\NetSDK;User ID=sa; Password=; Initial Catalog=WroxJokeShop" />
  </appSettings>

Certainly it showed me Server Error in '/WroxJokeShop' Application.
--------------------------------------------------------------------------------

Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection.

Source Error:


Line 11:
Line 12: ' Open the connection
Line 13: connection.Open()
Line 14:
Line 15: ' Return a SqlDataReader to the calling function


Thanks a lot,

Diana ([email protected])

Diana