I am attempting to add a new External Content Type (a SQL Server DB) (using Sharepoint Designer). I click "Add Connection" and select SQL Server as the type. I then enter the Database Server, DB name, and tick "Connect with User's Identity."
When I click OK, I get an error from Designer saying "Cannot Establish Connection to the Data Source. An unexpected internal error occurred in the Business Data Connectivity Shared Service: The specified user or domain group was not found."
1. What username/password is being used for this and where is it configured? (ie what user or domain group has not been found?)
2. Is there a way to simply use SQL Server authentication for this?
I am logged on to the machine as a domain administrator, who has sysadmin, etc rights to the SQL Server, and who has rights as Administrator in Sharepoint (in other words should have rights to do just about anything). The Authentication Type for
the site is set to Windows using Integration Windows Authentication using NTLM.
INTERESTINGLY, I CAN access the database using "Data Sources" using SQL Server authentication.
View Complete Post