I'm trying to set up a connection to a SQL Server database and I get an error saying that it is impossible to make a connection. I've tried to attach a screenshot that shows both the settings for the connection and the error but it fails to upload.
Hi Mike, If you are able to find out the issue, please post back. I am having the exact same issue where I am getting the Impossible to Initialize the connection. Thanks!
i have a solution!! wow what a mess to find all the answers.
so...
i had installed Talend DI 64 bit, i think this is the first issue to an easy solution, tho have not taken the time to uninstall and only try 32bit.
1. verify version of Talend that was installed via- Help -> About Talend Studio -> Installation Details
2. from same location verified version of Java that Talend was using, since i had both 6 and 7 installed.
3. Download jtds-1.2.6
4. Copy "jtds-1.2.6.jar"
FROM C:\Users\...\Desktop\jtds-1.2.6-dist
TO C:\Program Files\Java\jre7\lib
5. Copy "ntlmauth.dll"
FROM C:\Users\...\Desktop\jtds-1.2.6-dist\x64\SSO
TO C:\Program Files\Java\jre7\bin
6. Restarted PC
7. Set TCP port 1433 in SQL Server Configuration Manager under SQL Server Network Configuration -> Protocols for Server -> TCP/IP -> IPAll -> TCP Port (for some reason this was blank)
8. Added Additional parameters to connection setup:
?Integrated Security?=true
I am having exactly the same issue. Tried following the solution.
1. enabled tcp/ip port on MSSQL server at correct port
2. Since I am using 32 bit version, copied appropriate dll and jar file. Tried using both jtds-1.2.6-dist and jtds-1.3.0-dist but still getting following error
Connection failure. You must change the Database Settings.
java.lang.ClassCastException: net.sourceforge.jtds.jdbc.ConnectionJDBC3 cannot be cast to net.sourceforge.jtds.jdbc.ConnectionJDBC2
Any idea?
Thanks
Ap
the input parameters are as follows DB Type: Microsoft SQL Server Login: sa Password: ******** Server: MPDBS-HP\SQLEXPRESS Port: 1433 Database: care_demo
Hi Mike,
Earlier i had the same issue but it solved. I believe you might have "SQL Server Management Studio"(ssms).
- Are you able to login with SQL Server Management Studio with the above login/password then there is a problem. Check your security setting of SQL Server(is it windows authentication mode (or) SQL Server and windows authentication mode(both). If the security setting is windows authentication mode then change to both modes(SQL Server and Windows authentication mode).
- One more thing you need to verify if you are not able to login then check the properties of login(sa) which you can go through Security->Properties->Status. Select option enable if it is disabled.
All these changes done only if you are administrator user.
The above one is few reasons which you cannot connect sql server.
Regards
Arshad
the input parameters are as follows DB Type: Microsoft SQL Server Login: sa Password: ******** Server: MPDBS-HP\SQLEXPRESS Port: 1433 Database: care_demo
Hi Mike,
Earlier i had the same issue but it solved. I believe you might have "SQL Server Management Studio"(ssms).
- Are you able to login with SQL Server Management Studio with the above login/password "if not" then there is a problem. Check your security setting of SQL Server(is it windows authentication mode (or) SQL Server and windows authentication mode(both). If the security setting is windows authentication mode then change to both modes(SQL Server and Windows authentication mode).
- One more thing you need to verify if you are not able to login then check the properties of login(sa) which you can go through Security->Properties->Status. Select option enable if it is disabled.
All these changes done only if you are administrator user.
The above one is few reasons which you cannot connect sql server.
Regards
Arshad
update in the above sentence.
