Informatica Cloud: Trying to create a Connection with SQL Server

Question

I am trying to create a connection for SQL Server in Informatica Cloud to connect to a local database on my computer. Therefore I am doing the following settings:

Type: SQL Server
Runtime Environment: The one i created
Authentication Mode: Windows Authentication (Deprecated)
Host: Laptopname\SQLEXPRESS
Port: 1433
Database Name: AdventureWorks2012
Schema: sys
Code Page: UTF-8

Unfortunately, I am receiving an error and I don’t figure it out, which settings I need to change. It is the following error:

The connection test failed because of the following error: Error establishing socket to host and port, Reason: Connection refused

Of course i have googled the error and found a few sites, who showed how to solve this issue.

The one is the following:

https://knowledge.informatica.com/s/article/495917?language=en_US

I have already checked this and edited the SQL Server Configuration Manager to enable the TCP/IP

Unfortunatly this didnt work and the error appeares still.

Then i tried the solution from the next side:

https://knowledge.informatica.com/s/article/314982?language=en_US

For this solution i went to the Firewall and added in Inbound and Outbound the Port "1433".

I am not sure, if i did it right on this one, but it also didnt work and the error still appears.

Then i found this site, where they talk about giving access to remote connections to sql server:

https://community.adobe.com/t5/coldfusion-discussions/error-establishing-socket-to-host-reason-connection-refused-connect/td-p/2066238

here i have found the following code, which i ran in the sql server local database:

EXEC sp_configure 'remote access', 1;
GO  
RECONFIGURE;  
GO

This is also not working for the connection.

I went also to the Computer-Manager --> Local User and Groups --> Admins and added everything, which was in the Folder named like my Computer, which is also the name of my Secure Agent. With this step i wanted to make sure, that the secure agent is part of the admin Group on my pc. I am not sure, if this was done right by me.

However this step also did not work and the error still appears.

Now i am really lost at this topic and i dont know how to solve it.

Answer 1

When you create a Connection in IICS, you need to define a Runtime Environment (i.e Secure Agent or Group). That connection would then be established via this Secure Agent (Training, in your case). You need to ensure that this Secure Agent has access to tour target database, including firewalls etc.