We’ve been having difficulties sharing .tsm files between different users. The problems are:
The .tsm file appears to save the username and possibly the password of the user who created the .tsm file.
When a user other than the original creator of the .tsm file opens it, sometimes they can overwrite the username and password in the “Need More Information to Connect” dialog box, but after that it ends up creating a new connection, even though they may already have a connection defined to the same database using their username/password combination.
Every time they open a new .tsm file, the user has to re-authenticate to the database, even though it may be to a database they are already connected to.
There doesn’t appear to be a way to re-save the .tsm file with the new connection information for future use. The .tsm file gets saved with the original username stored in it.
I don’t see an easy way to choose which existing connection to use for the .tsm file, if I already have a connection defined, nor do I see any way to switch the query to use a different database if I want to run the same query against a different data set (production compared to test/dev database, for example).
When I last contacted support about this issue the reponse was that this would be fixed in this summer’s release. I’ve been testing with the beta versions as they come out (I just tested it with 126.96.36.1998) and the behavior appears to be the same.
Is this still in the works?