How to Share a Project with DB Query

[#1]

If my data comes from SQL Server with a SQL query, I need to create ODBC connection in my PC in advance. what if I want to share this data analysis to my colleague or put this project in JMP Live for others to access?

It just raises error like can't login.

[#2]

1. Should other users be able to update the data?
2. Which JMP version are you using?
3. How is your company handling usernames/passwords for database connections?

[#3]

1. Should other users be able to update the data? 

Yes, everyone who access the project can update the data or the data can be updated daily.

1. Which JMP version are you using?

Latest version, our company just deployed JMP LIVE.

1. How is your company handling usernames/passwords for database connections?

It is read only username and password, so it is shared by engineers and quality team.

[#4]

You can create a data connector, package that and then distribute that https://www.jmp.com/support/help/en/18.0/index.shtml#page/jmp/connect-to-a-database-using-data-conne... . Also I think in JMP Live you can manage who are able to update/refresh the data  https://www.jmp.com/support/help/en/18.1/jmplive/jmplive.shtml#1848059