Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Business Layer Generator error connecting to SQL
Message
General information
Forum:
ASP.NET
Category:
The Mere Mortals .NET Framework
Environment versions
Environment:
C# 2.0
OS:
Windows Server 2003
Network:
Windows 2003 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01175079
Message ID:
01176307
Views:
8
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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform