Topic: Error when trying to register sql server DB
Error when trying to register sql server DB
I am new to Data Cleaner. I am trying to connect to sql server DB and its giving me below erro. Can some one help me with this ?
Could not establish JDBC connection
The TCP/IP connection to the host USMAYDWK21KW7P1, port 3341 has failed. Error: "Connection refused: connect. Verify the connection properties, check that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port, and that no firewall is blocking TCP connections to the port.".
Could not establish JDBC connection
The TCP/IP connection to the host USMAYDWK21KW7P1, port 3341 has failed. Error: "Connection refused: connect. Verify the connection properties, check that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port, and that no firewall is blocking TCP connections to the port.".
To be honest a SQL connection can fail at many places. Like the message already says it can be a firewall problem (client and/or server side). Sometimes it is just because there is no port assigned in SQL server for TCP/IP connections. Or username/password is wrong.
Questions: are you trying to connect to the SQL Server fron another computer or is it all local? Do you have admin rights rights on the SQL Server (if configuration has to be changed). Can you using ODBC (if on Windows).
Questions: are you trying to connect to the SQL Server fron another computer or is it all local? Do you have admin rights rights on the SQL Server (if configuration has to be changed). Can you using ODBC (if on Windows).
Hi there,
As we have released DC version 2.4 today, there's now an improved aid for entering the connection URL to MS SQL server. If you see the connection string text field, there's a questionmark-icon which you can click to get templates of different types of connection strings.
Also the docs have been updated with a few examples:
http://datacleaner.eobjects.org/resources/docs/2.4/html/ch10s03.html
As we have released DC version 2.4 today, there's now an improved aid for entering the connection URL to MS SQL server. If you see the connection string text field, there's a questionmark-icon which you can click to get templates of different types of connection strings.
Also the docs have been updated with a few examples:
http://datacleaner.eobjects.org/resources/docs/2.4/html/ch10s03.html
Log in by clicking the login link at the top of the screen
Go back to forum.
