I set up a user in SQL Server that would use SQL Server authentication from a Talend job's JDBC connection. I kept getting a login failure from both Talend and Management Studio. I could logon to Management Studio with Windows Authentication.
There's a server setting made at installation for authentication type that may need to be adjusted. Right-click on the server in Management Studio's and check the configuration.
Changing SQL Server Authentication Type Post-Installation |
No comments:
Post a Comment