MS SQL Server connection problem

[Anonymous]

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.

[Anonymous]

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

[Anonymous]

Hi
It's here.
Regards,
Pedro

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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