I have created a sql datasource on my WAS 7.0 server and tested ok. When i try create a SQL data services model in the designer i can select the jdbc data source but then get error
Thread: WebSphere Portlet Factory (event logging)
Msg: Component: DESIGNER
Error: 3 : Coordinator error.
The SQL builder encountered an error. Verify the DataSource name, SQL statement syntax, and the connectivity between application server and database. See WEB-INF/logs/event.log on the application server for additional detail.
I investigated the logs fort the application on the server and they are empty. However if i look at the SQL server that i am trying to connect to i get the message
Login failed for user ”. The user is not associated with a trusted SQL Server connection
Can anyone shed some light on why the was server can connect but the designer cannot? Does the designer use the same authentication as the application server uses (which is the sa sql account)
Pinned topic Sql Jdbc fails to connect in eclipse
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2011-04-05T17:28:23Z at 2011-04-05T17:28:23Z by V2M6_michael_tomkies
V2M6_michael_tomkies 270003V2M62 Posts
Re: Sql Jdbc fails to connect in eclipse2011-04-05T17:28:23ZThis is the accepted answer. This is the accepted answer.I stumbled across the solution to this on using sql builder. when you fetch entity names it fails. however i reconfigured my jdbc data sorce to use another sql account other than sa and was able to fetch entity. Not sure why the sa username is not liked as it has access to all dbs but alas i found a solution.