Error connecting to database [
[Informatica][ODBC SQL Server Driver][SQL Server]Cannot open database requested in login 'username'. Login fails.[DataDirect][ODBC lib] Driver's SQLSetConnectAttr failed
I am trying to connect to a MSSQL database through Informatica but its giving an error. Though I can successfully login when I make a direct attempt to connect to the server using the same ID
can some one help me with this issues?