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

[Anonymous]

I shall give you the info as per the screen.

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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.

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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