Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
anderslinden
Partner - Contributor III
Partner - Contributor III

SQL server connection in SaaS not able to share with others

Other users cannot reload apps with SQL server connection made by me. How can I share it?

The credentials are saved and I thought they would be reused by all users.

 

anderslinden_0-1635772897378.png

When another user (with all possible admin roles) tries to reload he gets:

 

anderslinden_1-1635773003314.png

 

 

BI Consultant, Business Information Providers
www.bipab.se
Labels (2)
1 Solution

Accepted Solutions
Vinay_B
Support
Support

Hi @anderslinden,

 

There are two types of credentials that can be used when making a connection in SaaS editions of Qlik Sense. If you leave the User defined credentials check box deselected, then only one set of credentials will be used for the connection. These credentials belong to the connection and will be used by anyone who can access it. For example, if the connection is in a shared space, every user in the space will be able to use these credentials. This one-to-one mapping is the default setting.

 

More information is mentioned here - https://help.qlik.com/en-US/cloud-services/Subsystems/ODBC_Connector_help/Content/Connectors_ODBC/SQ...

 

I hope this helps!

If this resolves your query, please click on "Accept as Solution" for confirmation. Thanks!

View solution in original post

2 Replies
Vinay_B
Support
Support

Hi @anderslinden,

 

There are two types of credentials that can be used when making a connection in SaaS editions of Qlik Sense. If you leave the User defined credentials check box deselected, then only one set of credentials will be used for the connection. These credentials belong to the connection and will be used by anyone who can access it. For example, if the connection is in a shared space, every user in the space will be able to use these credentials. This one-to-one mapping is the default setting.

 

More information is mentioned here - https://help.qlik.com/en-US/cloud-services/Subsystems/ODBC_Connector_help/Content/Connectors_ODBC/SQ...

 

I hope this helps!

If this resolves your query, please click on "Accept as Solution" for confirmation. Thanks!
anderslinden
Partner - Contributor III
Partner - Contributor III
Author

Thanks!

BI Consultant, Business Information Providers
www.bipab.se