I can't give you a full answer on that (I still have many things to learn) but I will give you something that shuold put you on right track.

You should have a Web.Config file into your project. At the top of this file, add this line:

<identity impersonate="true">

>Hi Eric,
>
>It wasn't - I just made the change and it works OK now when I pass it a user id and password - thanks for the tip.
>
>However, I'd still like to be able to get it to work for testing purposes using windows authentication but when I use this connection string:
>
>Dim connSQL As SqlConnection = New SqlConnection("server=localhost;Integrated Security=sspi;Initial Catalog=AFX")
>
>... I get the following error:
>
>"Login failed for user 'BS-LTIBM-02475\ASPNET'"
>
>Any idea where it's getting user "ASPNET" from? It should be trying to connect with my windows user id which is not ASPNET...
>
>Thanks,
>
>Al
>
>
>
>
>
>>Is your server configured to accept mixed authentication or is it on Windows authentication (the later cannot accept uid and password to authenticate users).
>>
>>
>>>Hi,
>>>
>>>I am attempting to connect to my local SQL Server with the following connection string:
>>>
>>>Dim myConnection As SqlConnection = New SqlConnection("data source=localhost;user id=sa;password=blahblah;persist security info=True")
>>>
>>>
>>>I get the following error message: "Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection"
>>>
>>>Is there something wrong with my connection properties - or something I need to do in SQL server to get this to work?
>>>
>>>Thanks in advance,
>>>
>>>Al