Hi Franklin F. Wang,
Based on your description, I create a demo with SQL authentication, it works fine, please compare the connection string as below with yours.
<connectionStrings>
<add name="LinqToSQLWithSQLAuthentication.Properties.Settings.EFDemoConnectionString"
connectionString="Data Source=10.168.172.127;Initial Catalog=EFDemo;User ID=YourUserId;Password=YourPassword"
providerName="System.Data.SqlClient" />
</connectionStrings>
In addition, if the issue still exists, do you encounter any exception, could you please provide related connection string and detailed error message.
Best regards,
Cole Wu
MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to
MSDN Support, feel free to contact MSDNFSF@microsoft.com.