[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"

[_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

it seems like it is unable to compile because the server name contains "\"?
INFOCREST-SERVE\ALIHIJAZI
could this be the problem?

[_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

can you read my previous replies on this thread?

[Anonymous]

Hi,

it seems like it is unable to compile because the server name contains "\"?
INFOCREST-SERVE\ALIHIJAZI

You got the same issue when use localhost instead, didn't you? We made a testing for v 6.1 on our side and it works.
Best regards
Sabrina

[_AnonymousUser]

Hi,

it seems like it is unable to compile because the server name contains "\"?
INFOCREST-SERVE\ALIHIJAZI

You got the same issue when use localhost instead, didn't you? We made a testing for v 6.1 on our side and it works.
Best regards
Sabrina

when I put localhost I get connection refused error (check image)

    
   

[_AnonymousUser]

Hi,

it seems like it is unable to compile because the server name contains "\"?
INFOCREST-SERVE\ALIHIJAZI

You got the same issue when use localhost instead, didn't you? We made a testing for v 6.1 on our side and it works.
Best regards
Sabrina
55433/mini_1.png_20160114-1051.png

when I put INFOCREST-SERVE\ALIHIJAZI I get an error message saying:
Unknown host name INFOCREST-SERVE\ALIHIJAZI

[Anonymous]

Hi,
To use a MSSQL named instance in TOS, you only put the server name in the host field. 
The instance name  should go in the Additional Parameters field. 
Login: yourDBlogin
Password: yourDBpwd
Server: INFOCREST-SERVE
Port: 1433
Database: yourdbname
Schema: dbo
Additional Parameters: instance=ALIHIJAZI
Let us know if it is OK with you.
Best regards
Sabrina

[_AnonymousUser]

Hi,
To use a MSSQL named instance in TOS, you only put the server name in the host field. 
The instance name  should go in the Additional Parameters field. 
Login: yourDBlogin
Password: yourDBpwd
Server: INFOCREST-SERVE
Port: 1433
Database: yourdbname
Schema: dbo
Additional Parameters: instance=ALIHIJAZI
Let us know if it is OK with you.
Best regards
Sabrina

oh yeah!!
it works
thank you very much indeed for your prompt replies and support
you are awesome!!

[Anonymous]

Hi,
Great it is fixed. Could you please click the "Set this topic as resolved" link which is right underneath your initial post? This way, other users will be informed that this thread has been resolved.

Best regards
Sabrina

[Anonymous]

Hi 

Iam getting below error while trying to connect to ms sql server .Can anyone help on this

Capture.PNG