Login to SQL SERVER with SA account and execute the following script to create user logins and users.
CREATE DATABASE InformaticaDB
USE MASTER
CREATE LOGIN INFO_SQL_USER01 WITH PASSWORD = 'Password' (Your own Password)
CREATE LOGIN INFO_SQL_USER02 WITH PASSWORD = 'Password' (Your own Password)
USE InformaticaDB;
CREATE USER INFO_SQL_USER01 FOR LOGIN INFO_SQL_USER01;
CREATE USER INFO_SQL_USER02 FOR LOGIN INFO_SQL_USER02;
If this error occurred, in my case it is SQL Server TCP/IP protocol status is Disabled and need to Enable it as follows.
Double Click on TCP/IP , Change the Enabled value to ‘YES’ as follows.
then ..
Click on ‘Test Connection’..
Then click ‘OK’ and Then ‘Next’. Then enter a password in Domain password and Confirm password.
Incase the following occurs.
Then it can be resolved by either of the following solution.
1) Just type in the internet explorer as follows:
http://YourComputerName:6001/adminconsole
2) Go to Informatica installation path and fine the ‘adminconsole’ file and do the following.
Replace following path http://@USER_INPUT_DOMAIN_HOSTNAME@:@USER_INPUT_DOMAIN_PORT_NUMBER@/adminconsole
to
