INFA 10.1.1 running on Linux can connect to SQL Server for a PowerCenter repository database. So, I've got a couple of points:
1 - Are we talking about PowerCenter? So, you have a PowerCenter repository service and a PowerCenter Integration service, correct? The database connection is set on the Repository Service properties - not the integration service. Are you having issues starting the repository service?
2 - I'm guessing the answers to the above questions are "yes" - if that's the case, the connection string attribute is going to either be a DSN connection name (click the check box and enter connection name you've given in the ODBC.INI file) or a DSN-less connection where you supply the database hostname and database name in the format you have above.
3 - One issue might be that the ODBC connection doesn't work due to firewall-type issues of if your environment variables are incorrect ($ODBCHOME). You can test the ODBC connectivity using the SSGODBC utility that comes with Informatica to see if you can reach out to the database. Search the KB for SSGODBC to get the details.
Hopefully that will get you started in the right direction. I've configured 10.1.1 running on RHEL to SQL Server - so it is possible. We just need to figure out why it can't connect.
Many thanks for your reply. Yes, it is indeed Powercenter. We have to use an ODBC connection to connect to the Repo and the Domain DB's as Informatica doesn't ship the libraries to be able to establish native connectivity to SQL server from Linux. I'm able to start the repository service and the integration service using ODBC, however when I try to turn on 'High Availability persistence in Database' property in the integration service and restart the integartion service, it tries to ignore the DSN connection(which is what is enabled in the repository) and tries to connect using a DSN-less connection. It somehow expects us to provide a connect string(which I'm not sure as we don't have a native connection to the DB). Any clues?
Please open a service request at Informatica Global Customer Support (GCS) to get this clarified.
I fear that this can't work because - as you already mentioned - it seems that DB persistence requires a native connection. As long as Microsoft doesn't provide any other drivers than for Windows, that can't work.
Is there any error you get here
Informatica GCS have confirmed that this is a known error and will require an EBF. You still can create a DNS less connection, but with some constraints(which we cannot implement as we require a port number to be configured for the DB) as described in the following article :
Good to know, thanks a million for the info!
May you not have to wait too long for this EBF, I'll press my thumbs.
Cheers and take care,