You are not logged in.
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.
Last edited by michaelpearson (2012-07-20 09:57:46)
There are many possibilities why the connection fails.
First, please check the SQL Server Management Studio to check the port.
Then make sure the TCP/IP is on.
Or close the firewall.
Yes, I installed SQL Server on my local machine and I have SQL Server Management Studio. This is the first time I have had anything to do with JDBC and I think that maybe this isn't installed correctly. I'm not even sure where it should be installed. I've checked the documentation but I don't find it clear on how and where to install it.
I've looked at all the documentation I've access to and Googled for help by still can't work out what is going on. I'm guessing that the answer lies with JDBC, but only guessing, but I'm out of my knowledge area here. Any idea where I can find what the correct JDBC installation for SQL Server/Talend should be?
i have a solution!! wow what a mess to find all the answers.
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"
TO C:\Program Files\Java\jre7\lib
5. Copy "ntlmauth.dll"
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:
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
the input parameters are as follows
DB Type: Microsoft SQL Server
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.