I am setting up a dev environment for a project, with informatica 9.1 and SQL Server 2012 on a Windows Server 2008 R2 machine.
Installation etc has finished fine and no issues reported so far.
When we are trying to run our first mapping/workflow, the SQL Server database connectivity is becoming a bottleneck.
I tried creating a native connection to SQL Server, and also odbc, both don't seem to work, the session in question just fails to initialize. The error message finally is
failed to prepare session
Am I missing something here? Any experiences?
Disclaimer: This is my first ever attempt to host Infa repository at SQL Server, and also, using source and target as SQL Server.