I am just beginning to study "Beginning ASP.NET E-Commerce with Visual Basic.Net and Visual Studio.Net"

Here is my problem:

I have a login problem with the MSDE database. I guess it may be caused by web.config file. But I still don't know how to set to authentication mode in the web.config file through its code or any other way.


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



Would you tell me how could I solve the problem if you know?

Thanks a lot,

Diana (dianastudy3@yahoo.com)

Diana

Hi Diana, I am having exactly the same problem but from a different book.
Have you managed to resolve the situation, if so can you tell me how you did it.
Cheers
Andrew from England

Andrew,
Sorry I didn't check my email these days.
I will let you know when I figure it out. I don't have time right now but I will deal with it after my final exam done. You probably have already solved it now. Would you let me know how do you fix it if you do? Thanks.

Diana (dianastudy3@yahoo.com)

Diana

Hi Andrew,

Check this link for detail, it may help you. But I got a new problem and it is not necessary apply to you.

http://p2p.wrox.com/topic.asp?TOPIC_ID=1702

Diana

Diana