Kevin,
I'm using a database that I created in Sql Server called ESKUpload. I'm using Windows Authentication. For uid, I used the login name from SQL, which is also my computer log in. I tried it with and without my password for the computer.
I get the same error when I try to connect to Northwind.
Here is the connection string:
<add key="ESKTest\Connection" value="server=(local);uid=HIBIT\lharmes;pwd=xxxxx;database=ESKUpload;" />
<add key="ESKTest\DataAccessClass" value="DataAccessSql" />
Thanks for your help.
Linda
UPDATE:
I figured it out. I needed to change the connection string to use Windows Authentication. It is connecting correctly now.
Thanks.
Linda Harmes
HiBit Technologies, Inc.