I have managed to resolve most issues myself by following the available guidance, but I am unable to login to my local instance of an SQL database using either 1) windows credentials or 2) using a working SQL Studio user name and password. Please see attached images.
For the windows credentials example, I have followed the guidance about where to locate sqljdbc_auth.dll (same folder as the JDBC driver), I have also amended the KNIME ini file to point it towards the right location. Within the Database URL I have also include the <intergratedSecurity=True> statement.
What am I doing wrong?
- Error using SQL user name:
- ERROR Database Reader 2:7 Execute failed: com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user 'Gavin'. ClientConnectionId:9537ef10-4d9c-414b-9821-766fbaae13de
- Error used windows credentials:
- ERROR Database Reader 2:7 Execute failed: com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user ''. ClientConnectionId:117fd1b7-52ec-4941-9ea7-9d6fec29e660