Have a look at :
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q306158
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q308157

>Tried that (putting that line at the vert top of the web.congfig file) and got this error message:
>
>"Configuration file 'c:\inetpub\wwwroot\WebAppTest1\web.config' does not contain a root tag."
>
>Thanks for your help - there sure is alot to learn - that's for sure.
>
>
>>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

Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com