Informatica installation using SQL Server Database(windows authentication)

0
votes

I am trying to install Informatica server . I am using SQL Express database and windows Authentication. I am able to connect to database using SSMS.

But when I try to give database details in Domain Configuration repository database information, I get below error.

I got the host name and service name details by running below queries in SSMS.

SELECT HOST_NAME() AS HostName
select @@SERVICENAME

Can someone please assist with this.

enter image description here

1
sql-serverinstallationwindows-authenticationinformaticainformatica-powercenter
looking at the host name.. looks like it is installed on your desktop.. what if you use LOCALHOST as hostname? - Harry
I get the same error when I use localhost as Host Name. - PythonDeveloper
have you had a look at this to see if you can use a custom connection string instead? stackoverflow.com/questions/40820087/… - Harry
or how about using the following for the connection string? jdbc:microsoft:sqlserver://LOCALHOST:1433;DatabaseName=SQLEXPRESS com.microsoft.jdbc.sqlserver.SQLServerDriver - Harry
I tried using jdbc:informatica:sqlserver://localhost:1433;SelectMethod=cursor;DatabaseName=SQLEXPRESS since this format automatically comes when I click on Custom JDBC string and replaces host details and port number but same error - PythonDeveloper

1 Answers

0
votes

The Database Service Name should be given is the Database you created for Informatica in SQL server.