View Single Post
  #1 (permalink)  
Old April 6th, 2007, 07:28 PM
JoinTTT JoinTTT is offline
Authorized User
 
Join Date: Mar 2007
Location: , , .
Posts: 19
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to JoinTTT
Default WebShop : I cannot make remote connection

Hi

I run the all code for Chapter 5. Very good this book.

I made change in web config for connecting db remotely. I comment the original line. and I added new line with same add name.

<connectionStrings>

    <add name="WebShop" connectionString="Data Source=(local)\SQLExpress;Initial Catalog=WebShop;User ID=sa;Password=xxxx" providerName="System.Data.SqlClient"/>
  </connectionStrings>


But When I try to run webshop, I got this error ("Login failed for user 'sa'. The user is not associated with a trusted SQL Server connection.")

Why do I this error?