>When running the MM Norhtwind Sample Application I get the following error message: Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection.
>
>When installing the MS SQL I believe I setup user 'sa' with a password of 'dbhsci'. When I am in VIsual Studio and click on the server explorer, I can see the Northwind files and actually retreive data from any of the tables.
>
>This is the code I have in the app.config file in the databases section:
>
><add key="CustA\Northwind\Connection" value="server=DBH8600;uid=sa;pwd=dbhsci;database=Northwind;" />
>
>Thanks in advance for any help you can offer me.
I'd try:
"server=DBH8600;trusted_connection=yes;database=Northwind;"
Sounds like SQL server is configured to use windows authentication only.
Cetin