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