topic Re: MS SQL Server connection problem in Talend Studio

MS SQL Server connection problem

Anonymous — Sat, 16 Nov 2024 12:14:01 GMT

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.

Re: MS SQL Server connection problem

Anonymous — Fri, 20 Jul 2012 08:57:24 GMT

Hi
I can't find the image.
Please notice the limits:20 images per post, each image must be less then 1024x768 pixels and 200 KB.
Regards,
Pedro

Re: MS SQL Server connection problem

Anonymous — Fri, 20 Jul 2012 08:58:51 GMT

I shall give you the info as per the screen.

Re: MS SQL Server connection problem

Anonymous — Fri, 20 Jul 2012 09:02:44 GMT

the input parameters are as follows
DB Type: Microsoft SQL Server
Login: sa
Password: ********
Server: MPDBS-HP\SQLEXPRESS
Port: 1433
Database: care_demo

Re: MS SQL Server connection problem

Anonymous — Fri, 20 Jul 2012 09:05:49 GMT

Hi
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.

Regards,
Pedro

Re: MS SQL Server connection problem

Anonymous — Fri, 20 Jul 2012 09:08:37 GMT

Thanks,I'll do that. This is all happening on a single, local machine, not over a network. The Port 1433 is the number Talend puts in by default.

Re: MS SQL Server connection problem

Anonymous — Fri, 20 Jul 2012 09:16:40 GMT

OK, TCP/IP is enabled and the port is set as the default 1433. Where next?

Re: MS SQL Server connection problem

Anonymous — Fri, 20 Jul 2012 09:19:38 GMT

Hi
The IPALL is 1433?
What's the error log?
Regards,
Pedro

Re: MS SQL Server connection problem

Anonymous — Fri, 20 Jul 2012 09:29:31 GMT

Hiya
Can't see IPALL, where do I find that?
The error in Talend is 'Connection Failure. You must change the Database Settings' Impossible to initialize the connection!'
thanks
Mike

Re: MS SQL Server connection problem

Anonymous — Fri, 20 Jul 2012 09:35:03 GMT

Hi Mike
You can find it in SQL SERVER Management Studio.
Regards,
Pedro

Re: MS SQL Server connection problem

Anonymous — Fri, 20 Jul 2012 09:45:38 GMT

Hi Pedro
I thougth there should be an IP address tab on the TCP/IP properties but there isn't one!
Mike

Re: MS SQL Server connection problem

Anonymous — Fri, 20 Jul 2012 09:50:43 GMT

Hi
It's here.
Regards,
Pedro

Re: MS SQL Server connection problem

Anonymous — Fri, 20 Jul 2012 09:56:33 GMT

Hi Pedro
I'm obviously missing something because I can't find that tab at all. Sorry to be a pain but can you tell me how you got to it?
thanks
Mike

Re: MS SQL Server connection problem

Anonymous — Fri, 20 Jul 2012 09:59:06 GMT

Hi Mike
Do you insall sql server on your local machine?
Is there a program called SQL Server Management Studio?
Please find more info on Google about JDBC sql server.
Regards,
Pedro

Re: MS SQL Server connection problem

Anonymous — Fri, 20 Jul 2012 10:59:32 GMT

Hi Pedro
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.
Mike

Re: MS SQL Server connection problem

Anonymous — Fri, 20 Jul 2012 15:36:21 GMT

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?
Mike

Re: MS SQL Server connection problem

Anonymous — Mon, 23 Jul 2012 02:52:01 GMT

Hi Mike
Do you have any co-workers who are familiar with SQL Server JDBC?
Usually this is a little hard for novice.
Regards,
Pedro

Re: MS SQL Server connection problem

Anonymous — Mon, 23 Jul 2012 08:31:18 GMT

I shall be checking today. Is JDBC the only mechanism for Talend Tasks to talk to SQL Server?
thanks
Mike

Re: MS SQL Server connection problem

Anonymous — Mon, 23 Jul 2012 08:32:39 GMT

Hi Mike
Anather way is ODBC.
But if you are using 64bit system, ODBC might cause more error.
Regards,
Pedro

Re: MS SQL Server connection problem

Anonymous — Mon, 23 Jul 2012 08:36:55 GMT

OK thanks. I'll talk to my colleagues today asbout our options.
Mike