Cannot able to open database requested by the login?

[Former Member]

Hi,

I am using SQL View as source. I have imported the view in DS and used as source in my mapping.

I am able to view the data in DS and the view has been given select authorization rights.

But when i tried to trigger the job, it is displaying the error

Cannot open database requested by the login?

Do you faced the same kind of issue?

kindly let me know what should be done to extract data from the SQL view?

[Former Member]

Hello

If you can see the data via the Designer, but not read the data when executing the job, this is typically missing job server configuration settings.  Did you create any local configuration (DSN, etc.) to allow you to connect to the source system on the Designer machine?  If so, do the same on the job server.  If you are using Windows authentication, the user/profile that executes the job server processes will need access to your source database too.

Michael

[former_member208363]

Hi Karthik,

Please import the related tables used in View and check if you can view the tables with the data.

BTW, what is the source DB?