Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Facing issue with the OLEDB providers to connect to the SQL server ?

Hi Team,

I am facing an issue with the connection with OLEDB to MS sql server.

Please find the attached screen shot and suggest how to resolve the issue.

Thanks in advance.

Tags (1)
4 Replies
a_mullick
Contributor II

Re: Facing issue with the OLEDB providers to connect to the SQL server ?

Hi,

Have you confirmed that the user has appropriate permissions to read / select from the db?

Thanks,

Azam

delmak2000
Contributor

Re: Facing issue with the OLEDB providers to connect to the SQL server ?

Hi,

Can you also try logging in with an administrative user-id and password??

Your current screen shots shows you are using a windows authentication......which depends on the window user profile you are on....

Regards,

Ayodele

Arjunarao
Honored Contributor II

Re: Facing issue with the OLEDB providers to connect to the SQL server ?

Hi

Try like this. Hope it will help you.

Capture.JPG

Capture1.JPG

Arjunarao
Honored Contributor II

Re: Facing issue with the OLEDB providers to connect to the SQL server ?

Please try with above settings and let me know if any issues.

Community Browser