I have configured a database with SourceType property as 2-stSqlServer, and set up a user and a password according to the SQL Server. When I add a query to it, and configure Server Name property with the database recently configured, the following message appears:
Table structure can’t be generated in the Database.
The following message was returned by the Database:
ErrorLocal = OpenConnectionError
Error #0x80004005
Description:Login failed for user ‘ELIPSE\ElipseTeste’.Reason: Not associated with a trusted SQL Server connection.
(Source: Microsoft OLE DB Provider for SQL Server)
(SQL State: 42000)
(NativeError: 18452)
How can I fix this?
Solution:
To do so, go to SQL Server’s safety and password options and set the option SQL and Windows. If it is set as Windows only, E3 will not be able to access the database/tables.
