I have a log in window that connects to Okta, retrieves the user profile and from there the connection string, and then uses that connection string to connect to the proper database. User A is able to log in just fine.
I created a new user and assigned him the same connection string that I copied from User A, however when I try to log in as this new user it says "Connection cache name cannot be null."
I displayed the MessageBox to output the cache name just in case it was missing from the json returned from Okta. However I can see that it is properly returning the cache name in the connection string.
What would cause it to miss the value even though it works for one user and not the other?