[resolved] unable to connect to MS SQL server

[_AnonymousUser]

Hello I have a laptop on which MS SQL server 2012 is installed
the name of the server is INFOCREST-SERVE\ALIHIJAZI
I want to create DB connection metadata, yet I always get connection failure in Talend though I'm sure I'm supplying the correct login credentials
please advise the port is by default 1433 is this value correct?
is there anything I have to install first to be able to connect to SQL server?
the details of the error shows:Unknown server host name "INFOCREST-SERVE\ALIHIJAZI"

[Anonymous]

Hi,
Have you tried to put "localhost" into your DB server name to see if it works?
Best regards
Sabrina

[_AnonymousUser]

Hi,
Have you tried to put "localhost" into your DB server name to see if it works?
Best regards
Sabrina

yes but still it didn't work
I was thinking is it because I'm running the 32-bit Talend? (TOS_DI-win32-x86) 
knowing that my laptop has Windows 8 64-bit 
Please advise

[Anonymous]

Hi,
Is your JDK 32 bit? You should run TOS_DI-win-x86_64.exe on 64 bit OS. Can you successfully connect to your local MSSQL DB through client without using Talend Tool?
Have you tried to use component to achieve it? (tMSSqlConnection) Could you please show us your DB connection setting screenshot?
Best regards
Sabrina

[_AnonymousUser]

Hi,
Is your JDK 32 bit? You should run TOS_DI-win-x86_64.exe on 64 bit OS. Can you successfully connect to your local MSSQL DB through client without using Talend Tool?
Have you tried to use component to achieve it? (tMSSqlConnection) Could you please show us your DB connection setting screenshot?
Best regards
Sabrina

Hello
thank you for your prompt replies
well Yes I'm able to connect successfully to my local MSSQL database from SQL Management Studio and from other BI tool (QlikView)
My JDK is 64 bit and I already set the path to  it in Windows->Preferences->Java->Installed JREs

       

[Anonymous]

Hi,
On which build version you got this issue? Have you tried to use TOS_DI-win-x86_64.exe? Can you use tMSSqlConnection component to connect to your DB successfully?
Best regards
Sabrina

[_AnonymousUser]

Hi,
On which build version you got this issue? Have you tried to use TOS_DI-win-x86_64.exe? Can you use tMSSqlConnection component to connect to your DB successfully?
Best regards
Sabrina

I got this on both TOS_DI-win-x86_64.exe and TOS_DI-win32-x86.exe

[Anonymous]

Hi,
Are you using Talend 6.1 version? Did you get the same error when use tMSSqlConnection component to connect to your DB?
Best regards
Sabrina

[_AnonymousUser]

Hi,
On which build version you got this issue? Have you tried to use TOS_DI-win-x86_64.exe? Can you use tMSSqlConnection component to connect to your DB successfully?
Best regards
Sabrina

I added the tMSSqlConnection and configured it but I got errors when I run the job
       

[_AnonymousUser]

Hi,
Are you using Talend 6.1 version? Did you get the same error when use tMSSqlConnection component to connect to your DB?
Best regards
Sabrina

yes version 6.1
I attached the errors I got when using tMSSqlconnection component