Error connecting to database [ [Informatica][ODBC SQL Server Driver][SQL Server]Cannot open database requested in login 'userid'. Login fails.[DataDirect][ODBC lib] Driver's SQLSetConnectAttr

Hi all,
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
and Password.

can some one help me with this issues?
msdbaAsked:
Who is Participating?
 
JuanCarnigliaConnect With a Mentor Commented:
Are you using a DSN ? Can you post the Connection String (minus password) here?

Greetings.
0
 
Alpesh PatelConnect With a Mentor Assistant ConsultantCommented:
May be user have no access to that database.
0
 
JuanCarnigliaConnect With a Mentor Commented:
If you can log in using using an application like SQL Explorer or the like, then it is a connection string issue.

Bye
0
 
msdbaAuthor Commented:
Thanks!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.